explain.depesz.com

PostgreSQL's explain analyze made readable

Result: dVY2 : Optimization for: Optimization for: plan #pme6; plan #kU7kn

Settings

Optimization path:

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 145.626 8,680.289 ↑ 291.3 300,000 1

Gather (cost=1,000.00..641,542,799.99 rows=87,375,753 width=36) (actual time=0.510..8,680.289 rows=300,000 loops=1)

  • Workers Planned: 4
  • Workers Launched: 4
2. 7,082.917 8,534.663 ↑ 364.1 60,000 5

Nested Loop (cost=0.00..632,804,224.69 rows=21,843,938 width=36) (actual time=0.538..8,534.663 rows=60,000 loops=5)

  • Join Filter: ((days.date)::timestamp with time zone <@ es.valid)
  • Rows Removed by Join Filter: 10440000
3. 1,451.745 1,451.745 ↑ 1.6 5,250,000 5

Parallel Seq Scan on event_series es (cost=0.00..934,067.50 rows=8,566,250 width=55) (actual time=0.204..1,451.745 rows=5,250,000 loops=5)

  • Filter: (key = 'health'::text)
  • Rows Removed by Filter: 5250000
4. 0.001 0.001 ↑ 1,275.0 2 26,250,000

Seq Scan on days (cost=0.00..35.50 rows=2,550 width=4) (actual time=0.001..0.001 rows=2 loops=26,250,000)

Planning time : 0.202 ms
Execution time : 8,690.259 ms