Slide 56
Slide 56 text
ϞχλϦϯάͰศརͳExtensionͨͪ
(pg_stat_statements)
ҎԼͷΫΤϦͰ10݅ͷεϩʔΫΤϦΛऔಘ͢Δ͜ͱ͕ՄೳͰ͢ɻ
=# SELECT
query
, calls
, total_time
, mean_time
, rows
, round(100 * shared_blks_hit / (shared_blks_hit + shared_blks_read), 2) AS hit_ratio
FROM
pg_stat_statements
WHERE
shared_blks_hit > 0
ORDER BY
total_time DESC
LIMIT 10;