Largest Indexes
Largest indexes in public schema
20 largest indexes by size| Table | Index name | Size | Definition | Comment |
|---|---|---|---|---|
| stats | idx_stats_1 | 456.0 KB |
btree (stat_repository_type)
|
|
| stats | idx_stats_7 | 272.0 KB |
btree (context)
|
|
| stats | idx_stats_5 | 272.0 KB |
btree (stat_coverage_type)
|
|
| participants_events | idx_participants_events_4 | 256.0 KB |
btree (event_outcome)
|
|
| stats | stats_id_key | 224.0 KB |
btree (id)
|
|
| stats | idx_stats_3 | 224.0 KB |
btree (stat_holder_type)
|
|
| stats | idx_stats_2 | 224.0 KB |
btree (stat_repository_id)
|
|
| stats | idx_stats_6 | 224.0 KB |
btree (stat_coverage_id)
|
|
| stats | idx_stats_4 | 224.0 KB |
btree (stat_holder_id)
|
|
| participants_events | idx_participants_events_1 | 208.0 KB |
btree (participant_type)
|
|
| participants_events | idx_participants_events_2 | 208.0 KB |
btree (participant_id)
|
|
| participants_events | idx_participants_events_3 | 208.0 KB |
btree (alignment)
|
|
| participants_events | participants_events_id_key | 208.0 KB |
btree (id)
|
|
| participants_events | idx_fk_par_eve_eve_id__eve_id | 208.0 KB |
btree (event_id)
|
|
| events | idx_events_1 | 192.0 KB |
btree (event_key)
|
|
| persons | idx_persons_1 | 168.0 KB |
btree (person_key)
|
|
| document_fixtures_events | idx_fk_doc_fix_eve_doc_fix_id__doc_fix_id | 120.0 KB |
btree (document_fixture_id)
|
|
| document_fixtures_events | idx_fk_doc_fix_eve_eve_id__eve_id | 120.0 KB |
btree (event_id)
|
|
| document_fixtures_events | document_fixtures_events_id_key | 120.0 KB |
btree (id)
|
|
| document_fixtures_events | idx_fk_doc_fix_eve_lat_doc_id__doc_id | 120.0 KB |
btree (latest_document_id)
|