explain.depesz.com

PostgreSQL's explain analyze made readable

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

Settings

Optimization path:

# exclusive inclusive rows x rows loops node
1. 150.818 8,708.750 ↑ 291.3 300,000 1

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

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

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

  • Join Filter: ((days.date)::timestamp with time zone <@ es.valid)
  • Rows Removed by Join Filter: 10440000
3. 1,455.076 1,455.076 ↑ 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.031..1,455.076 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.401 ms
Execution time : 8,719.044 ms