explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 1tdH

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 1,801.233 ↑ 1.0 266,735 1

Unique (cost=179,230.62..187,549.89 rows=277,309 width=62) (actual time=1,575.498..1,801.233 rows=266,735 loops=1)

2. 1,640.011 1,640.011 ↑ 1.0 266,735 1

Sort (cost=179,230.62..179,923.90 rows=277,309 width=62) (actual time=1,575.495..1,640.011 rows=266,735 loops=1)

3. 1,073.242 1,073.242 ↑ 1.0 266,735 1

Hash Join (cost=2,684.43..154,160.32 rows=277,309 width=62) (actual time=61.214..1,073.242 rows=266,735 loops=1)

4. 506.671 506.671 ↑ 1.0 266,738 1

Hash Join (cost=1,342.43..145,538.96 rows=277,309 width=48) (actual time=35.788..506.671 rows=266,738 loops=1)

5. 195.122 195.122 ↑ 1.0 266,743 1

Index Scan using custid on incident pc0 (cost=0.43..138,304.05 rows=277,318 width=34) (actual time=0.027..195.122 rows=266,743 loops=1)

6. 35.742 35.742 ↑ 1.0 30,353 1

Hash (cost=962.58..962.58 rows=30,353 width=20) (actual time=35.742..35.742 rows=30,353 loops=1)

7. 18.958 18.958 ↑ 1.0 30,353 1

Index Scan using agent_pk on agent upd_op (cost=0.29..962.58 rows=30,353 width=20) (actual time=0.007..18.958 rows=30,353 loops=1)

8. 25.404 25.404 ↑ 1.0 30,353 1

Hash (cost=962.58..962.58 rows=30,353 width=20) (actual time=25.404..25.404 rows=30,353 loops=1)

9. 13.555 13.555 ↑ 1.0 30,353 1

Index Scan using agent_pk on agent ct_op (cost=0.29..962.58 rows=30,353 width=20) (actual time=0.006..13.555 rows=30,353 loops=1)