explain.depesz.com

PostgreSQL's explain analyze made readable

Result: wKpJ

Settings
# exclusive inclusive rows x rows loops node
1. 0.092 0.092 ↑ 1.0 2 1

CTE Scan on base (cost=33,187.44..33,187.48 rows=2 width=306) (actual time=0.024..0.092 rows=2 loops=1)

2.          

CTE base

3. 0.003 0.089 ↑ 1.0 2 1

Nested Loop Left Join (cost=0.28..44.58 rows=2 width=206) (actual time=0.022..0.089 rows=2 loops=1)

4. 0.072 0.072 ↑ 1.0 2 1

Seq Scan on vp_user (cost=0.00..27.98 rows=2 width=8) (actual time=0.008..0.072 rows=2 loops=1)

  • Filter: ((primary_email)::text = 'VENDORPORTAL@COLONYDISPLAY.COM'::text)
  • Rows Removed by Filter: 396
5. 0.014 0.014 ↑ 1.0 1 2

Index Scan using vp_vendor_pkey on vp_vendor (cost=0.28..8.30 rows=1 width=34) (actual time=0.007..0.007 rows=1 loops=2)

  • Index Cond: (vp_user.vendor_key = vendor_key)
6.          

CTE step2

7. 0.000 0.000 ↓ 0.0 0

Nested Loop Left Join (cost=1.04..33,142.86 rows=2 width=338) (never executed)

  • Join Filter: (base_1.client_order_number = (vp_po_detail.client_order_number)::text)
8. 0.000 0.000 ↓ 0.0 0

Nested Loop Left Join (cost=0.49..31,508.19 rows=2 width=330) (never executed)

  • Join Filter: (base_1.store_num = (vp_store.store_num)::text)
9. 0.000 0.000 ↓ 0.0 0

Nested Loop Left Join (cost=0.49..31,324.25 rows=2 width=326) (never executed)

  • Join Filter: (base_1.carrier_name = (vp_carrier.carrier_name)::text)
10. 0.000 0.000 ↓ 0.0 0

Nested Loop Left Join (cost=0.49..31,319.46 rows=2 width=322) (never executed)

11. 0.000 0.000 ↓ 0.0 0

Hash Right Join (cost=0.07..5,619.45 rows=2 width=310) (never executed)

  • Hash Cond: ((vp_item.item_number)::text = base_1.item_number)
12. 0.000 0.000 ↓ 0.0 0

Seq Scan on vp_item (cost=0.00..5,012.45 rows=161,845 width=12) (never executed)

13. 0.000 0.000 ↓ 0.0 0

Hash (cost=0.04..0.04 rows=2 width=306) (never executed)

14. 0.000 0.000 ↓ 0.0 0

CTE Scan on base base_1 (cost=0.00..0.04 rows=2 width=306) (never executed)

15. 0.000 0.000 ↓ 0.0 0

Index Scan using vp_po_data_po_key_client_order_number_key on vp_po_data (cost=0.42..12,850.00 rows=1 width=23) (never executed)

  • Index Cond: (base_1.client_order_number = (client_order_number)::text)
16. 0.000 0.000 ↓ 0.0 0

Materialize (cost=0.00..2.33 rows=89 width=11) (never executed)

17. 0.000 0.000 ↓ 0.0 0

Seq Scan on vp_carrier (cost=0.00..1.89 rows=89 width=11) (never executed)

18. 0.000 0.000 ↓ 0.0 0

Materialize (cost=0.00..133.51 rows=1,834 width=9) (never executed)

19. 0.000 0.000 ↓ 0.0 0

Seq Scan on vp_store (cost=0.00..124.34 rows=1,834 width=9) (never executed)

20. 0.000 0.000 ↓ 0.0 0

Index Scan using vp_po_detail_item_key_idx on vp_po_detail (cost=0.56..804.49 rows=1,026 width=23) (never executed)

  • Index Cond: (vp_item.item_key = item_key)
Planning time : 0.834 ms
Execution time : 0.228 ms