explain.depesz.com

PostgreSQL's explain analyze made readable

Result: rIE3 : with limit

Settings
# exclusive inclusive rows x rows loops node
1. 0.002 0.018 ↓ 0.0 0 1

Limit (cost=0.42..8.44 rows=1 width=4) (actual time=0.018..0.018 rows=0 loops=1)

  • Buffers: shared hit=3
2. 0.016 0.016 ↓ 0.0 0 1

Index Scan using md_appointment_event_id_ix on md_appointment a (cost=0.42..8.44 rows=1 width=4) (actual time=0.016..0.016 rows=0 loops=1)

  • Index Cond: (event_id = 396)
  • Filter: ((service_id = 128137) AND (customer_id = 3591878))
  • Buffers: shared hit=3
Planning time : 0.215 ms
Execution time : 0.045 ms