explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 0dLS

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

Execution time: 56.167 msCTE Scan on step2 (cost=33,187.44..33,187.48 rows=2 width=338) (actual time=33.929..56.000 rows=2 loops=1)

2.          

CTE base

3. 55.993 55.993 ↑ 1.0 2 1

Nested Loop Left Join (cost=1.04..33,142.86 rows=2 width=338) (actual time=33.926..55.993 rows=2 loops=1)

4. 0.000 0.087 ↑ 1.0 2 1

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

  • Rows Removed by Join Filter: 560
  • Join Filter: (base.client_order_number = (vp_po_detail.client_order_number)::text)
5. 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)

6. 55.479 55.479 ↑ 1.0 2 1

Nested Loop Left Join (cost=0.49..31,508.19 rows=2 width=330) (actual time=33.805..55.479 rows=2 loops=1)

7. 0.012 0.012 ↑ 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.006..0.006 rows=1 loops=2)

8. 0.000 0.430 ↑ 3.7 281 2

Index Scan using vp_po_detail_item_key_idx on vp_po_detail (cost=0.56..804.49 rows=1,026 width=23) (actual time=0.018..0.215 rows=281 loops=2)

  • Rows Removed by Join Filter: 3666
  • Rows Removed by Filter: 396
  • Join Filter: (base.store_num = (vp_store.store_num)::text)
  • Index Cond: (vp_user.vendor_key = vendor_key)
  • Index Cond: (vp_item.item_key = item_key)
  • Filter: ((primary_email)::text = 'VENDORPORTAL@COLONYDISPLAY.COM'::text)
9. 54.542 54.542 ↑ 1.0 2 1

Nested Loop Left Join (cost=0.49..31,324.25 rows=2 width=326) (actual time=33.752..54.542 rows=2 loops=1)

10. 0.000 0.656 ↑ 1.0 1,834 2

Materialize (cost=0.00..133.51 rows=1,834 width=9) (actual time=0.003..0.328 rows=1,834 loops=2)

  • Rows Removed by Join Filter: 66
  • Join Filter: (base.carrier_name = (vp_carrier.carrier_name)::text)
11. 0.300 0.300 ↑ 1.0 1,834 1

Seq Scan on vp_store (cost=0.00..124.34 rows=1,834 width=9) (actual time=0.004..0.300 rows=1,834 loops=1)

12. 54.502 54.502 ↑ 1.0 2 1

Nested Loop Left Join (cost=0.49..31,319.46 rows=2 width=322) (actual time=33.720..54.502 rows=2 loops=1)

13. 0.000 0.030 ↑ 2.6 34 2

Materialize (cost=0.00..2.33 rows=89 width=11) (actual time=0.009..0.015 rows=34 loops=2)

14. 0.011 0.011 ↑ 2.6 34 1

Seq Scan on vp_carrier (cost=0.00..1.89 rows=89 width=11) (actual time=0.008..0.011 rows=34 loops=1)

15. 26.748 26.748 ↑ 1.0 1 2

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) (actual time=10.231..13.374 rows=1 loops=2)

16. 16.439 27.734 ↑ 1.0 2 1

Hash Right Join (cost=0.07..5,619.45 rows=2 width=310) (actual time=23.347..27.734 rows=2 loops=1)

  • Index Cond: (base.client_order_number = (client_order_number)::text)
  • Hash Cond: ((vp_item.item_number)::text = base.item_number)
17. 11.199 11.199 ↑ 1.0 161,845 1

Seq Scan on vp_item (cost=0.00..5,012.45 rows=161,845 width=12) (actual time=0.387..11.199 rows=161,845 loops=1)

18. 0.005 0.096 ↑ 1.0 2 1

Hash (cost=0.04..0.04 rows=2 width=306) (actual time=0.096..0.096 rows=2 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
19. 0.091 0.091 ↑ 1.0 2 1

CTE Scan on base (cost=0.00..0.04 rows=2 width=306) (actual time=0.024..0.091 rows=2 loops=1)

Planning time : 0.849 ms