explain.depesz.com

PostgreSQL's explain analyze made readable

Result: PaxS

Settings
# exclusive inclusive rows x rows loops node
1. 2,551.482 96,141.661 ↓ 1.1 9,979,384 1

Append (cost=0.00..932,203.83 rows=9,405,116 width=513) (actual time=8.830..96,141.661 rows=9,979,384 loops=1)

2. 0.005 0.005 ↓ 0.0 0 1

Seq Scan on sending_registry (cost=0.00..0.00 rows=1 width=2,116) (actual time=0.005..0.005 rows=0 loops=1)

  • Filter: (campaign_id = ANY ('{1826,1827,1824,1833,1834,1838,1825,1835,1841,1842,1847,1848,1854,1858,1862,1856,1867,1866,1863,1870,1871,1843,1849,1855,1880,1844,1850,1872,1877,1878,1879,1845,1851,1881,1884,1846,1852,1887,1885,1882,1888,1896,1894,189 (...)
3. 76,787.801 76,787.801 ↑ 1.0 8,223,949 1

Index Scan using sending_registry_2018_12_campaign_id_idx on sending_registry_2018_12 (cost=0.43..807,463.42 rows=8,242,418 width=512) (actual time=8.822..76,787.801 rows=8,223,949 loops=1)

  • Index Cond: (campaign_id = ANY ('{1826,1827,1824,1833,1834,1838,1825,1835,1841,1842,1847,1848,1854,1858,1862,1856,1867,1866,1863,1870,1871,1843,1849,1855,1880,1844,1850,1872,1877,1878,1879,1845,1851,1881,1884,1846,1852,1887,1885,1882,1888,1896,1894 (...)
4. 16,802.373 16,802.373 ↓ 1.5 1,755,435 1

Index Scan using sending_registry_2019_01_campaign_id_idx on sending_registry_2019_01 (cost=0.43..124,740.42 rows=1,162,697 width=519) (actual time=12.762..16,802.373 rows=1,755,435 loops=1)

  • Index Cond: (campaign_id = ANY ('{1826,1827,1824,1833,1834,1838,1825,1835,1841,1842,1847,1848,1854,1858,1862,1856,1867,1866,1863,1870,1871,1843,1849,1855,1880,1844,1850,1872,1877,1878,1879,1845,1851,1881,1884,1846,1852,1887,1885,1882,1888,1896,1894 (...)