explain.depesz.com

PostgreSQL's explain analyze made readable

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

Settings

Optimization path:

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 0.003 11,494.465 ↑ 1.0 1 1

Limit (cost=0.56..19,221.44 rows=1 width=83) (actual time=11,494.463..11,494.465 rows=1 loops=1)

2. 11,494.462 11,494.462 ↑ 5,503.0 1 1

Index Scan using event_series_created_created_at on event_series es (cost=0.56..105,772,488.56 rows=5,503 width=83) (actual time=11,494.461..11,494.462 rows=1 loops=1)

  • Filter: (('2018-07-12 00:00:00+00'::timestamp with time zone <@ valid) AND (key = 'health'::text))
  • Rows Removed by Filter: 14550000
Planning time : 0.159 ms
Execution time : 11,494.490 ms