explain.depesz.com

PostgreSQL's explain analyze made readable

Result: l1Ms

Settings
# exclusive inclusive rows x rows loops node
1. 40.695 160.397 ↑ 1.0 678,017 1

Append (cost=0.00..20,440.35 rows=678,018 width=47) (actual time=0.044..160.397 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.014..0.015 rows=0 loops=1)

  • Filter: ((a_date >= '2020-07-27'::date) AND (a_date <= '2020-07-28'::date))
3. 46.959 46.959 ↑ 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.029..46.959 rows=324,036 loops=1)

  • Filter: ((a_date >= '2020-07-27'::date) AND (a_date <= '2020-07-28'::date))
4. 72.728 72.728 ↑ 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.021..72.728 rows=353,981 loops=1)

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