explain.depesz.com

PostgreSQL's explain analyze made readable

Result: D43A

Settings
# exclusive inclusive rows x rows loops node
1. 978.531 5,045.490 ↓ 1.5 1,363,204 1

WindowAgg (cost=100,136.81..484,601.55 rows=887,429 width=1,041) (actual time=1,108.434..5,045.490 rows=1,363,204 loops=1)

2. 460.516 4,066.959 ↓ 1.5 1,363,204 1

Gather (cost=100,136.81..473,508.69 rows=887,429 width=993) (actual time=1,108.428..4,066.959 rows=1,363,204 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
3. 193.296 3,606.443 ↓ 1.2 454,401 3 / 3

Hash Join (cost=99,136.81..383,765.79 rows=369,762 width=993) (actual time=1,096.287..3,606.443 rows=454,401 loops=3)

  • Hash Cond: ((x7.sale_cnl_id = x8.sale_cnl_id) AND ((x9.lang)::text = (x8.lang)::text))
4. 364.770 3,413.127 ↓ 1.2 454,401 3 / 3

Hash Left Join (cost=99,135.46..376,369.20 rows=369,762 width=989) (actual time=1,096.190..3,413.127 rows=454,401 loops=3)

  • Hash Cond: (x1.bsn_inter_id = actv_log.bsn_inter_id)
  • Join Filter: (COALESCE((rsn_lang.lang)::text, (x9.lang)::text) = (x9.lang)::text)
  • Rows Removed by Join Filter: 3895
  • Filter: (((actn_tp.shrt_code)::text IS NULL) OR ((actn_tp.shrt_code)::text <> 'CONTINUE'::text))
  • Rows Removed by Filter: 12921
5. 145.917 3,022.095 ↓ 1.3 467,323 3 / 3

Hash Left Join (cost=96,860.75..281,539.37 rows=371,655 width=965) (actual time=1,069.732..3,022.095 rows=467,323 loops=3)

  • Hash Cond: (co.ord_st_id = os.ord_st_id)
  • Filter: (((os.shrt_code)::text <> ALL ('{QUOTE,REJECTED}'::text[])) OR (os.ord_st_id IS NULL))
  • Rows Removed by Filter: 2330
6. 679.719 2,876.157 ↓ 1.2 469,653 3 / 3

Hash Left Join (cost=96,859.19..280,257.22 rows=403,973 width=970) (actual time=1,069.677..2,876.157 rows=469,653 loops=3)

  • Hash Cond: (x1.bsn_inter_id = co.bsn_inter_id)
7. 167.696 1,531.979 ↓ 1.2 469,653 3 / 3

Hash Join (cost=34,292.20..109,278.87 rows=403,973 width=946) (actual time=404.653..1,531.979 rows=469,653 loops=3)

  • Hash Cond: (x5.sale_cnl_id = x7.sale_cnl_id)
8. 210.854 1,364.273 ↓ 1.2 469,653 3 / 3

Hash Join (cost=34,291.04..107,575.26 rows=403,973 width=941) (actual time=404.632..1,364.273 rows=469,653 loops=3)

  • Hash Cond: (x1.bsn_inter_spec_id = x2.bsn_inter_spec_id)
9. 323.360 1,153.166 ↑ 1.0 418,440 3 / 3

Hash Join (cost=34,270.27..101,335.45 rows=435,865 width=101) (actual time=404.369..1,153.166 rows=418,440 loops=3)

  • Hash Cond: (x1.cuser = x5.user_id)
10. 309.311 734.345 ↑ 1.2 424,124 3 / 3

Hash Join (cost=23,570.00..75,455.66 rows=527,427 width=67) (actual time=308.662..734.345 rows=424,124 loops=3)

  • Hash Cond: (x1.cust_id = x3.cust_id)
11. 116.634 116.634 ↑ 1.2 601,957 3 / 3

Parallel Seq Scan on bsn_inter x1 (cost=0.00..28,087.92 rows=752,392 width=52) (actual time=0.004..116.634 rows=601,957 loops=3)

12. 50.271 308.400 ↓ 1.0 171,602 3 / 3

Hash (cost=20,419.02..20,419.02 rows=171,598 width=21) (actual time=308.400..308.400 rows=171,602 loops=3)

  • Buckets: 65536 Batches: 4 Memory Usage: 2827kB
13. 114.808 258.129 ↓ 1.0 171,602 3 / 3

Hash Join (cost=12,600.59..20,419.02 rows=171,598 width=21) (actual time=121.166..258.129 rows=171,602 loops=3)

  • Hash Cond: (x3.party_id = x4.party_id)
14. 22.535 22.535 ↓ 1.0 171,602 3 / 3

Seq Scan on cust x3 (cost=0.00..4,040.98 rows=171,598 width=12) (actual time=0.011..22.535 rows=171,602 loops=3)

15. 75.876 120.786 ↓ 1.0 281,630 3 / 3

Hash (cost=7,429.26..7,429.26 rows=281,626 width=21) (actual time=120.786..120.786 rows=281,630 loops=3)

  • Buckets: 65536 Batches: 8 Memory Usage: 2416kB
16. 44.910 44.910 ↓ 1.0 281,630 3 / 3

Seq Scan on party x4 (cost=0.00..7,429.26 rows=281,626 width=21) (actual time=0.005..44.910 rows=281,630 loops=3)

17. 52.811 95.461 ↓ 1.0 183,394 3 / 3

Hash (cost=6,974.90..6,974.90 rows=183,390 width=40) (actual time=95.461..95.461 rows=183,394 loops=3)

  • Buckets: 65536 Batches: 4 Memory Usage: 3538kB
18. 42.650 42.650 ↓ 1.0 183,394 3 / 3

Seq Scan on apl_user x5 (cost=0.00..6,974.90 rows=183,390 width=40) (actual time=0.006..42.650 rows=183,394 loops=3)

19. 0.022 0.253 ↑ 1.0 38 3 / 3

Hash (cost=20.29..20.29 rows=38 width=850) (actual time=0.253..0.253 rows=38 loops=3)

  • Buckets: 1024 Batches: 1 Memory Usage: 15kB
20. 0.022 0.231 ↑ 1.0 38 3 / 3

Hash Join (cost=3.33..20.29 rows=38 width=850) (actual time=0.189..0.231 rows=38 loops=3)

  • Hash Cond: (x2.bsn_inter_feed_config_id = x9.bsn_inter_feed_config_id)
21. 0.076 0.180 ↑ 1.0 19 3 / 3

Hash Join (cost=1.48..17.96 rows=19 width=280) (actual time=0.152..0.180 rows=19 loops=3)

  • Hash Cond: (x6.bsn_inter_spec_id = x2.bsn_inter_spec_id)
22. 0.085 0.085 ↑ 1.0 458 3 / 3

Seq Scan on bsn_inter_spec x6 (cost=0.00..14.58 rows=458 width=42) (actual time=0.003..0.085 rows=458 loops=3)

23. 0.008 0.019 ↑ 1.0 19 3 / 3

Hash (cost=1.24..1.24 rows=19 width=238) (actual time=0.019..0.019 rows=19 loops=3)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
24. 0.011 0.011 ↑ 1.0 19 3 / 3

Seq Scan on bsn_inter_feed_config x2 (cost=0.00..1.24 rows=19 width=238) (actual time=0.005..0.011 rows=19 loops=3)

  • Filter: (is_actv = '1'::numeric)
25. 0.015 0.029 ↑ 1.0 38 3 / 3

Hash (cost=1.38..1.38 rows=38 width=580) (actual time=0.029..0.029 rows=38 loops=3)

  • Buckets: 1024 Batches: 1 Memory Usage: 12kB
26. 0.014 0.014 ↑ 1.0 38 3 / 3

Seq Scan on bsn_inter_feed_config_lang x9 (cost=0.00..1.38 rows=38 width=580) (actual time=0.005..0.014 rows=38 loops=3)

27. 0.005 0.010 ↑ 1.0 7 3 / 3

Hash (cost=1.07..1.07 rows=7 width=5) (actual time=0.010..0.010 rows=7 loops=3)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
28. 0.005 0.005 ↑ 1.0 7 3 / 3

Seq Scan on sale_cnl x7 (cost=0.00..1.07 rows=7 width=5) (actual time=0.003..0.005 rows=7 loops=3)

29. 311.866 664.459 ↓ 1.0 1,172,303 3 / 3

Hash (cost=39,900.22..39,900.22 rows=1,172,222 width=30) (actual time=664.459..664.459 rows=1,172,303 loops=3)

  • Buckets: 65536 Batches: 32 Memory Usage: 2681kB
30. 352.593 352.593 ↓ 1.0 1,172,303 3 / 3

Seq Scan on cust_ord co (cost=0.00..39,900.22 rows=1,172,222 width=30) (actual time=0.009..352.593 rows=1,172,303 loops=3)

31. 0.009 0.021 ↑ 1.0 25 3 / 3

Hash (cost=1.25..1.25 rows=25 width=14) (actual time=0.021..0.021 rows=25 loops=3)

  • Buckets: 1024 Batches: 1 Memory Usage: 10kB
32. 0.012 0.012 ↑ 1.0 25 3 / 3

Seq Scan on ord_st os (cost=0.00..1.25 rows=25 width=14) (actual time=0.008..0.012 rows=25 loops=3)

33. 8.183 26.262 ↑ 1.9 31,068 3 / 3

Hash (cost=1,047.68..1,047.68 rows=57,602 width=44) (actual time=26.262..26.262 rows=31,068 loops=3)

  • Buckets: 65536 Batches: 2 Memory Usage: 1438kB
34. 5.849 18.079 ↑ 1.9 31,068 3 / 3

Hash Left Join (cost=106.73..1,047.68 rows=57,602 width=44) (actual time=1.553..18.079 rows=31,068 loops=3)

  • Hash Cond: (actv_log.rsn_tp_id = rsn_tp.gnl_tp_id)
35. 9.021 10.964 ↓ 1.0 25,225 3 / 3

Hash Join (cost=26.66..710.49 rows=25,002 width=26) (actual time=0.277..10.964 rows=25,225 loops=3)

  • Hash Cond: (actv_log.actn_tp_id = actn_tp.gnl_tp_id)
36. 1.681 1.681 ↓ 1.0 25,225 3 / 3

Seq Scan on bsn_inter_actv_log actv_log (cost=0.00..617.16 rows=25,216 width=25) (actual time=0.005..1.681 rows=25,225 loops=3)

37. 0.122 0.262 ↑ 1.0 584 3 / 3

Hash (cost=19.36..19.36 rows=584 width=15) (actual time=0.262..0.262 rows=584 loops=3)

  • Buckets: 1024 Batches: 1 Memory Usage: 36kB
38. 0.140 0.140 ↑ 1.0 584 3 / 3

Seq Scan on gnl_tp actn_tp (cost=0.00..19.36 rows=584 width=15) (actual time=0.006..0.140 rows=584 loops=3)

  • Filter: (is_actv = '1'::numeric)
  • Rows Removed by Filter: 5
39. 0.345 1.266 ↓ 1.1 1,434 3 / 3

Hash (cost=63.26..63.26 rows=1,345 width=32) (actual time=1.266..1.266 rows=1,434 loops=3)

  • Buckets: 2048 Batches: 1 Memory Usage: 105kB
40. 0.430 0.921 ↓ 1.1 1,434 3 / 3

Hash Right Join (cost=26.66..63.26 rows=1,345 width=32) (actual time=0.253..0.921 rows=1,434 loops=3)

  • Hash Cond: (rsn_lang.gnl_tp_id = rsn_tp.gnl_tp_id)
41. 0.255 0.255 ↑ 1.0 1,357 3 / 3

Seq Scan on gnl_tp_lang rsn_lang (cost=0.00..33.01 rows=1,357 width=22) (actual time=0.007..0.255 rows=1,357 loops=3)

  • Filter: (is_actv = '1'::numeric)
  • Rows Removed by Filter: 4
42. 0.120 0.236 ↑ 1.0 584 3 / 3

Hash (cost=19.36..19.36 rows=584 width=15) (actual time=0.236..0.236 rows=584 loops=3)

  • Buckets: 1024 Batches: 1 Memory Usage: 36kB
43. 0.116 0.116 ↑ 1.0 584 3 / 3

Seq Scan on gnl_tp rsn_tp (cost=0.00..19.36 rows=584 width=15) (actual time=0.004..0.116 rows=584 loops=3)

  • Filter: (is_actv = '1'::numeric)
  • Rows Removed by Filter: 5
44. 0.010 0.020 ↑ 1.0 14 3 / 3

Hash (cost=1.14..1.14 rows=14 width=22) (actual time=0.020..0.020 rows=14 loops=3)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
45. 0.010 0.010 ↑ 1.0 14 3 / 3

Seq Scan on sale_cnl_lang x8 (cost=0.00..1.14 rows=14 width=22) (actual time=0.007..0.010 rows=14 loops=3)

Planning time : 4.918 ms
Execution time : 5,109.359 ms