explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 2SBC

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

Unique (cost=964,223.92..964,224.02 rows=14 width=16) (actual rows= loops=)

2. 0.000 0.000 ↓ 0.0

Sort (cost=964,223.92..964,223.95 rows=14 width=16) (actual rows= loops=)

  • Sort Key: ca.campus_number, ca.campus_id
3. 0.000 0.000 ↓ 0.0

Nested Loop (cost=115,983.55..964,223.65 rows=14 width=16) (actual rows= loops=)

4. 0.000 0.000 ↓ 0.0

Index Only Scan using geo_areas_all_pk on geo_areas_all gaa (cost=0.43..8.45 rows=1 width=8) (actual rows= loops=)

  • Index Cond: ((area_id = 1) AND (billing_id = 1))
5. 0.000 0.000 ↓ 0.0

Gather (cost=115,983.12..964,215.06 rows=14 width=24) (actual rows= loops=)

  • Workers Planned: 4
6. 0.000 0.000 ↓ 0.0

Nested Loop (cost=114,983.12..963,213.66 rows=4 width=24) (actual rows= loops=)

7. 0.000 0.000 ↓ 0.0

Parallel Hash Join (cost=114,982.83..963,189.80 rows=58 width=16) (actual rows= loops=)

  • Hash Cond: (gha.unified_street_id = gsa.unified_street_id)
8. 0.000 0.000 ↓ 0.0

Parallel Hash Join (cost=12,946.36..861,040.20 rows=6,026 width=16) (actual rows= loops=)

  • Hash Cond: (gha.unified_house_id = ghlc.unified_house_id)
9. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on geo_houses_all gha (cost=0.00..847,035.37 rows=277,076 width=16) (actual rows= loops=)

  • Filter: (billing_id = 1)
10. 0.000 0.000 ↓ 0.0

Parallel Hash (cost=12,858.36..12,858.36 rows=7,040 width=16) (actual rows= loops=)

11. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on geo_houses_link_campuses_all ghlc (cost=0.00..12,858.36 rows=7,040 width=16) (actual rows= loops=)

  • Filter: (billing_id = 1)
12. 0.000 0.000 ↓ 0.0

Parallel Hash (cost=102,032.56..102,032.56 rows=313 width=16) (actual rows= loops=)

13. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on geo_streets_all gsa (cost=0.00..102,032.56 rows=313 width=16) (actual rows= loops=)

  • Filter: ((area_id = 1) AND (billing_id = 1))
14. 0.000 0.000 ↓ 0.0

Index Scan using campuses_all_pk on campuses_all ca (cost=0.29..0.41 rows=1 width=16) (actual rows= loops=)

  • Index Cond: ((campus_id = ghlc.campus_id) AND (billing_id = 1))