explain.depesz.com

PostgreSQL's explain analyze made readable

Result: K2EZ

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

Unique (cost=178,756.52..187,075.79 rows=277,309 width=62) (actual rows= loops=)

2. 0.000 0.000 ↓ 0.0

Sort (cost=178,756.52..179,449.79 rows=277,309 width=62) (actual rows= loops=)

  • Sort Key: pc0.incident_id, pc0.create_ts, pc0.create_by_id, pc0.last_upd_ts, pc0.last_upd_by_id, ct_op.first_name, ct_op.last_name, (concat(ct_op.last_name, ' ', ct_op.first_name)), upd_op.first_name, upd_op.last_name, (concat(upd_op.last_name, ' ', upd_op.first_name))
3. 0.000 0.000 ↓ 0.0

Hash Join (cost=2,210.32..153,686.21 rows=277,309 width=62) (actual rows= loops=)

  • Hash Cond: (pc0.create_by_id = ct_op.agent_id)
4. 0.000 0.000 ↓ 0.0

Hash Join (cost=1,105.38..145,301.91 rows=277,309 width=48) (actual rows= loops=)

  • Hash Cond: (pc0.last_upd_by_id = upd_op.agent_id)
5. 0.000 0.000 ↓ 0.0

Index Scan using custid on incident pc0 (cost=0.43..138,304.05 rows=277,318 width=34) (actual rows= loops=)

  • Index Cond: (cust_id = 0::numeric)
6. 0.000 0.000 ↓ 0.0

Hash (cost=725.53..725.53 rows=30,353 width=20) (actual rows= loops=)

7. 0.000 0.000 ↓ 0.0

Seq Scan on agent upd_op (cost=0.00..725.53 rows=30,353 width=20) (actual rows= loops=)

8. 0.000 0.000 ↓ 0.0

Hash (cost=725.53..725.53 rows=30,353 width=20) (actual rows= loops=)

9. 0.000 0.000 ↓ 0.0

Seq Scan on agent ct_op (cost=0.00..725.53 rows=30,353 width=20) (actual rows= loops=)