Skip to content

Instantly share code, notes, and snippets.

@dlangille

dlangille/Bacula 5 indexes

Created May 2, 2014 15:07
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 dlangille/cbd6ee13bab80399aaf7 to your computer and use it in GitHub Desktop.
Save dlangille/cbd6ee13bab80399aaf7 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
Bacula 5 indexes
Based on http://www.databasesoup.com/2014/05/new-finding-unused-indexes-query.html
reason | schemaname | tablename | indexname | index_scan_pct | scans_per_write | index_size | table_size
------------------------+------------+---------------+-----------------------+----------------+-----------------+------------+------------
Never Used Indexes | public | jobhisto | jobhisto_idx | 0.00 | 0.00 | 2024 kB | 13 MB
Never Used Indexes | public | fileset | fileset_name_idx | 0.00 | 0.00 | 16 kB | 16 kB
Never Used Indexes | public | pathhierarchy | pathhierarchy_ppathid | 0.00 | 0.00 | 8192 bytes | 0 bytes
Low Scans, High Writes | public | file | file_jpfid_idx | 0.71 | 0.00 | 9166 MB | 32 GB
Low Scans, High Writes | public | file | file_pathid_idx | 2.55 | 0.00 | 7230 MB | 32 GB
Low Scans, High Writes | public | file | file_filenameid_idx | 3.78 | 0.00 | 6557 MB | 32 GB
Low Scans, High Writes | public | job | job_name_idx | 2.57 | 0.31 | 3568 kB | 18 MB
Low Scans, High Writes | public | media | media_idx | 2.33 | 0.13 | 88 kB | 3776 kB
(8 rows)
bacula=#
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment