explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 06V

Settings
# exclusive inclusive rows x rows loops node
1. 9.575 9.575 ↓ 316.0 316 1

CTE Scan on cte_screening_packages sp (cost=47.22..48.17 rows=1 width=802) (actual time=0.300..9.575 rows=316 loops=1)

  • Filter: (cid = 3395)
2.          

CTE cte_screening_packages

3. 1.292 9.083 ↓ 7.5 316 1

Nested Loop Left Join (cost=0.82..47.22 rows=42 width=71) (actual time=0.295..9.083 rows=316 loops=1)

4. 0.484 3.999 ↓ 7.5 316 1

Nested Loop (cost=0.55..31.88 rows=42 width=39) (actual time=0.151..3.999 rows=316 loops=1)

5. 0.171 0.677 ↓ 6.9 473 1

Nested Loop (cost=0.27..8.08 rows=69 width=8) (actual time=0.050..0.677 rows=473 loops=1)

6. 0.018 0.018 ↑ 1.0 2 1

Seq Scan on company_transmission_vendors ctv (cost=0.00..1.21 rows=2 width=8) (actual time=0.011..0.018 rows=2 loops=1)

  • Filter: ((cid = 3395) AND (transmission_type_id = 5))
  • Rows Removed by Filter: 12
7. 0.488 0.488 ↓ 6.4 236 2

Index Scan using idx_property_transmission_vendors_company_transmission_vendor_i on property_transmission_vendors ptv (cost=0.27..3.07 rows=37 width=12) (actual time=0.017..0.244 rows=236 loops=2)

  • Index Cond: (company_transmission_vendor_id = ctv.id)
  • Filter: (cid = 3395)
8. 2.838 2.838 ↑ 1.0 1 473

Index Scan using idx_properties_id on properties p (cost=0.28..0.34 rows=1 width=39) (actual time=0.006..0.006 rows=1 loops=473)

  • Index Cond: (id = ptv.property_id)
  • Filter: ((is_disabled <> 1) AND (cid = 3395))
  • Rows Removed by Filter: 0
9. 3.792 3.792 ↑ 1.0 1 316

Index Scan using idx_property_addresses_property_id on property_addresses pa (cost=0.28..0.35 rows=1 width=21) (actual time=0.011..0.012 rows=1 loops=316)

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