explain.depesz.com

PostgreSQL's explain analyze made readable

Result: B6O : with limit 2

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

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

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