explain.depesz.com

PostgreSQL's explain analyze made readable

Result: lD8t : discouts_1m_ComboEmpty

Settings
# exclusive inclusive rows x rows loops node
1. 0.032 34,309.138 ↓ 0.0 0 1

Sort (cost=1,966,649.53..1,966,651.86 rows=933 width=268) (actual time=34,309.138..34,309.138 rows=0 loops=1)

  • Sort Key: otop.name, o.name, mot.name, mo.name
  • Sort Method: quicksort Memory: 25kB
2. 0.004 34,309.106 ↓ 0.0 0 1

HashAggregate (cost=1,966,118.34..1,966,603.50 rows=933 width=268) (actual time=34,309.106..34,309.106 rows=0 loops=1)

3. 0.001 34,309.102 ↓ 0.0 0 1

Nested Loop Left Join (cost=6.61..1,966,090.35 rows=933 width=268) (actual time=34,309.102..34,309.102 rows=0 loops=1)

4. 0.002 34,309.101 ↓ 0.0 0 1

Nested Loop Left Join (cost=1.96..1,961,725.42 rows=933 width=236) (actual time=34,309.101..34,309.101 rows=0 loops=1)

  • Join Filter: ((trn.parent_id)::text = (otop.ad_org_id)::text)
5. 0.000 34,309.099 ↓ 0.0 0 1

Nested Loop Left Join (cost=1.96..1,959,957.49 rows=933 width=202) (actual time=34,309.099..34,309.099 rows=0 loops=1)

  • Join Filter: ((trn.node_id)::text = (o.ad_org_id)::text)
6. 0.002 34,309.099 ↓ 0.0 0 1

Nested Loop (cost=1.96..1,950,645.33 rows=904 width=189) (actual time=34,309.099..34,309.099 rows=0 loops=1)

  • Join Filter: ((so.c_currency_id)::text = (soc.c_currency_id)::text)
7. 0.001 34,309.097 ↓ 0.0 0 1

Nested Loop (cost=1.96..1,948,267.14 rows=904 width=184) (actual time=34,309.097..34,309.097 rows=0 loops=1)

  • Join Filter: ((mo.m_offer_type_id)::text = (mot.m_offer_type_id)::text)
8. 0.001 34,309.096 ↓ 0.0 0 1

Nested Loop (cost=1.96..1,947,994.69 rows=904 width=158) (actual time=34,309.096..34,309.096 rows=0 loops=1)

  • Join Filter: ((solf.m_offer_id)::text = (mo.m_offer_id)::text)
9. 0.001 34,309.095 ↓ 0.0 0 1

Nested Loop (cost=1.96..1,940,549.17 rows=1,471 width=105) (actual time=34,309.095..34,309.095 rows=0 loops=1)

10. 0.002 34,309.094 ↓ 0.0 0 1

Nested Loop (cost=1.41..1,935,636.86 rows=8,292 width=95) (actual time=34,309.094..34,309.094 rows=0 loops=1)

11. 0.137 34,309.092 ↓ 0.0 0 1

Nested Loop (cost=0.85..1,858,081.92 rows=4,335 width=84) (actual time=34,309.092..34,309.092 rows=0 loops=1)

12. 0.541 0.541 ↓ 1.2 21 1

Index Scan using ad_org_key on ad_org o (cost=0.29..30.60 rows=18 width=47) (actual time=0.020..0.541 rows=21 loops=1)

  • Index Cond: ((ad_org_id)::text = ANY ('{7B14F7FDF88041C79CFFC7B6C97EC98C,2A7F189D2B1744CAB44D9913782F9FE1,6BCC1141B95C4DE189C4D893FA83C499,18B7764347B54926A14363940A055000,B1E1E8F83F8A4AEF937A99904C87538E,2809743F5D544C00979F0E6E8B946917,DE31AA7923704DEEADC8753CAE26B305,15CE0C688FAC4030820AF3F168D8A71D,6446C23618E84B98BA55FB403530D53B,4F51CDBD07C541469462973979987E7B,2447906C5302433C9326F011029F016E,B12346108D6345A39C8CD0358E5C5F9F,2E1E62F6F5CF4C9889C7787BFEB825B3,E6DD6BBCE9CD4F7AB41305353DD449A1,E17DA950EBE94847A7D3C6AE6F714869,28F3639BF0CA4F409EA2263F9C7A0BA0,CFFDE27364084FE3A0D74798C4B69910,484B2B49CF46462BA87F78190C462E1E,3176605DD7844DB48AB99D1003A56ECA,4FECC7CB14B44037AC1988883C626168,EDB436D38F394D488F57FB701E86E4F8,47CFAFD4E73F42388790CE579AE05D2F}'::text[]))
  • Filter: (((ad_client_id)::text = '3AFE04DCE6EE4C5A9912EDFF5517C3A7'::text) AND ((em_obretco_retailorgtype)::text = 'S'::text))
  • Rows Removed by Filter: 1
13. 34,308.414 34,308.414 ↓ 0.0 0 21

Index Scan using c_order_client_org_date_docno on c_order so (cost=0.56..103,221.89 rows=318 width=70) (actual time=1,633.734..1,633.734 rows=0 loops=21)

  • Index Cond: ((ad_org_id)::text = (o.ad_org_id)::text)
  • Filter: ((isactive = 'Y'::bpchar) AND (issotrx = 'Y'::bpchar) AND (processed = 'Y'::bpchar) AND (trunc(em_poss_businessdate) >= '2018-09-01'::date) AND (trunc(em_poss_businessdate) <= '2018-10-01'::date))
  • Rows Removed by Filter: 65596
14. 0.000 0.000 ↓ 0.0 0

Index Scan using c_orderline_order2 on c_orderline sol (cost=0.56..17.69 rows=20 width=77) (never executed)

  • Index Cond: ((c_order_id)::text = (so.c_order_id)::text)
15. 0.000 0.000 ↓ 0.0 0

Index Scan using c_orderlineoffer_line_idx on c_orderline_offer solf (cost=0.55..0.58 rows=1 width=76) (never executed)

  • Index Cond: ((c_orderline_id)::text = (sol.c_orderline_id)::text)
16. 0.000 0.000 ↓ 0.0 0

Materialize (cost=0.00..32.52 rows=336 width=86) (never executed)

17. 0.000 0.000 ↓ 0.0 0

Seq Scan on m_offer mo (cost=0.00..30.84 rows=336 width=86) (never executed)

  • Filter: (isactive = 'Y'::bpchar)
18. 0.000 0.000 ↓ 0.0 0

Materialize (cost=0.00..1.30 rows=20 width=59) (never executed)

19. 0.000 0.000 ↓ 0.0 0

Seq Scan on m_offer_type mot (cost=0.00..1.20 rows=20 width=59) (never executed)

20. 0.000 0.000 ↓ 0.0 0

Materialize (cost=0.00..5.62 rows=175 width=9) (never executed)

21. 0.000 0.000 ↓ 0.0 0

Seq Scan on c_currency soc (cost=0.00..4.75 rows=175 width=9) (never executed)

22. 0.000 0.000 ↓ 0.0 0

Materialize (cost=0.00..25.28 rows=685 width=30) (never executed)

23. 0.000 0.000 ↓ 0.0 0

Seq Scan on ad_treenode trn (cost=0.00..21.85 rows=685 width=30) (never executed)

24. 0.000 0.000 ↓ 0.0 0

Materialize (cost=0.00..32.86 rows=124 width=47) (never executed)

25. 0.000 0.000 ↓ 0.0 0

Seq Scan on ad_org otop (cost=0.00..32.24 rows=124 width=47) (never executed)

26. 0.000 0.000 ↓ 0.0 0

Aggregate (cost=4.65..4.66 rows=1 width=5) (never executed)

27. 0.000 0.000 ↓ 0.0 0

Bitmap Heap Scan on obcombo_family mof (cost=1.40..4.64 rows=3 width=5) (never executed)

  • Recheck Cond: ((m_offer_id)::text = (mo.m_offer_id)::text)
28. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on obcombo_fam_offer_idx (cost=0.00..1.40 rows=3 width=0) (never executed)

  • Index Cond: ((m_offer_id)::text = (mo.m_offer_id)::text)