Paste number 65986: cmon you index sizes!

Index of paste annotations: 2 | 1

Paste number 65986: cmon you index sizes!
Pasted by: dbs
When:10 months, 6 days ago
Share:Tweet this! | http://paste.lisp.org/+1EWY
Channel:#openils-evergreen
Paste contents:
Raw Source | XML | Display As
evergreen=# \d metabib.keyword_field_entry
                                Table "metabib.keyword_field_entry"
    Column    |   Type   |                                Modifiers
--------------+----------+--------------------------------------------------------------------------
 id           | bigint   | not null default nextval('metabib.keyword_field_entry_id_seq'::regclass)
 source       | bigint   | not null
 field        | integer  | not null
 value        | text     | not null
 index_vector | tsvector | not null
Indexes:
    "keyword_field_entry_pkey" PRIMARY KEY, btree (id)
    "metabib_keyword_field_entry_index_vector_gin_idx" gin (index_vector)
Foreign-key constraints:
    "metabib_keyword_field_entry_field_pkey" FOREIGN KEY (field) REFERENCES config.metabib_field(id) ON DELETE CASCADE DEFERRABLE INITIALLY DEFERRED
    "metabib_keyword_field_entry_source_pkey" FOREIGN KEY (source) REFERENCES biblio.record_entry(id) ON DELETE CASCADE DEFERRABLE INITIALLY DEFERRED
Triggers:
    metabib_keyword_field_entry_fti_trigger BEFORE INSERT OR UPDATE ON metabib.keyword_field_entry FOR EACH ROW EXECUTE PROCEDURE oils_tsearch2('keyword')

evergreen=# select pg_size_pretty(pg_relation_size('metabib_keyword_field_entry_index_vector_gin_idx'));
ERROR:  relation "metabib_keyword_field_entry_index_vector_gin_idx" does not exist

Annotations for this paste:

Annotation number 2: All the index sizes and their row counts
Pasted by: dbs
When:10 months, 6 days ago
Share:Tweet this! | http://paste.lisp.org/+1EWY#2
Paste contents:
Raw Source | Display As
evergreen=# select relname, reltuples, pg_size_pretty(pg_relation_size(oid)) from pg_class where relname ~ 'index_vector';                     relname                      |  reltuples  | pg_size_pretty 
--------------------------------------------------+-------------+----------------
 authority_full_rec_index_vector_gin_idx          | 1.22796e+07 | 435 MB
 metabib_title_field_entry_index_vector_gin_idx   | 3.55614e+06 | 358 MB
 metabib_author_field_entry_index_vector_gin_idx  | 3.67644e+06 | 202 MB
 metabib_subject_field_entry_index_vector_gin_idx | 4.22746e+06 | 171 MB
 metabib_keyword_field_entry_index_vector_gin_idx | 3.31681e+06 | 1664 MB
 metabib_series_field_entry_index_vector_gin_idx  | 1.24157e+06 | 95 MB
 metabib_full_rec_index_vector_gin_idx            | 2.30113e+08 | 2839 MB
(7 rows)

Annotation number 1: schema qualification required, of course
Pasted by: dbs
When:10 months, 6 days ago
Share:Tweet this! | http://paste.lisp.org/+1EWY#1
Paste contents:
Raw Source | Display As
evergreen=# select pg_size_pretty(pg_relation_size('metabib.metabib_keyword_field_entry_index_vector_gin_idx'));
 pg_size_pretty 
----------------
 1664 MB
(1 row)

Colorize as:
Show Line Numbers
Index of paste annotations: 2 | 1

Lisppaste pastes can be made by anyone at any time. Imagine a fearsomely comprehensive disclaimer of liability. Now fear, comprehensively.