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';
^