explain.depesz.com

PostgreSQL's explain analyze made readable

Result: jVxQ

Settings
# exclusive inclusive rows x rows loops node
1. 1,001.282 5,443.510 ↓ 1.4 1,359,598 1

WindowAgg (cost=100,727.93..429,685.49 rows=992,642 width=1,069) (actual time=1,119.990..5,443.510 rows=1,359,598 loops=1)

2. 580.895 4,442.228 ↓ 1.4 1,359,598 1

Gather (cost=100,727.93..417,277.47 rows=992,642 width=1,021) (actual time=1,119.977..4,442.228 rows=1,359,598 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
3. 147.118 3,861.333 ↓ 1.1 453,199 3 / 3

Hash Left Join (cost=99,727.93..317,013.27 rows=413,601 width=1,021) (actual time=1,115.671..3,861.333 rows=453,199 loops=3)

  • Hash Cond: (x4.party_id = x14.party_id)
4. 132.317 3,709.574 ↓ 1.1 453,199 3 / 3

Hash Left Join (cost=99,209.98..314,770.83 rows=413,601 width=1,021) (actual time=1,110.954..3,709.574 rows=453,199 loops=3)

  • Hash Cond: (((x8.lang)::text = (x12.lang)::text) AND (x1.cuser = x10.user_id))
5. 180.070 3,576.784 ↓ 1.1 453,199 3 / 3

Hash Join (cost=99,148.20..311,606.70 rows=413,601 width=999) (actual time=1,110.460..3,576.784 rows=453,199 loops=3)

  • Hash Cond: (x1.bsn_inter_spec_id = x6.bsn_inter_spec_id)
6. 213.580 3,396.466 ↓ 1.1 453,199 3 / 3

Hash Join (cost=99,127.90..310,490.64 rows=413,601 width=967) (actual time=1,110.152..3,396.466 rows=453,199 loops=3)

  • Hash Cond: ((x5.sale_cnl_id = x7.sale_cnl_id) AND ((x9.lang)::text = (x8.lang)::text))
7. 358.870 3,182.833 ↓ 1.1 453,199 3 / 3

Hash Left Join (cost=99,125.33..302,216.06 rows=413,601 width=958) (actual time=1,110.064..3,182.833 rows=453,199 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: 3771
  • Filter: (((actn_tp.shrt_code)::text IS NULL) OR ((actn_tp.shrt_code)::text <> 'CONTINUE'::text))
  • Rows Removed by Filter: 12597
8. 205.710 2,797.212 ↓ 1.1 465,796 3 / 3

Hash Join (cost=96,899.37..199,790.30 rows=415,718 width=934) (actual time=1,083.043..2,797.212 rows=465,796 loops=3)

  • Hash Cond: (x1.bsn_inter_spec_id = x2.bsn_inter_spec_id)
9. 134.368 2,591.415 ↓ 1.0 412,731 3 / 3

Hash Left Join (cost=96,895.92..193,605.76 rows=404,779 width=126) (actual time=1,082.943..2,591.415 rows=412,731 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: 4333
10. 628.938 2,457.023 ↑ 1.1 417,064 3 / 3

Hash Left Join (cost=96,894.36..192,209.48 rows=439,977 width=131) (actual time=1,082.879..2,457.023 rows=417,064 loops=3)

  • Hash Cond: (x1.bsn_inter_id = co.bsn_inter_id)
11. 315.097 1,145.665 ↑ 1.1 417,064 3 / 3

Hash Join (cost=34,395.27..102,593.97 rows=439,977 width=107) (actual time=399.743..1,145.665 rows=417,064 loops=3)

  • Hash Cond: (x1.cuser = x5.user_id)
12. 310.959 734.088 ↑ 1.3 422,688 3 / 3

Hash Join (cost=23,706.66..75,626.13 rows=529,986 width=73) (actual time=302.885..734.088 rows=422,688 loops=3)

  • Hash Cond: (x1.cust_id = x3.cust_id)
13. 120.592 120.592 ↑ 1.2 600,255 3 / 3

Parallel Seq Scan on bsn_inter x1 (cost=0.00..27,978.99 rows=750,299 width=52) (actual time=0.004..120.592 rows=600,255 loops=3)

14. 50.931 302.537 ↓ 1.0 171,217 3 / 3

Hash (cost=20,395.50..20,395.50 rows=171,213 width=27) (actual time=302.537..302.537 rows=171,217 loops=3)

  • Buckets: 65536 Batches: 4 Memory Usage: 3114kB
15. 108.458 251.606 ↓ 1.0 171,217 3 / 3

Hash Join (cost=12,586.92..20,395.50 rows=171,213 width=27) (actual time=121.933..251.606 rows=171,217 loops=3)

  • Hash Cond: (x3.party_id = x4.party_id)
16. 21.600 21.600 ↓ 1.0 171,217 3 / 3

Seq Scan on cust x3 (cost=0.00..4,037.13 rows=171,213 width=12) (actual time=0.011..21.600 rows=171,217 loops=3)

17. 75.450 121.548 ↓ 1.0 281,157 3 / 3

Hash (cost=7,424.52..7,424.52 rows=281,152 width=21) (actual time=121.548..121.548 rows=281,157 loops=3)

  • Buckets: 65536 Batches: 8 Memory Usage: 2413kB
18. 46.098 46.098 ↓ 1.0 281,157 3 / 3

Seq Scan on party x4 (cost=0.00..7,424.52 rows=281,152 width=21) (actual time=0.005..46.098 rows=281,157 loops=3)

19. 52.821 96.480 ↓ 1.0 183,009 3 / 3

Hash (cost=6,971.05..6,971.05 rows=183,005 width=40) (actual time=96.480..96.480 rows=183,009 loops=3)

  • Buckets: 65536 Batches: 4 Memory Usage: 3531kB
20. 43.659 43.659 ↓ 1.0 183,009 3 / 3

Seq Scan on apl_user x5 (cost=0.00..6,971.05 rows=183,005 width=40) (actual time=0.008..43.659 rows=183,009 loops=3)

21. 329.174 682.420 ↓ 1.0 1,169,943 3 / 3

Hash (cost=39,877.15..39,877.15 rows=1,169,915 width=30) (actual time=682.420..682.420 rows=1,169,943 loops=3)

  • Buckets: 65536 Batches: 32 Memory Usage: 2675kB
22. 353.246 353.246 ↓ 1.0 1,169,943 3 / 3

Seq Scan on cust_ord co (cost=0.00..39,877.15 rows=1,169,915 width=30) (actual time=0.009..353.246 rows=1,169,943 loops=3)

23. 0.010 0.024 ↑ 1.0 25 3 / 3

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

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

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

25. 0.022 0.087 ↑ 1.0 38 3 / 3

Hash (cost=2.98..2.98 rows=38 width=808) (actual time=0.087..0.087 rows=38 loops=3)

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

Hash Join (cost=1.48..2.98 rows=38 width=808) (actual time=0.045..0.065 rows=38 loops=3)

  • Hash Cond: (x9.bsn_inter_feed_config_id = x2.bsn_inter_feed_config_id)
27. 0.010 0.010 ↑ 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.008..0.010 rows=38 loops=3)

28. 0.010 0.022 ↑ 1.0 19 3 / 3

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

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
29. 0.012 0.012 ↑ 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.006..0.012 rows=19 loops=3)

  • Filter: (is_actv = '1'::numeric)
30. 8.276 26.751 ↑ 1.9 30,209 3 / 3

Hash (cost=1,031.94..1,031.94 rows=56,082 width=44) (actual time=26.751..26.751 rows=30,209 loops=3)

  • Buckets: 65536 Batches: 2 Memory Usage: 1411kB
31. 5.988 18.475 ↑ 1.9 30,209 3 / 3

Hash Left Join (cost=106.73..1,031.94 rows=56,082 width=44) (actual time=1.869..18.475 rows=30,209 loops=3)

  • Hash Cond: (actv_log.rsn_tp_id = rsn_tp.gnl_tp_id)
32. 8.931 10.958 ↓ 1.0 24,552 3 / 3

Hash Join (cost=26.66..702.07 rows=24,342 width=26) (actual time=0.324..10.958 rows=24,552 loops=3)

  • Hash Cond: (actv_log.actn_tp_id = actn_tp.gnl_tp_id)
33. 1.722 1.722 ↓ 1.0 24,552 3 / 3

Seq Scan on bsn_inter_actv_log actv_log (cost=0.00..610.50 rows=24,550 width=25) (actual time=0.006..1.722 rows=24,552 loops=3)

34. 0.149 0.305 ↑ 1.0 584 3 / 3

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

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

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

  • Filter: (is_actv = '1'::numeric)
  • Rows Removed by Filter: 5
36. 0.427 1.529 ↓ 1.1 1,434 3 / 3

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

  • Buckets: 2048 Batches: 1 Memory Usage: 105kB
37. 0.505 1.102 ↓ 1.1 1,434 3 / 3

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

  • Hash Cond: (rsn_lang.gnl_tp_id = rsn_tp.gnl_tp_id)
38. 0.298 0.298 ↑ 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.008..0.298 rows=1,357 loops=3)

  • Filter: (is_actv = '1'::numeric)
  • Rows Removed by Filter: 4
39. 0.151 0.299 ↑ 1.0 584 3 / 3

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

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

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

  • Filter: (is_actv = '1'::numeric)
  • Rows Removed by Filter: 5
41. 0.012 0.053 ↑ 1.0 14 3 / 3

Hash (cost=2.36..2.36 rows=14 width=27) (actual time=0.053..0.053 rows=14 loops=3)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
42. 0.023 0.041 ↑ 1.0 14 3 / 3

Hash Join (cost=1.16..2.36 rows=14 width=27) (actual time=0.033..0.041 rows=14 loops=3)

  • Hash Cond: (x8.sale_cnl_id = x7.sale_cnl_id)
43. 0.005 0.005 ↑ 1.0 14 3 / 3

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

44. 0.007 0.013 ↑ 1.0 7 3 / 3

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

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

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

46. 0.148 0.248 ↑ 1.0 458 3 / 3

Hash (cost=14.58..14.58 rows=458 width=42) (actual time=0.248..0.248 rows=458 loops=3)

  • Buckets: 1024 Batches: 1 Memory Usage: 42kB
47. 0.100 0.100 ↑ 1.0 458 3 / 3

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

48. 0.000 0.473 ↓ 0.0 0 3 / 3

Hash (cost=61.74..61.74 rows=2 width=31) (actual time=0.473..0.473 rows=0 loops=3)

  • Buckets: 1024 Batches: 1 Memory Usage: 8kB
49. 0.001 0.473 ↓ 0.0 0 3 / 3

Nested Loop (cost=0.29..61.74 rows=2 width=31) (actual time=0.473..0.473 rows=0 loops=3)

  • Join Filter: (x10.site_id = x12.site_id)
50. 0.000 0.472 ↓ 0.0 0 3 / 3

Nested Loop (cost=0.14..61.33 rows=1 width=16) (actual time=0.472..0.472 rows=0 loops=3)

51. 0.472 0.472 ↓ 0.0 0 3 / 3

Seq Scan on site_user x10 (cost=0.00..57.12 rows=1 width=11) (actual time=0.472..0.472 rows=0 loops=3)

  • Filter: ((is_dflt = '1'::numeric) AND (is_actv = '1'::numeric))
  • Rows Removed by Filter: 2541
52. 0.000 0.000 ↓ 0.0 0 / 3

Index Only Scan using pk_site on site x11 (cost=0.14..4.16 rows=1 width=5) (never executed)

  • Index Cond: (site_id = x10.site_id)
  • Heap Fetches: 0
53. 0.000 0.000 ↓ 0.0 0 / 3

Index Scan using idx_site_id on site_lang x12 (cost=0.15..0.38 rows=2 width=30) (never executed)

  • Index Cond: (site_id = x11.site_id)
54. 2.477 4.641 ↑ 1.3 11,793 3 / 3

Hash (cost=326.31..326.31 rows=15,331 width=12) (actual time=4.641..4.641 rows=11,793 loops=3)

  • Buckets: 16384 Batches: 1 Memory Usage: 654kB
55. 2.164 2.164 ↑ 1.0 15,331 3 / 3

Seq Scan on emp x14 (cost=0.00..326.31 rows=15,331 width=12) (actual time=0.005..2.164 rows=15,331 loops=3)

Planning time : 15.591 ms
Execution time : 5,513.298 ms