explain.depesz.com

PostgreSQL's explain analyze made readable

Result: xsuK : Optimization for: plan #5P8W

Settings

Optimization path:

# exclusive inclusive rows x rows loops node
1. 0.006 0.038 ↑ 90.9 11 1

ProjectSet (cost=0.29..11.99 rows=1,000 width=8) (actual time=0.025..0.038 rows=11 loops=1)

2. 0.001 0.032 ↑ 1.0 10 1

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

3. 0.031 0.031 ↑ 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.022..0.031 rows=10 loops=1)

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