explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 5P8W

Settings

Optimization(s) for this plan:

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

Limit (cost=0.29..0.40 rows=10 width=8) (actual time=0.022..0.034 rows=10 loops=1)

2. 0.005 0.032 ↑ 8,010.0 10 1

ProjectSet (cost=0.29..929.87 rows=80,100 width=8) (actual time=0.021..0.032 rows=10 loops=1)

3. 0.027 0.027 ↑ 89.0 9 1

Index Scan using events_patient_repeating_patient_id_date_idx on events_patient_repeating (cost=0.29..523.36 rows=801 width=35) (actual time=0.019..0.027 rows=9 loops=1)

  • Index Cond: ((patient_id = 2,490,621) AND (event_date >= '2020-09-02'::date))
Planning time : 0.093 ms
Execution time : 0.054 ms