explain.depesz.com

PostgreSQL's explain analyze made readable

Result: IZyM

Settings
# exclusive inclusive rows x rows loops node
1. 0.041 1,107.397 ↓ 2.0 2 1

Unique (cost=65,015.80..65,015.96 rows=1 width=2,706) (actual time=1,107.356..1,107.397 rows=2 loops=1)

2. 0.144 1,107.356 ↓ 15.0 15 1

Sort (cost=65,015.80..65,015.80 rows=1 width=2,706) (actual time=1,107.354..1,107.356 rows=15 loops=1)

  • Sort Key: custordent1_.cdate, custordent1_.cust_ord_id, custordent1_.cuser, custordent1_.udate, custordent1_.uuser, custordent1_.owner_prtnr_id, custordent1_.owner_sale_cnl_id, custordent1_.owner_user_id, custordent1_.owner_vendor_id, custordent1_.owner_wrk_org_id, custordent1_.owner_wrk_org_tree_id, custordent1_.assg_date, custordent1_.assg_prio_id, custordent1_.assg_resp_date, custordent1_.assg_user, custordent1_.assg_wrk_grp_id, custordent1_.bs_prc_init, custordent1_.bs_prc_prd, custordent1_.bs_prc_usg, custordent1_.bsn_flow_spec_id, custordent1_.bsn_inter_spec_id, custordent1_.bsn_inter_id, custordent1_.cntc_id, custordent1_.cur_id, custordent1_.cust_id, custordent1_.cust_ord_chng_rsn_tp_id, custordent1_.cust_ord_date, custordent1_.due_date, custordent1_.edate, custordent1_.ent_rec_type_id, custordent1_.ext_cust_ord_id, custordent1_.ext_descr, custordent1_.extra_field1, custordent1_.extra_field10, custordent1_.extra_field2, custordent1_.extra_field3, custordent1_.extra_field4, custordent1_.extra_field5, custordent1_.extra_field6, custordent1_.extra_field7, custordent1_.extra_field8, custordent1_.extra_field9, custordent1_.fwd_sdate, custordent1_.is_cust_quote, custordent1_.is_fwd_dated, custordent1_.is_wrtn_apl, custordent1_.item_cnt, custordent1_.ord_st_id, custordent1_.prchs_ord_no, custordent1_.prtnr_acct_id, custordent1_.quote_edate, custordent1_.rltd_cust_id, custordent1_.sale_cnl_id, custordent1_.sale_prtnr_acct_id, custordent1_.sbmdate, custordent1_.sbmuser, custordent1_.sdate, custordent1_.tax_bs_prc_init, custordent1_.tax_bs_prc_prd, custordent1_.tax_bs_prc_usg, custordent1_.total_prc
  • Sort Method: quicksort Memory: 28kB
3. 54.917 1,107.212 ↓ 15.0 15 1

Nested Loop (cost=5.64..65,015.79 rows=1 width=2,706) (actual time=0.072..1,107.212 rows=15 loops=1)

4. 74.590 514.269 ↓ 5.5 89,671 1

Hash Join (cost=5.21..39,694.42 rows=16,452 width=2,706) (actual time=0.060..514.269 rows=89,671 loops=1)

  • Hash Cond: (custordent1_.ord_st_id = ordstentit2_.ord_st_id)
5. 303.510 439.650 ↓ 5.0 89,671 1

Hash Join (cost=3.61..39,461.25 rows=17,882 width=2,706) (actual time=0.024..439.650 rows=89,671 loops=1)

  • Hash Cond: (custordent1_.bsn_flow_spec_id = bsnflowspe3_.bsn_flow_spec_id)
6. 136.127 136.127 ↓ 1.0 432,908 1

Seq Scan on cust_ord custordent1_ (cost=0.00..37,677.14 rows=427,114 width=2,706) (actual time=0.004..136.127 rows=432,908 loops=1)

7. 0.001 0.013 ↑ 1.0 2 1

Hash (cost=3.59..3.59 rows=2 width=5) (actual time=0.013..0.013 rows=2 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
8. 0.012 0.012 ↑ 1.0 2 1

Seq Scan on bsn_flow_spec bsnflowspe3_ (cost=0.00..3.59 rows=2 width=5) (actual time=0.003..0.012 rows=2 loops=1)

  • Filter: ((shrt_code)::text = ANY ('{TAKE_GIFT,SIM_ORDER}'::text[]))
  • Rows Removed by Filter: 45
9. 0.014 0.029 ↑ 1.0 23 1

Hash (cost=1.31..1.31 rows=23 width=4) (actual time=0.029..0.029 rows=23 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
10. 0.015 0.015 ↑ 1.0 23 1

Seq Scan on ord_st ordstentit2_ (cost=0.00..1.31 rows=23 width=4) (actual time=0.006..0.015 rows=23 loops=1)

  • Filter: ((shrt_code)::text <> ALL ('{REJECTED,EXPIRED}'::text[]))
  • Rows Removed by Filter: 2
11. 538.026 538.026 ↓ 0.0 0 89,671

Index Scan using rel_14_fk on cust_ord_item custordite0_ (cost=0.43..1.53 rows=1 width=9) (actual time=0.006..0.006 rows=0 loops=89,671)

  • Index Cond: (cust_ord_id = custordent1_.cust_ord_id)
  • Filter: (cust_bill_acct_id = '75001415'::numeric)
  • Rows Removed by Filter: 6