explain.depesz.com

PostgreSQL's explain analyze made readable

Result: QOP8 : Optimization for: Optimization for: plan #Tsso; plan #FqSQ

Settings

Optimization path:

Optimization(s) for this plan:

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

Limit (cost=0.57..648.89 rows=1 width=26) (actual time=2.339..2.340 rows=1 loops=1)

2. 2.338 2.338 ↑ 3,351.0 1 1

Index Scan Backward using event_series_created_on_key on event_series (cost=0.57..2,172,541.75 rows=3,351 width=26) (actual time=2.338..2.338 rows=1 loops=1)

  • Index Cond: ((created_at < '2019-05-04 00:00:00'::timestamp without time zone) AND (key = 'key6'::text) AND (entity_id = '2000'::text))
Planning time : 0.167 ms
Execution time : 2.366 ms