explain.depesz.com

PostgreSQL's explain analyze made readable

Result: d7Ti : Optimization for: Optimization for: plan #mFlR; plan #S1xk

Settings

Optimization path:

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 0.002 0.015 ↑ 1.0 1 1

Limit (cost=0.00..0.05 rows=1 width=83) (actual time=0.015..0.015 rows=1 loops=1)

2. 0.013 0.013 ↑ 26,414,489.0 1 1

Seq Scan on event_series es (cost=0.00..1,426,367.70 rows=26,414,489 width=83) (actual time=0.013..0.013 rows=1 loops=1)

  • Filter: (key = 'health'::text)
Planning time : 0.110 ms
Execution time : 0.038 ms