explain.depesz.com

PostgreSQL's explain analyze made readable

Result: C8MK

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

Unique (cost=159,735.16..159,735.17 rows=1 width=36) (actual rows= loops=)

2. 0.000 0.000 ↓ 0.0

Sort (cost=159,735.16..159,735.17 rows=1 width=36) (actual rows= loops=)

  • Sort Key: (replace(concat(gaa.area_name, ', ', gsa.street_name, ', ', gha.house_number, '/', gha.building_number, ', подъезд ', pa.porche_num, ' (', bfa.box_feature_name, ')'), '/,'::text, ','::text)), hba.box_id
3. 0.000 0.000 ↓ 0.0

Nested Loop (cost=15,747.11..159,735.15 rows=1 width=36) (actual rows= loops=)

4. 0.000 0.000 ↓ 0.0

Nested Loop (cost=15,746.69..159,731.63 rows=1 width=158) (actual rows= loops=)

5. 0.000 0.000 ↓ 0.0

Nested Loop (cost=15,746.26..159,723.18 rows=1 width=83) (actual rows= loops=)

  • Join Filter: (gha.unified_street_id = gsa.unified_street_id)
6. 0.000 0.000 ↓ 0.0

Nested Loop (cost=14,746.26..56,549.77 rows=1 width=60) (actual rows= loops=)

7. 0.000 0.000 ↓ 0.0

Gather (cost=14,745.97..56,541.45 rows=1 width=68) (actual rows= loops=)

  • Workers Planned: 3
8. 0.000 0.000 ↓ 0.0

Parallel Hash Join (cost=13,745.97..55,541.35 rows=1 width=68) (actual rows= loops=)

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

Nested Loop (cost=303.52..42,096.87 rows=539 width=68) (actual rows= loops=)

10. 0.000 0.000 ↓ 0.0

Nested Loop (cost=302.96..37,397.51 rows=559 width=45) (actual rows= loops=)

11. 0.000 0.000 ↓ 0.0

Hash Join (cost=302.53..34,798.31 rows=2,956 width=37) (actual rows= loops=)

  • Hash Cond: (bfla.box_feature_id = bfa.box_feature_id)
12. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on box_feature_links_all bfla (cost=0.00..34,434.55 rows=22,916 width=8) (actual rows= loops=)

  • Filter: ((billing_id = 1) AND (((CURRENT_TIMESTAMP >= active_from) AND (CURRENT_TIMESTAMP <= active_to)) OR (active_to IS NULL)))
13. 0.000 0.000 ↓ 0.0

Hash (cost=302.11..302.11 rows=34 width=37) (actual rows= loops=)

14. 0.000 0.000 ↓ 0.0

Seq Scan on box_features_all bfa (cost=0.00..302.11 rows=34 width=37) (actual rows= loops=)

  • Filter: (((box_feature_name)::text ~~ '%ОУ%'::text) AND (billing_id = 1))
15. 0.000 0.000 ↓ 0.0

Index Scan using house_boxes_all_pkey on house_boxes_all hba (cost=0.42..0.88 rows=1 width=12) (actual rows= loops=)

  • Index Cond: ((box_id = bfla.box_id) AND (billing_id = 1))
16. 0.000 0.000 ↓ 0.0

Index Scan using geo_houses_all_pk on geo_houses_all gha (cost=0.56..8.41 rows=1 width=35) (actual rows= loops=)

  • Index Cond: ((house_id = hba.house_id) AND (billing_id = 1))
17. 0.000 0.000 ↓ 0.0

Parallel Hash (cost=13,442.44..13,442.44 rows=1 width=16) (actual rows= loops=)

18. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on geo_houses_link_campuses_all ghlc (cost=0.00..13,442.44 rows=1 width=16) (actual rows= loops=)

  • Filter: ((campus_id = 5) AND (billing_id = 1))
19. 0.000 0.000 ↓ 0.0

Index Only Scan using campuses_all_pk on campuses_all ca (cost=0.29..8.31 rows=1 width=8) (actual rows= loops=)

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

Gather (cost=1,000.00..103,157.76 rows=1,252 width=39) (actual rows= loops=)

  • Workers Planned: 4
21. 0.000 0.000 ↓ 0.0

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

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

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

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

Index Scan using porches_all_pkey on porches_all pa (cost=0.43..3.51 rows=1 width=8) (actual rows= loops=)

  • Index Cond: ((billing_id = 1) AND (porche_id = hba.porche))