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
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)
evergreen=# select pg_size_pretty(pg_relation_size('metabib.metabib_keyword_field_entry_index_vector_gin_idx'));
pg_size_pretty
----------------
1664 MB
(1 row)