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?.
11000 rows affected
1 rows affected
1131 rows affected
ctid | city_id | city | other_names_lower |
---|---|---|---|
(87,93) | 11001 | %foobar | %fooелезbar |
(87,92) | 11000 | UPA BBTSQM | UPA BBTSQM |
(87,91) | 10999 | DGPPGIRCE HCCNE | DGPPGIRCE HCCNE |
86 rows affected
ctid | city_id | city | other_names_lower |
---|---|---|---|
(86,124) | 10908 | TCDPX TYFPTT | TCDPX TYFPTT |
(86,123) | 10907 | TUWQXMRRF HMEUMHNX | TUWQXMRRF HMEUMHNX |
(86,122) | 10906 | BIDIBVS GNYNW | BIDIBVS GNYNW |