Skip to content

Instantly share code, notes, and snippets.

@ryanaslett

ryanaslett/gist:6f7f773c94bf34c7f7ec5b163e08b00c

Created February 2, 2017 22:44
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save ryanaslett/6f7f773c94bf34c7f7ec5b163e08b00c to your computer and use it in GitHub Desktop.
Save ryanaslett/6f7f773c94bf34c7f7ec5b163e08b00c to your computer and use it in GitHub Desktop.
Download ZIP
Raw
gistfile1.txt
postgres=# select * from pg_statio_all_tables where relname in ('pg_class','pg_type');
relid | schemaname | relname | heap_blks_read | heap_blks_hit | idx_blks_read | idx_blks_hit | toast_blks_read | toast_blks_hit | tidx_blks_read | tidx_blks_hit
-------+------------+----------+----------------+---------------+---------------+--------------+-----------------+----------------+----------------+---------------
1247 | pg_catalog | pg_type | 8 | 58 | 13 | 65 | | | |
1259 | pg_catalog | pg_class | 114 | 742 | 30 | 611 | | | |
(2 rows)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment