explain.depesz.com

PostgreSQL's explain analyze made readable

Result: P5kl

Settings
# exclusive inclusive rows x rows loops node
1. 35.236 127.896 ↑ 1.0 678,017 1

Append (cost=0.00..20,440.35 rows=678,018 width=47) (actual time=0.027..127.896 rows=678,017 loops=1)

2. 0.015 0.015 ↓ 0.0 0 1

Seq Scan on aggregated_compact_landings (cost=0.00..0.00 rows=1 width=106) (actual time=0.015..0.015 rows=0 loops=1)

  • Filter: ((a_date >= '2020-07-27'::date) AND (a_date <= '2020-07-28'::date))
3. 38.013 38.013 ↑ 1.0 324,036 1

Seq Scan on aggregated_compact_landings_20200727 (cost=0.00..8,160.54 rows=324,036 width=47) (actual time=0.011..38.013 rows=324,036 loops=1)

  • Filter: ((a_date >= '2020-07-27'::date) AND (a_date <= '2020-07-28'::date))
4. 54.632 54.632 ↑ 1.0 353,981 1

Seq Scan on aggregated_compact_landings_20200728 (cost=0.00..8,889.72 rows=353,981 width=47) (actual time=0.013..54.632 rows=353,981 loops=1)

  • Filter: ((a_date >= '2020-07-27'::date) AND (a_date <= '2020-07-28'::date))
Planning time : 77.003 ms
Execution time : 148.143 ms