pg_flame postgresql EXPLAIN ANALYZE 火焰图工具

version: "3"
services:
  postgres:
    image: postgres:9.6.11
    ports:
    - "5432:5432"
    environment:
    - "POSTGRES_PASSWORD:dalong"

git clone <a href="https://github.com/mgartner/pg_flame.git">https://github.com/mgartner/pg_flame.git</a>
goreleaser release --snapshot --skip-publish --rm-dist

CREATE TABLE users (
    id SERIAL PRIMARY KEY,
    userename text,
    userage integer
);
?
-- Indices -------------------------------------------------------
?
CREATE UNIQUE INDEX users_pkey ON users(id int4_ops);
?
?
?
CREATE TABLE userapps (
    id SERIAL PRIMARY KEY,
    appname text,
    appversion text,
    userid integer
);
?
-- Indices -------------------------------------------------------
?
CREATE UNIQUE INDEX userapps_pkey ON userapps(id int4_ops);
?
?
INSERT INTO "public"."userapps"("id","appname","appversion","userid")
VALUES
(1,E‘login‘,E‘v1‘,1),
(2,E‘view‘,E‘v2.0‘,2);
?
?
INSERT INTO "public"."users"("id","userename","userage")
VALUES
(1,E‘dalong‘,11),
(2,E‘app‘,22);

docker-compose  up -d

cat plan.json | ./dist/pg_flame_darwin_amd64/pg_flame > result.html