1
SELECT pg_stat_statements.userid,
2
pg_stat_statements.dbid,
3
pg_stat_statements.queryid,
4
pg_stat_statements.query,
5
pg_stat_statements.calls,
6
pg_stat_statements.total_time,
7
pg_stat_statements.min_time,
8
pg_stat_statements.max_time,
9
pg_stat_statements.mean_time,
10
pg_stat_statements.stddev_time,
11
pg_stat_statements.rows,
12
pg_stat_statements.shared_blks_hit,
13
pg_stat_statements.shared_blks_read,
14
pg_stat_statements.shared_blks_dirtied,
15
pg_stat_statements.shared_blks_written,
16
pg_stat_statements.local_blks_hit,
17
pg_stat_statements.local_blks_read,
18
pg_stat_statements.local_blks_dirtied,
19
pg_stat_statements.local_blks_written,
20
pg_stat_statements.temp_blks_read,
21
pg_stat_statements.temp_blks_written,
22
pg_stat_statements.blk_read_time,
23
pg_stat_statements.blk_write_time
24
FROM pg_stat_statements(true) pg_stat_statements(userid, dbid, queryid, query, calls, total_time, min_time, max_time, mean_time, stddev_time, rows, shared_blks_hit, shared_blks_read, shared_blks_dirtied, shared_blks_written, local_blks_hit, local_blks_read, local_blks_dirtied, local_blks_written, temp_blks_read, temp_blks_written, blk_read_time, blk_write_time);