explain.depesz.com

PostgreSQL's explain analyze made readable

Result: mEad

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

Group (cost=9,458.82..9,463.24 rows=884 width=621) (actual time=243.929..286.254 rows=125,965 loops=1)

  • Group Key: incident.incidentid
  • Buffers: shared hit=14056
2. 55.966 249.716 ↓ 142.5 125,965 1

Sort (cost=9,458.82..9,461.03 rows=884 width=621) (actual time=243.925..249.716 rows=125,965 loops=1)

  • Sort Key: incident.incidentid
  • Sort Method: quicksort Memory: 20786kB
  • Buffers: shared hit=14056
3. 193.750 193.750 ↓ 142.5 125,965 1

Index Scan using incident__index1 on incident incident (cost=0.56..9,415.56 rows=884 width=621) (actual time=0.029..193.75 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.25 ms
Execution time : 292.795 ms