explain.depesz.com

PostgreSQL's explain analyze made readable

Result: GIS

Settings
# exclusive inclusive rows x rows loops node
1. 1.823 1.823 ↓ 18.0 18 1

CTE Scan on cte_screening_packages sp (cost=76.81..76.84 rows=1 width=802) (actual time=0.748..1.823 rows=18 loops=1)

  • Filter: (cid = 235)
2.          

CTE cte_screening_packages

3. 0.129 1.796 ↓ 18.0 18 1

Nested Loop Left Join (cost=53.14..76.81 rows=1 width=71) (actual time=0.744..1.796 rows=18 loops=1)

4. 0.029 1.145 ↓ 18.0 18 1

Nested Loop (cost=52.85..76.32 rows=1 width=39) (actual time=0.627..1.145 rows=18 loops=1)

5. 0.076 0.732 ↓ 6.4 32 1

Hash Join (cost=52.57..67.09 rows=5 width=8) (actual time=0.581..0.732 rows=32 loops=1)

  • Hash Cond: (ptv.company_transmission_vendor_id = ctv.id)
6. 0.183 0.183 ↓ 1.0 129 1

Index Only Scan using uk_property_transmission_vendors_cid_company_transmission_vendo on property_transmission_vendors ptv (cost=0.28..14.47 rows=127 width=12) (actual time=0.061..0.183 rows=129 loops=1)

  • Index Cond: (cid = 235)
  • Heap Fetches: 132
7. 0.011 0.473 ↑ 3.7 19 1

Hash (cost=51.42..51.42 rows=70 width=8) (actual time=0.473..0.473 rows=19 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
8. 0.462 0.462 ↑ 3.7 19 1

Index Scan using idx_company_transmission_vendors_transmission_type_id on company_transmission_vendors ctv (cost=0.28..51.42 rows=70 width=8) (actual time=0.159..0.462 rows=19 loops=1)

  • Index Cond: (transmission_type_id = 5)
  • Filter: (cid = 235)
  • Rows Removed by Filter: 143
9. 0.384 0.384 ↑ 1.0 1 32

Index Scan using pk_properties on properties p (cost=0.29..1.85 rows=1 width=39) (actual time=0.012..0.012 rows=1 loops=32)

  • Index Cond: ((cid = 235) AND (id = ptv.property_id))
  • Filter: (is_disabled <> 1)
  • Rows Removed by Filter: 0
10. 0.522 0.522 ↑ 1.0 1 18

Index Scan using idx_property_addresses_property_id on property_addresses pa (cost=0.29..0.47 rows=1 width=18) (actual time=0.024..0.029 rows=1 loops=18)

  • Index Cond: (property_id = p.id)
  • Filter: ((cid = 235) AND (address_type_id = 1) AND (cid = p.cid))
  • Rows Removed by Filter: 1
Planning time : 5.661 ms