Postgres 12

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?.

2 rows affected

st_astext
POLYGON((1.00089897378124 2.50000137693809,1.00088196726694 2.49982495767047,1.00083106723247 2.4996552652021,1.00074822975506 2.49949882072484,1.00063663824926 2.4993616363128,1.00050058112753 2.49924898388156,1.00034528699692 2.49916519259215,1.00017672372536 2.4991134824851,1.00000136909964 2.49909584073788,0.999825961888455 2.49911294530078,0.99965724287704 2.49916413884549,0.999501695824915 2.49924745402731,0.999365298301309 2.49935968908996,0.999253291973078 2.49949653090734,0.99916998117244 2.4996527207339,0.999118567485143 2.49982225629392,0.999101026715569 2.49999862244386,0.999118032956884 2.50017504154365,0.999168932684306 2.50034473391579,0.999251769867334 2.50050117838304,0.999363361136239 2.50063836287285,0.999499418114623 2.50075101545777,0.99965471221727 2.5008348069534,0.999823275580495 2.5008865172878,0.999998630403561 2.50090415924888,1.00017403788772 2.50088705485381,1.00034275720619 2.50083586140534,1.00049830455269 2.50075254623352,1.0006347023132 2.5006403110931,1.00074670878477 2.50050346912203,1.00083001961337 2.50034727908926,1.00088143320901 2.50017774330189,1.00089897378124 2.50000137693809))
POLYGON((1.00089898059966 2.51000138244211,1.00088197502382 2.50982496309573,1.00083107562976 2.50965527034015,1.00074823847015 2.50949882537825,1.00063664694738 2.50936164030274,1.00050058947455 2.50924898705469,1.00034529467219 2.50916519482647,1.00017673043403 2.50911348369466,1.00000137458395 2.50909584087613,0.999825965937655 2.5091129443623,0.999657245335465 2.50916413686626,0.99950169659799 2.50924745108332,0.999365297359196 2.5093596852943,0.999253289351841 2.50949652640584,0.999169976972682 2.50965271569956,0.999118561868159 2.50982225092023,0.99910101989716 2.50999861693737,0.999118025199079 2.51017503611601,0.999168924285286 2.51034472877561,0.999251761149967 2.5105011737279,0.999363352435657 2.51063835888164,0.999499409765326 2.51075101228384,0.999654704540245 2.51083480471867,0.999823268870868 2.51088651607809,0.999998624919231 2.51090415911058,1.00017403383945 2.51088705579215,1.0003427547495 2.51083586338416,1.00049830378189 2.51075254917671,1.00063470325778 2.5106403148875,1.00074671140829 2.51050347362181,1.00083002381489 2.51034728412149,1.00088143882695 2.5101777486732,1.00089898059966 2.51000138244211))

st_astext

POLYGON((1.00089897378124 2.50000137693809,1.00088196726694 2.49982495767047,1.00083106723247 2.4996552652021,1.00074822975506 2.49949882072484,1.00063663824926 2.4993616363128,1.00050058112753 2.49924898388156,1.00034528699692 2.49916519259215,1.00017672372536 2.4991134824851,1.00000136909964 2.49909584073788,0.999825961888455 2.49911294530078,0.99965724287704 2.49916413884549,0.999501695824915 2.49924745402731,0.999365298301309 2.49935968908996,0.999253291973078 2.49949653090734,0.99916998117244 2.4996527207339,0.999118567485143 2.49982225629392,0.999101026715569 2.49999862244386,0.999118032956884 2.50017504154365,0.999168932684306 2.50034473391579,0.999251769867334 2.50050117838304,0.999363361136239 2.50063836287285,0.999499418114623 2.50075101545777,0.99965471221727 2.5008348069534,0.999823275580495 2.5008865172878,0.999998630403561 2.50090415924888,1.00017403788772 2.50088705485381,1.00034275720619 2.50083586140534,1.00049830455269 2.50075254623352,1.0006347023132 2.5006403110931,1.00074670878477 2.50050346912203,1.00083001961337 2.50034727908926,1.00088143320901 2.50017774330189,1.00089897378124 2.50000137693809))

POLYGON((1.00089898059966 2.51000138244211,1.00088197502382 2.50982496309573,1.00083107562976 2.50965527034015,1.00074823847015 2.50949882537825,1.00063664694738 2.50936164030274,1.00050058947455 2.50924898705469,1.00034529467219 2.50916519482647,1.00017673043403 2.50911348369466,1.00000137458395 2.50909584087613,0.999825965937655 2.5091129443623,0.999657245335465 2.50916413686626,0.99950169659799 2.50924745108332,0.999365297359196 2.5093596852943,0.999253289351841 2.50949652640584,0.999169976972682 2.50965271569956,0.999118561868159 2.50982225092023,0.99910101989716 2.50999861693737,0.999118025199079 2.51017503611601,0.999168924285286 2.51034472877561,0.999251761149967 2.5105011737279,0.999363352435657 2.51063835888164,0.999499409765326 2.51075101228384,0.999654704540245 2.51083480471867,0.999823268870868 2.51088651607809,0.999998624919231 2.51090415911058,1.00017403383945 2.51088705579215,1.0003427547495 2.51083586338416,1.00049830378189 2.51075254917671,1.00063470325778 2.5106403148875,1.00074671140829 2.51050347362181,1.00083002381489 2.51034728412149,1.00088143882695 2.5101777486732,1.00089898059966 2.51000138244211))