explain.depesz.com

PostgreSQL's explain analyze made readable

Result: s2Ts

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

Unique (cost=4,200.47..4,256.48 rows=1,867 width=62) (actual rows= loops=)

2. 0.000 0.000 ↓ 0.0

Sort (cost=4,200.47..4,205.14 rows=1,867 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

Nested Loop (cost=1.01..4,099.03 rows=1,867 width=62) (actual rows= loops=)

4. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.72..2,989.93 rows=1,867 width=48) (actual rows= loops=)

5. 0.000 0.000 ↓ 0.0

Index Scan using custid on incident pc0 (cost=0.43..1,890.15 rows=1,867 width=34) (actual rows= loops=)

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

Index Scan using agent_pk on agent ct_op (cost=0.29..0.58 rows=1 width=20) (actual rows= loops=)

  • Index Cond: (agent_id = pc0.create_by_id)
7. 0.000 0.000 ↓ 0.0

Index Scan using agent_pk on agent upd_op (cost=0.29..0.58 rows=1 width=20) (actual rows= loops=)

  • Index Cond: (agent_id = pc0.last_upd_by_id)