explain.depesz.com

PostgreSQL's explain analyze made readable

Result: mFlR

Settings

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 134.160 1,858.800 ↓ 27.3 150,000 1

Gather (cost=1,000.00..968,549.84 rows=5,503 width=83) (actual time=0.423..1,858.800 rows=150,000 loops=1)

  • Workers Planned: 4
  • Workers Launched: 4
2. 1,724.640 1,724.640 ↓ 21.8 30,000 5

Parallel Seq Scan on event_series es (cost=0.00..966,999.54 rows=1,376 width=83) (actual time=0.155..1,724.640 rows=30,000 loops=5)

  • Filter: (('2018-07-12 00:00:00+00'::timestamp with time zone <@ valid) AND (key = 'health'::text))
  • Rows Removed by Filter: 10470000
Planning time : 0.126 ms
Execution time : 1,863.841 ms