Created
October 8, 2013 14:59
-
-
Save dalen/6886074 to your computer and use it in GitHub Desktop.
This file contains hidden or 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
| tablename | indexname | num_rows | table_size | index_size | unique | number_of_scans | tuples_read | tuples_fetched | |
| -------------------------+-----------------------------------------+-------------+------------+------------+--------+-----------------+-------------+---------------- | |
| catalog_resources | catalog_resources_pkey | 1.87344e+07 | 14 GB | 8459 MB | Y | 0 | 0 | 0 | |
| catalog_resources | idx_catalog_resources_catalog | 1.87344e+07 | 14 GB | 4671 MB | Y | 4647 | 2893540 | 3646 | |
| catalog_resources | idx_catalog_resources_resource | 1.87344e+07 | 14 GB | 6749 MB | Y | 621431 | 690009 | 621053 | |
| catalog_resources | idx_catalog_resources_tags_gin | 1.87344e+07 | 14 GB | 19 GB | Y | 617 | 11255212 | 0 | |
| catalog_resources | idx_catalog_resources_type | 1.87344e+07 | 14 GB | 2058 MB | Y | 671 | 267296100 | 0 | |
| catalog_resources | idx_catalog_resources_type_title | 1.87344e+07 | 14 GB | 4777 MB | Y | 470 | 2865 | 2468 | |
| catalogs | catalogs_pkey | 9327 | 4088 kB | 3464 kB | Y | 0 | 0 | 0 | |
| catalogs | idx_catalogs_hash | 9327 | 4088 kB | 3464 kB | Y | 8034938 | 8033534 | 8033518 | |
| certname_catalogs | certname_catalogs_catalog_key | 7718 | 2192 kB | 3792 kB | Y | 44822 | 38633 | 37644 | |
| certname_catalogs | certname_catalogs_certname_key | 7718 | 2192 kB | 2992 kB | Y | 0 | 0 | 0 | |
| certname_catalogs | certname_catalogs_pkey | 7718 | 2192 kB | 5712 kB | Y | 0 | 0 | 0 | |
| certname_catalogs | idx_certname_catalogs_certname | 7718 | 2192 kB | 2992 kB | Y | 6267 | 6535 | 6267 | |
| certname_facts | certname_facts_pkey | 853237 | 659 MB | 645 MB | Y | 5401 | 1016662 | 24 | |
| certname_facts | idx_certname_facts_certname | 853237 | 659 MB | 1557 MB | Y | 900 | 900 | 900 | |
| certname_facts | idx_certname_facts_name | 853237 | 659 MB | 1027 MB | Y | 134 | 579185 | 28012 | |
| certname_facts_metadata | certname_facts_metadata_certname_key | 3498 | 1808 kB | 3184 kB | Y | 310618 | 310879 | 310618 | |
| certname_facts_metadata | certname_facts_metadata_pkey | 3498 | 1808 kB | 7144 kB | Y | 1842 | 1842 | 1842 | |
| certnames | certnames_pkey | 7176 | 7832 kB | 2960 kB | Y | 59154 | 59154 | 59154 | |
| edges | edges_pkey | 2.30321e+07 | 9273 MB | 18 GB | Y | 1001 | 3355704 | 0 | |
| reports | idx_reports_certname | 1.68008e+06 | 406 MB | 243 MB | Y | 1059 | 572631 | 0 | |
| reports | idx_reports_end_time | 1.68008e+06 | 406 MB | 68 MB | Y | 2 | 195550 | 0 | |
| reports | reports_pkey | 1.68008e+06 | 406 MB | 236 MB | Y | 269936 | 269936 | 269936 | |
| resource_events | constraint_resource_events_unique | 5.08439e+07 | 16 GB | 19 GB | Y | 0 | 0 | 0 | |
| resource_events | idx_resource_events_report | 5.08439e+07 | 16 GB | 11 GB | Y | 7397 | 343166 | 0 | |
| resource_events | idx_resource_events_resource_type | 5.08439e+07 | 16 GB | 3949 MB | Y | 0 | 0 | 0 | |
| resource_events | idx_resource_events_resource_type_title | 5.08439e+07 | 16 GB | 9635 MB | Y | 0 | 0 | 0 | |
| resource_events | idx_resource_events_status | 5.08439e+07 | 16 GB | 3747 MB | Y | 0 | 0 | 0 | |
| resource_events | idx_resource_events_timestamp | 5.08439e+07 | 16 GB | 3893 MB | Y | 0 | 0 | 0 | |
| resource_params | idx_resources_params_name | 308876 | 52 MB | 32 MB | Y | 0 | 0 | 0 | |
| resource_params | idx_resources_params_resource | 308876 | 52 MB | 44 MB | Y | 1366 | 1366 | 1366 | |
| resource_params | resource_params_pkey | 308876 | 52 MB | 37 MB | Y | 3324227 | 13129722 | 0 | |
| schema_migrations | schema_migrations_pkey | 0 | 8192 bytes | 16 kB | Y | 0 | 0 | 0 | |
| (32 rows) |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment