PG Monitoring review Query analysis, basic
Related to the current monitoring we need to review:
-
⛔ Query analysis, basic (with queryid, query text), based on pg_stat_statements-
⛔ Top-N by total_time -
⛔ Top-N by average query runtime -
⛔ Top-N by calls -
⛔ Top-N by rows -
⛔ Top-N By temp blocks - read/write -
⛔ Top-N by shared_blks hit/read, written/dirtied -
⛔ Top-N by block read and write time
-
Acceptance criteria:
-
Fix the metrics and the dashboard