Created
March 21, 2019 17:32
-
-
Save adivinho/756ebb95ddefa74b085ad51347b17ebc to your computer and use it in GitHub Desktop.
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
pg_stat_statements: | |
query: "SELECT | |
pg_get_userbyid(userid) as user, | |
pg_database.datname, | |
pg_stat_statements.queryid, | |
pg_stat_statements.query, | |
pg_stat_statements.calls, | |
pg_stat_statements.total_time as time_milliseconds, | |
pg_stat_statements.rows, | |
pg_stat_statements.shared_blks_hit, | |
pg_stat_statements.shared_blks_read, | |
pg_stat_statements.shared_blks_dirtied, | |
pg_stat_statements.shared_blks_written, | |
pg_stat_statements.local_blks_hit, | |
pg_stat_statements.local_blks_read, | |
pg_stat_statements.local_blks_dirtied, | |
pg_stat_statements.local_blks_written, | |
pg_stat_statements.temp_blks_read, | |
pg_stat_statements.temp_blks_written, | |
pg_stat_statements.blk_read_time, | |
pg_stat_statements.blk_write_time | |
FROM pg_stat_statements | |
JOIN pg_database | |
ON pg_database.oid = pg_stat_statements.dbid" | |
metrics: | |
- user: | |
usage: "LABEL" | |
description: "The user who executed the statement" | |
- datname: | |
usage: "LABEL" | |
description: "The database in which the statement was executed" | |
- queryid: | |
usage: "LABEL" | |
description: "Internal hash code, computed from the statement's parse tree" | |
- query: | |
usage: "LABEL" | |
description: "Processed query" | |
- calls: | |
usage: "COUNTER" | |
description: "Number of times executed" | |
- time_milliseconds: | |
usage: "COUNTER" | |
description: "Total time spent in the statement, in milliseconds" | |
- rows: | |
usage: "COUNTER" | |
description: "Total number of rows retrieved or affected by the statement" | |
- shared_blks_hit: | |
usage: "COUNTER" | |
description: "Total number of shared block cache hits by the statement" | |
- shared_blks_read: | |
usage: "COUNTER" | |
description: "Total number of shared blocks read by the statement" | |
- shared_blks_dirtied: | |
usage: "COUNTER" | |
description: "Total number of shared blocks dirtied by the statement" | |
- shared_blks_written: | |
usage: "COUNTER" | |
description: "Total number of shared blocks written by the statement" | |
- local_blks_hit: | |
usage: "COUNTER" | |
description: "Total number of local block cache hits by the statement" |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment