explain.depesz.com

PostgreSQL's explain analyze made readable

Result: WpmJ

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

WindowAgg (cost=100,884.53..491,588.26 rows=887,429 width=1,069) (actual time=1,125.771..5,600.113 rows=1,363,204 loops=1)

2. 485.403 4,624.483 ↓ 1.5 1,363,204 1

Gather (cost=100,884.53..480,495.39 rows=887,429 width=1,021) (actual time=1,125.765..4,624.483 rows=1,363,204 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
3. 140.466 4,139.080 ↓ 1.2 454,401 3 / 3

Hash Left Join (cost=99,884.53..390,752.49 rows=369,762 width=1,021) (actual time=1,123.375..4,139.080 rows=454,401 loops=3)

  • Hash Cond: (x4.party_id = x14.party_id)
4. 128.733 3,994.101 ↓ 1.2 454,401 3 / 3

Hash Left Join (cost=99,366.59..388,693.10 rows=369,762 width=1,021) (actual time=1,118.803..3,994.101 rows=454,401 loops=3)

  • Hash Cond: (((x8.lang)::text = (x12.lang)::text) AND (x1.cuser = x10.user_id))
5. 207.722 3,865.183 ↓ 1.2 454,401 3 / 3

Hash Join (cost=99,304.81..385,857.79 rows=369,762 width=999) (actual time=1,118.602..3,865.183 rows=454,401 loops=3)

  • Hash Cond: ((x7.sale_cnl_id = x8.sale_cnl_id) AND ((x9.lang)::text = (x8.lang)::text))
6. 373.722 3,657.440 ↓ 1.2 454,401 3 / 3

Hash Left Join (cost=99,303.46..378,461.20 rows=369,762 width=995) (actual time=1,118.521..3,657.440 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
7. 148.013 3,258.300 ↓ 1.3 467,323 3 / 3

Hash Left Join (cost=97,028.75..282,905.37 rows=371,655 width=971) (actual time=1,092.903..3,258.300 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
8. 717.430 3,110.265 ↓ 1.2 469,653 3 / 3

Hash Left Join (cost=97,027.19..281,623.22 rows=403,973 width=976) (actual time=1,092.850..3,110.265 rows=469,653 loops=3)

  • Hash Cond: (x1.bsn_inter_id = co.bsn_inter_id)
9. 179.728 1,706.779 ↓ 1.2 469,653 3 / 3

Hash Join (cost=34,460.20..110,644.87 rows=403,973 width=952) (actual time=406.156..1,706.779 rows=469,653 loops=3)

  • Hash Cond: (x5.sale_cnl_id = x7.sale_cnl_id)
10. 222.748 1,527.042 ↓ 1.2 469,653 3 / 3

Hash Join (cost=34,459.04..108,941.26 rows=403,973 width=947) (actual time=406.136..1,527.042 rows=469,653 loops=3)

  • Hash Cond: (x1.bsn_inter_spec_id = x2.bsn_inter_spec_id)
11. 388.330 1,304.032 ↑ 1.0 418,439 3 / 3

Hash Join (cost=34,438.27..102,701.45 rows=435,865 width=107) (actual time=405.862..1,304.032 rows=418,439 loops=3)

  • Hash Cond: (x1.cuser = x5.user_id)
12. 393.494 818.322 ↑ 1.2 424,123 3 / 3

Hash Join (cost=23,738.00..75,791.66 rows=527,427 width=73) (actual time=308.233..818.322 rows=424,123 loops=3)

  • Hash Cond: (x1.cust_id = x3.cust_id)
13. 116.860 116.860 ↑ 1.2 601,956 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.860 rows=601,956 loops=3)

14. 52.130 307.968 ↓ 1.0 171,601 3 / 3

Hash (cost=20,419.02..20,419.02 rows=171,598 width=27) (actual time=307.967..307.968 rows=171,601 loops=3)

  • Buckets: 65536 Batches: 4 Memory Usage: 3120kB
15. 112.488 255.838 ↓ 1.0 171,601 3 / 3

Hash Join (cost=12,600.59..20,419.02 rows=171,598 width=27) (actual time=122.351..255.838 rows=171,601 loops=3)

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

Seq Scan on cust x3 (cost=0.00..4,040.98 rows=171,598 width=12) (actual time=0.015..21.400 rows=171,601 loops=3)

17. 76.290 121.950 ↓ 1.0 281,629 3 / 3

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

  • Buckets: 65536 Batches: 8 Memory Usage: 2416kB
18. 45.660 45.660 ↓ 1.0 281,629 3 / 3

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

19. 55.487 97.380 ↓ 1.0 183,393 3 / 3

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

  • Buckets: 65536 Batches: 4 Memory Usage: 3538kB
20. 41.893 41.893 ↓ 1.0 183,393 3 / 3

Seq Scan on apl_user x5 (cost=0.00..6,974.90 rows=183,390 width=40) (actual time=0.005..41.893 rows=183,393 loops=3)

21. 0.023 0.262 ↑ 1.0 38 3 / 3

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

  • Buckets: 1024 Batches: 1 Memory Usage: 15kB
22. 0.024 0.239 ↑ 1.0 38 3 / 3

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

  • Hash Cond: (x2.bsn_inter_feed_config_id = x9.bsn_inter_feed_config_id)
23. 0.081 0.187 ↑ 1.0 19 3 / 3

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

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

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

25. 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
26. 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.005..0.012 rows=19 loops=3)

  • Filter: (is_actv = '1'::numeric)
27. 0.017 0.028 ↑ 1.0 38 3 / 3

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

  • Buckets: 1024 Batches: 1 Memory Usage: 12kB
28. 0.011 0.011 ↑ 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.004..0.011 rows=38 loops=3)

29. 0.004 0.009 ↑ 1.0 7 3 / 3

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

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
30. 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)

31. 332.920 686.056 ↓ 1.0 1,172,302 3 / 3

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

  • Buckets: 65536 Batches: 32 Memory Usage: 2681kB
32. 353.136 353.136 ↓ 1.0 1,172,302 3 / 3

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

33. 0.011 0.022 ↑ 1.0 25 3 / 3

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

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

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

35. 8.041 25.418 ↑ 1.9 31,068 3 / 3

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

  • Buckets: 65536 Batches: 2 Memory Usage: 1438kB
36. 5.718 17.377 ↑ 1.9 31,068 3 / 3

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

  • Hash Cond: (actv_log.rsn_tp_id = rsn_tp.gnl_tp_id)
37. 8.458 10.396 ↓ 1.0 25,225 3 / 3

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

  • Hash Cond: (actv_log.actn_tp_id = actn_tp.gnl_tp_id)
38. 1.669 1.669 ↓ 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.669 rows=25,225 loops=3)

39. 0.128 0.269 ↑ 1.0 584 3 / 3

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

  • Buckets: 1024 Batches: 1 Memory Usage: 36kB
40. 0.141 0.141 ↑ 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.141 rows=584 loops=3)

  • Filter: (is_actv = '1'::numeric)
  • Rows Removed by Filter: 5
41. 0.352 1.263 ↓ 1.1 1,434 3 / 3

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

  • Buckets: 2048 Batches: 1 Memory Usage: 105kB
42. 0.422 0.911 ↓ 1.1 1,434 3 / 3

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

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

  • Filter: (is_actv = '1'::numeric)
  • Rows Removed by Filter: 4
44. 0.128 0.247 ↑ 1.0 584 3 / 3

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

  • Buckets: 1024 Batches: 1 Memory Usage: 36kB
45. 0.119 0.119 ↑ 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.119 rows=584 loops=3)

  • Filter: (is_actv = '1'::numeric)
  • Rows Removed by Filter: 5
46. 0.011 0.021 ↑ 1.0 14 3 / 3

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

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
47. 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)

48. 0.001 0.185 ↓ 0.0 0 3 / 3

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

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

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

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

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

51. 0.183 0.183 ↓ 0.0 0 3 / 3

Seq Scan on site_user x10 (cost=0.00..57.12 rows=1 width=11) (actual time=0.183..0.183 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.354 4.513 ↑ 1.3 11,793 3 / 3

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

  • Buckets: 16384 Batches: 1 Memory Usage: 654kB
55. 2.159 2.159 ↑ 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.159 rows=15,331 loops=3)

Planning time : 10.897 ms
Execution time : 5,667.264 ms