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