explain.depesz.com

PostgreSQL's explain analyze made readable

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

Settings

Optimization path:

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 0.003 106.520 ↑ 1.0 1 1

Limit (cost=0.56..4.56 rows=1 width=83) (actual time=106.519..106.520 rows=1 loops=1)

2. 106.517 106.517 ↑ 26,414,501.0 1 1

Index Scan using event_series_created_created_at on event_series es (cost=0.56..105,641,238.56 rows=26,414,501 width=83) (actual time=106.517..106.517 rows=1 loops=1)

  • Filter: (key = 'health'::text)
  • Rows Removed by Filter: 150000
Planning time : 0.126 ms
Execution time : 106.541 ms