explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Mgmd : Optimization for: plan #5P8W

Settings

Optimization path:

# exclusive inclusive rows x rows loops node
1. 0.001 0.031 ↑ 1.0 10 1

Limit (cost=0.29..6.82 rows=10 width=35) (actual time=0.022..0.031 rows=10 loops=1)

2. 0.030 0.030 ↑ 80.1 10 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.021..0.030 rows=10 loops=1)

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