explain.depesz.com

PostgreSQL's explain analyze made readable

Result: atsY

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 59.061 ↑ 1.0 1 1

Finalize Aggregate (cost=2,613.08..2,613.32 rows=1 width=112) (actual time=59.061..59.061 rows=1 loops=1)

2. 20.497 62.171 ↓ 1.5 3 1

Gather (cost=2,612.47..2,612.68 rows=2 width=832) (actual time=58.388..62.171 rows=3 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
3. 38.055 41.674 ↑ 1.0 1 3 / 3

Partial Aggregate (cost=1,612.47..1,612.48 rows=1 width=832) (actual time=41.674..41.674 rows=1 loops=3)

4. 0.320 3.619 ↑ 1.3 2,774 3 / 3

Parallel Append (cost=0.00..545.70 rows=3,469 width=387) (actual time=0.026..3.619 rows=2,774 loops=3)

5. 2.667 2.667 ↑ 1.8 2,127 3 / 3

Parallel Seq Scan on ad_with_hierarchy_783_centrodsp_2020_09 (cost=0.00..394.30 rows=3,754 width=387) (actual time=0.024..2.667 rows=2,127 loops=3)

  • Filter: ((date >= '2020-09-01'::date) AND (date <= '2020-10-09'::date))
6. 0.632 0.632 ↑ 1.2 971 2 / 3

Parallel Seq Scan on ad_with_hierarchy_783_centrodsp_2020_10 (cost=0.00..134.05 rows=1,142 width=386) (actual time=0.026..0.948 rows=971 loops=2)

  • Filter: ((date >= '2020-09-01'::date) AND (date <= '2020-10-09'::date))
  • Rows Removed by Filter: 108
7. 0.000 0.000 ↓ 0.0 0 1 / 3

Parallel Seq Scan on ad_with_hierarchy_783_centrodsp (cost=0.00..0.00 rows=1 width=6,228) (actual time=0.001..0.001 rows=0 loops=1)

  • Filter: ((date >= '2020-09-01'::date) AND (date <= '2020-10-09'::date))