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?.
DO
oid datname datdba encoding datcollate datctype datistemplate datallowconn datconnlimit datlastsysoid datfrozenxid datminmxid dattablespace datacl
13436 postgres 10 6 en_GB.UTF-8 en_GB.UTF-8 f t -1 13435 479 1 1663 null
1 template1 10 6 en_GB.UTF-8 en_GB.UTF-8 t t -1 13435 479 1 1663 {=c/postgres,postgres=CTc/postgres}
13435 template0 10 6 en_GB.UTF-8 en_GB.UTF-8 t f -1 13435 479 1 1663 {=c/postgres,postgres=CTc/postgres}
353390 db_1621447606 10 6 en_GB.UTF-8 en_GB.UTF-8 f t -1 13435 479 1 353389 {=Tc/postgres,postgres=CTc/postgres,u_1621447606=C/postgres}
889767 db_585707487 10 6 en_GB.UTF-8 en_GB.UTF-8 f t -1 13435 479 1 889766 {=Tc/postgres,postgres=CTc/postgres,u_585707487=C/postgres}
49279 db_630388439 10 6 en_GB.UTF-8 en_GB.UTF-8 f t -1 13435 479 1 49278 {=Tc/postgres,postgres=CTc/postgres,u_630388439=C/postgres}
291593 db_15939310 10 6 en_GB.UTF-8 en_GB.UTF-8 f t -1 13435 479 1 291592 {=Tc/postgres,postgres=CTc/postgres,u_15939310=C/postgres}
779797 db_1337967259 10 6 en_GB.UTF-8 en_GB.UTF-8 f t -1 13435 479 1 779796 {=Tc/postgres,postgres=CTc/postgres,u_1337967259=C/postgres}
981985 db_1562251197 10 6 en_GB.UTF-8 en_GB.UTF-8 f t -1 13435 479 1 981984 {=Tc/postgres,postgres=CTc/postgres,u_1562251197=C/postgres}
295965 db_1446444312 10 6 en_GB.UTF-8 en_GB.UTF-8 f t -1 13435 479 1 295964 {=Tc/postgres,postgres=CTc/postgres,u_1446444312=C/postgres}
871282 db_1022751475 10 6 en_GB.UTF-8 en_GB.UTF-8 f t -1 13435 479 1 871281 {=Tc/postgres,postgres=CTc/postgres,u_1022751475=C/postgres}
304157 db_1927586891 10 6 en_GB.UTF-8 en_GB.UTF-8 f t -1 13435 479 1 304156 {=Tc/postgres,postgres=CTc/postgres,u_1927586891=C/postgres}
312349 db_1991213494 10 6 en_GB.UTF-8 en_GB.UTF-8 f t -1 13435 479 1 312348 {=Tc/postgres,postgres=CTc/postgres,u_1991213494=C/postgres}
871294 db_115091793 10 6 en_GB.UTF-8 en_GB.UTF-8 f t -1 13435 479 1 871293 {=Tc/postgres,postgres=CTc/postgres,u_115091793=C/postgres}
320541 db_181811866 10 6 en_GB.UTF-8 en_GB.UTF-8 f t -1 13435 479 1 320540 {=Tc/postgres,postgres=CTc/postgres,u_181811866=C/postgres}
328733 db_1207781903 10 6 en_GB.UTF-8 en_GB.UTF-8 f t -1 13435 479 1 328732 {=Tc/postgres,postgres=CTc/postgres,u_1207781903=C/postgres}
336925 db_843598491 10 6 en_GB.UTF-8 en_GB.UTF-8 f t -1 13435 479 1 336924 {=Tc/postgres,postgres=CTc/postgres,u_843598491=C/postgres}
345117 db_1519434255 10 6 en_GB.UTF-8 en_GB.UTF-8 f t -1 13435 479 1 345116 {=Tc/postgres,postgres=CTc/postgres,u_1519434255=C/postgres}
780143 db_2144804989 10 6 en_GB.UTF-8 en_GB.UTF-8 f t -1 13435 479 1 780142 {=Tc/postgres,postgres=CTc/postgres,u_2144804989=C/postgres}
361627 db_2107210411 10 6 en_GB.UTF-8 en_GB.UTF-8 f t -1 13435 479 1 361626 {=Tc/postgres,postgres=CTc/postgres,u_2107210411=C/postgres}
780140 db_1631090788 10 6 en_GB.UTF-8 en_GB.UTF-8 f t -1 13435 479 1 780139 {=Tc/postgres,postgres=CTc/postgres,u_1631090788=C/postgres}
552187 db_1832574427 10 6 en_GB.UTF-8 en_GB.UTF-8 f t -1 13435 479 1 552186 {=Tc/postgres,postgres=CTc/postgres,u_1832574427=C/postgres}
552176 db_879016088 10 6 en_GB.UTF-8 en_GB.UTF-8 f t -1 13435 479 1 552175 {=Tc/postgres,postgres=CTc/postgres,u_879016088=C/postgres}
890029 db_2053912457 10 6 en_GB.UTF-8 en_GB.UTF-8 f t -1 13435 479 1 890028 {=Tc/postgres,postgres=CTc/postgres,u_2053912457=C/postgres}
890553 db_626738832 10 6 en_GB.UTF-8 en_GB.UTF-8 f t -1 13435 479 1 890552 {=Tc/postgres,postgres=CTc/postgres,u_626738832=C/postgres}
890815 db_1165853281 10 6 en_GB.UTF-8 en_GB.UTF-8 f t -1 13435 479 1 890814 {=Tc/postgres,postgres=CTc/postgres,u_1165853281=C/postgres}
891077 db_787817010 10 6 en_GB.UTF-8 en_GB.UTF-8 f t -1 13435 479 1 891076 {=Tc/postgres,postgres=CTc/postgres,u_787817010=C/postgres}
1704841 db_393631957 10 6 en_GB.UTF-8 en_GB.UTF-8 f t -1 13435 479 1 1704840 {=Tc/postgres,postgres=CTc/postgres,u_393631957=C/postgres}
1704874 db_742709532 10 6 en_GB.UTF-8 en_GB.UTF-8 f t -1 13435 479 1 1704873 {=Tc/postgres,postgres=CTc/postgres,u_742709532=C/postgres}
891342 db_1400027868 10 6 en_GB.UTF-8 en_GB.UTF-8 f t -1 13435 479 1 891341 {=Tc/postgres,postgres=CTc/postgres,u_1400027868=C/postgres}
1704907 db_651307602 10 6 en_GB.UTF-8 en_GB.UTF-8 f t -1 13435 479 1 1704906 {=Tc/postgres,postgres=CTc/postgres,u_651307602=C/postgres}
1704973 db_352316175 10 6 en_GB.UTF-8 en_GB.UTF-8 f t -1 13435 479 1 1704972 {=Tc/postgres,postgres=CTc/postgres,u_352316175=C/postgres}
1096789 db_407663937 10 6 en_GB.UTF-8 en_GB.UTF-8 f t -1 13435 479 1 1096788 {=Tc/postgres,postgres=CTc/postgres,u_407663937=C/postgres}
1096798 db_1133621694 10 6 en_GB.UTF-8 en_GB.UTF-8 f t -1 13435 479 1 1096797 {=Tc/postgres,postgres=CTc/postgres,u_1133621694=C/postgres}
1175085 db_1139305050 10 6 en_GB.UTF-8 en_GB.UTF-8 f t -1 13435 479 1 1175084 {=Tc/postgres,postgres=CTc/postgres,u_1139305050=C/postgres}
1705182 db_831268309 10 6 en_GB.UTF-8 en_GB.UTF-8 f t -1 13435 479 1 1705181 {=Tc/postgres,postgres=CTc/postgres,u_831268309=C/postgres}
982011 db_34834306 10 6 en_GB.UTF-8 en_GB.UTF-8 f t -1 13435 479 1 982010 {=Tc/postgres,postgres=CTc/postgres,u_34834306=C/postgres}
1704560 db_2088595151 10 6 en_GB.UTF-8 en_GB.UTF-8 f t -1 13435 479 1 1704559 {=Tc/postgres,postgres=CTc/postgres,u_2088595151=C/postgres}
1704593 db_1645582515 10 6 en_GB.UTF-8 en_GB.UTF-8 f t -1 13435 479 1 1704592 {=Tc/postgres,postgres=CTc/postgres,u_1645582515=C/postgres}
1704656 db_2058682550 10 6 en_GB.UTF-8 en_GB.UTF-8 f t -1 13435 479 1 1704655 {=Tc/postgres,postgres=CTc/postgres,u_2058682550=C/postgres}
1791881 db_1541429292 10 6 en_GB.UTF-8 en_GB.UTF-8 f t -1 13435 479 1 1791880 {=Tc/postgres,postgres=CTc/postgres,u_1541429292=C/postgres}
1705531 db_495229927 10 6 en_GB.UTF-8 en_GB.UTF-8 f t -1 13435 479 1 1705530 {=Tc/postgres,postgres=CTc/postgres,u_495229927=C/postgres} 
SELECT 42