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?.
CREATE TABLE
INSERT 0 4
| txt |
|---|
| 101.130.92.131 20170216044929 news.yandex.ru/2962142 1418 405 Firefox/5.0 (compatible; MSIE 9.0; Windows NT 6.1; WOW64; Trident/5.0; chromeframe/12.0.742.112) |
| 101.223.89.23 20140225113343 newsru.com/9320081 1169 508 Opera/5.0 (compatible; MSIE 9.0; Windows NT 6.1; WOW64; Trident/5.0; .NET CLR 3.5.30729; .NET CLR 3.0.30729) |
| 195.110.57.89 20140308022412 lenta.ru/7637386 1696 206 Safari/5.0 (Windows; U; MSIE 9.0; Windows NT 8.1; Trident/5.0; .NET4.0E; en-AU) |
| 139.194.10.7 20140327225031 news.mail.ru/5474713 1473 411 Opera/5.0 (compatible; MSIE 9.0; Windows NT 6.1; Win64; x64; Trident/5.0) |
SELECT 4
CREATE TABLE
INSERT 0 3
| ip | city |
|---|---|
| 101.130.92.131 | Воронеж |
| 101.223.89.23 | Воронежcкая обл. |
| 101.130.100.131 | Ещё где-то |
SELECT 3
SELECT 4
| dt | link | agent | city |
|---|---|---|---|
| 2017-02-16 | news.yandex.ru/2962142 | Firefox/5.0 (compatible; MSIE 9.0; Windows NT 6.1; WOW64; Trident/5.0; chromeframe/12.0.742.112) | Воронеж |
| 2014-02-25 | newsru.com/9320081 | Opera/5.0 (compatible; MSIE 9.0; Windows NT 6.1; WOW64; Trident/5.0; .NET CLR 3.5.30729; .NET CLR 3.0.30729) | Воронежcкая обл. |
| 2014-03-27 | news.mail.ru/5474713 | Opera/5.0 (compatible; MSIE 9.0; Windows NT 6.1; Win64; x64; Trident/5.0) | null |
| 2014-03-08 | lenta.ru/7637386 | Safari/5.0 (Windows; U; MSIE 9.0; Windows NT 8.1; Trident/5.0; .NET4.0E; en-AU) | null |
SELECT 4