explain.depesz.com

PostgreSQL's explain analyze made readable

Result: LqAd

Settings
# exclusive inclusive rows x rows loops node
1. 172.268 172.268 ↓ 142.5 125,965 1

Index Scan using incident__index1 on incident incident (cost=0.56..9,415.56 rows=884 width=4) (actual time=0.035..172.268 rows=125,965 loops=1)

  • Index Cond: ((incident.customerid = 594) AND (incident.contractid = 614) AND (incident.incidentstatusid = 12) AND (incident.enforcementlevelid = 8))
  • Buffers: shared hit=14056
Planning time : 0.86 ms
Execution time : 177.628 ms