add batch remove batch split batch comment selection show hidden batches hide batch highlight batch
db<>fiddle
donate feedback about
By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
Help with an interesting Postgres question: Why isn't an Index Only Scan used on a partition accessed via the parent table?.
2600000 rows affected
ERROR:  could not extend file "pg_tblspc/120458/PG_9.6_201608131/120459/120466": No space left on device
HINT:  Check free disk space.

ERROR:  relation "foo" does not exist
LINE 1: ...iz) "size", siz/8192 pages, (select count(*) from foo)*8192/...
                                                             ^

ERROR:  relation "foo" does not exist
LINE 1: explain analyze select sum(b) from foo where a='a';
                                           ^

ERROR:  index "foo_btree_covering" does not exist

ERROR:  relation "foo" does not exist
LINE 1: explain analyze select sum(b) from foo where a='a';
                                           ^

ERROR:  index "foo_btree" does not exist

ERROR:  relation "foo" does not exist
LINE 1: explain analyze select sum(b) from foo where a='a';
                                           ^

ERROR:  index "foo_brin_4" does not exist

ERROR:  relation "foo" does not exist
LINE 1: explain analyze select sum(b) from foo where a='a';
                                           ^

ERROR:  index "foo_brin_2" does not exist

ERROR:  relation "foo" does not exist
LINE 1: explain analyze select sum(b) from foo where a='a';
                                           ^