clear markdown compare help donate or buy diddy dollings comments/suggestions/bugs a leap of faith? bible365
clear markdown donate comments/suggestions/bugs a leap of faith? bible365 diddy dollings
By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0. 756648 fiddles created (13609 in the last week).

create table foo as select bar::integer from generate_series(1,1e5) bar; create index foo_btree on foo using btree(bar); create index foo_gist on foo using gist(bar); create index foo_brin on foo using brin(bar);
100000 rows affected
 hidden batch(es)


SELECT relname, pg_size_pretty(pg_relation_size(C.oid)) "size" FROM pg_class C LEFT JOIN pg_namespace N ON (N.oid = C.relnamespace) WHERE nspname = current_schema ORDER BY pg_relation_size(C.oid) DESC;
relname size
foo_gist 4392 kB
foo 3544 kB
foo_btree 2208 kB
foo_brin 24 kB
 hidden batch(es)