indexes.txt

PRIMARY KEY, btree (id)
btree (foo_id, bar_id) WITH (fillfactor='100')
btree (foo_id, sample) WITH (fillfactor='100')
btree (foo_id, can_id) WITH (fillfactor='100')
btree (baz_id, sample) WITH (fillfactor='100')
btree (bar_id, sample) WITH (fillfactor='100')
btree (bar_id, can_id) WITH (fillfactor='100')
btree (moo_id, bar_id) WITH (fillfactor='100')
btree (moo_id, sample) WITH (fillfactor='100')
btree (moo_id, jaz_id) WITH (fillfactor='100')
btree (moo_id, can_id) WITH (fillfactor='100')
gin (hax)
gin (hax, foo_id)
gin (hax, baz_id)
gin (hax, bar_id)
gin (hax, moo_id)
gin (hax, sam_id)
gin (hax, nor_id)
gin (hax) WHERE sample < '-28671'::integer
gin (hax) WHERE sample < '-16384'::integer
gin (hax, ram_id)
gin (hax, jaz_id)
gin (hax, sto_id)
gin (hax, can_id)
gist (the_geom_webmercator) WITH (fillfactor='100')
gist (the_geom_webmercator, foo_id) WITH (fillfactor='100')
gist (the_geom_webmercator, foo_id) WITH (fillfactor='100') WHERE sample < '-16384'::integer
gist (the_geom_webmercator, baz_id) WITH (fillfactor='100')
gist (the_geom_webmercator, bar_id) WITH (fillfactor='100')
gist (the_geom_webmercator, bar_id) WITH (fillfactor='100') WHERE sample < '-28671'::integer
gist (the_geom_webmercator, bar_id) WITH (fillfactor='100') WHERE sample < '-16384'::integer
gist (the_geom_webmercator, moo_id) WITH (fillfactor='100')
gist (the_geom_webmercator, moo_id) WITH (fillfactor='100') WHERE sample < '-28671'::integer
gist (the_geom_webmercator, moo_id) WITH (fillfactor='100') WHERE sample < '-16384'::integer
gist (the_geom_webmercator, sam_id) WITH (fillfactor='100')
gist (the_geom_webmercator, sam_id) WITH (fillfactor='100') WHERE sample < '-28671'::integer
gist (the_geom_webmercator, sam_id) WITH (fillfactor='100') WHERE sample < '-16384'::integer
gist (the_geom_webmercator, nor_id) WITH (fillfactor='100')
gist (the_geom_webmercator) WITH (fillfactor='100') WHERE sample < '-28671'::integer
gist (the_geom_webmercator) WITH (fillfactor='100') WHERE sample < '-16384'::integer
gist (the_geom_webmercator) WITH (fillfactor='100') WHERE sample < '-31744'::integer
gist (the_geom_webmercator, ram_id) WITH (fillfactor='100')
gist (the_geom_webmercator, ram_id) WITH (fillfactor='100') WHERE sample < '-28671'::integer
gist (the_geom_webmercator, ram_id) WITH (fillfactor='100') WHERE sample < '-16384'::integer
gist (the_geom_webmercator, jaz_id) WITH (fillfactor='100')
gist (the_geom_webmercator, sto_id) WITH (fillfactor='100')
gist (the_geom_webmercator, can_id) WITH (fillfactor='100')
btree (sam_id, bar_id) WITH (fillfactor='100')
btree (sam_id, moo_id) WITH (fillfactor='100')
btree (sam_id, sample) WITH (fillfactor='100')
btree (sam_id, jaz_id) WITH (fillfactor='100')
btree (sam_id, can_id) WITH (fillfactor='100')
btree (nor_id, sample) WITH (fillfactor='100')
btree (ram, bar, hnst text_pattern_ops) WITH (fillfactor='100')
btree (zip) WITH (fillfactor='100')
btree (sample) WITH (fillfactor='100')
btree (ram_id, bar_id) WITH (fillfactor='100')
btree (ram_id, moo_id) WITH (fillfactor='100')
btree (ram_id, sample) WITH (fillfactor='100')
btree (ram_id, jaz_id) WITH (fillfactor='100')
btree (ram_id, can_id) WITH (fillfactor='100')
btree (jaz_id, sample) WITH (fillfactor='100')
btree (sto_id, sample) WITH (fillfactor='100')
btree (can_id, sample) WITH (fillfactor='100')