explain.depesz.com

PostgreSQL's explain analyze made readable

Result: VKWR

Settings
# exclusive inclusive rows x rows loops node
1. 1,094.787 5,870.743 ↓ 1.5 1,363,220 1

WindowAgg (cost=100,884.53..491,588.26 rows=887,429 width=1,069) (actual time=1,104.042..5,870.743 rows=1,363,220 loops=1)

2. 776.949 4,775.956 ↓ 1.5 1,363,220 1

Gather (cost=100,884.53..480,495.39 rows=887,429 width=1,021) (actual time=1,104.036..4,775.956 rows=1,363,220 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
3. 144.128 3,999.007 ↓ 1.2 454,407 3 / 3

Hash Left Join (cost=99,884.53..390,752.49 rows=369,762 width=1,021) (actual time=1,113.716..3,999.007 rows=454,407 loops=3)

  • Hash Cond: (x4.party_id = x14.party_id)
4. 130.678 3,850.162 ↓ 1.2 454,407 3 / 3

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

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

Hash Join (cost=99,304.81..385,857.79 rows=369,762 width=999) (actual time=1,108.728..3,719.284 rows=454,407 loops=3)

  • Hash Cond: ((x7.sale_cnl_id = x8.sale_cnl_id) AND ((x9.lang)::text = (x8.lang)::text))
6. 380.481 3,506.900 ↓ 1.2 454,407 3 / 3

Hash Left Join (cost=99,303.46..378,461.20 rows=369,762 width=995) (actual time=1,108.651..3,506.900 rows=454,407 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: 3897
  • Filter: (((actn_tp.shrt_code)::text IS NULL) OR ((actn_tp.shrt_code)::text <> 'CONTINUE'::text))
  • Rows Removed by Filter: 12921
7. 149.046 3,100.517 ↓ 1.3 467,328 3 / 3

Hash Left Join (cost=97,028.75..282,905.37 rows=371,655 width=971) (actual time=1,082.552..3,100.517 rows=467,328 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: 2329
8. 698.308 2,951.448 ↓ 1.2 469,657 3 / 3

Hash Left Join (cost=97,027.19..281,623.22 rows=403,973 width=976) (actual time=1,082.500..2,951.448 rows=469,657 loops=3)

  • Hash Cond: (x1.bsn_inter_id = co.bsn_inter_id)
9. 171.963 1,579.206 ↓ 1.2 469,657 3 / 3

Hash Join (cost=34,460.20..110,644.87 rows=403,973 width=952) (actual time=407.974..1,579.206 rows=469,657 loops=3)

  • Hash Cond: (x5.sale_cnl_id = x7.sale_cnl_id)
10. 215.229 1,407.235 ↓ 1.2 469,657 3 / 3

Hash Join (cost=34,459.04..108,941.26 rows=403,973 width=947) (actual time=407.956..1,407.235 rows=469,657 loops=3)

  • Hash Cond: (x1.bsn_inter_spec_id = x2.bsn_inter_spec_id)
11. 335.140 1,191.786 ↑ 1.0 418,456 3 / 3

Hash Join (cost=34,438.27..102,701.45 rows=435,865 width=107) (actual time=407.725..1,191.786 rows=418,456 loops=3)

  • Hash Cond: (x1.cuser = x5.user_id)
12. 327.858 761.910 ↑ 1.2 424,142 3 / 3

Hash Join (cost=23,738.00..75,791.66 rows=527,427 width=73) (actual time=312.745..761.910 rows=424,142 loops=3)

  • Hash Cond: (x1.cust_id = x3.cust_id)
13. 121.579 121.579 ↑ 1.2 601,978 3 / 3

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

14. 52.516 312.473 ↓ 1.0 171,604 3 / 3

Hash (cost=20,419.02..20,419.02 rows=171,598 width=27) (actual time=312.473..312.473 rows=171,604 loops=3)

  • Buckets: 65536 Batches: 4 Memory Usage: 3120kB
15. 111.229 259.957 ↓ 1.0 171,604 3 / 3

Hash Join (cost=12,600.59..20,419.02 rows=171,598 width=27) (actual time=126.385..259.957 rows=171,604 loops=3)

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

Seq Scan on cust x3 (cost=0.00..4,040.98 rows=171,598 width=12) (actual time=0.012..22.644 rows=171,604 loops=3)

17. 77.012 126.084 ↓ 1.0 281,633 3 / 3

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

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

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

19. 52.217 94.736 ↓ 1.0 183,396 3 / 3

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

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

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

21. 0.019 0.220 ↑ 1.0 38 3 / 3

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

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

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

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

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

  • Hash Cond: (x6.bsn_inter_spec_id = x2.bsn_inter_spec_id)
24. 0.070 0.070 ↑ 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.070 rows=458 loops=3)

25. 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
26. 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)
27. 0.014 0.024 ↑ 1.0 38 3 / 3

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

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

29. 0.004 0.008 ↑ 1.0 7 3 / 3

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

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
30. 0.004 0.004 ↑ 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.004 rows=7 loops=3)

31. 320.267 673.934 ↓ 1.0 1,172,342 3 / 3

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

  • Buckets: 65536 Batches: 32 Memory Usage: 2681kB
32. 353.667 353.667 ↓ 1.0 1,172,342 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.667 rows=1,172,342 loops=3)

33. 0.011 0.023 ↑ 1.0 25 3 / 3

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

  • Buckets: 1024 Batches: 1 Memory Usage: 10kB
34. 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.007..0.012 rows=25 loops=3)

35. 8.134 25.902 ↑ 1.9 31,072 3 / 3

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

  • Buckets: 65536 Batches: 2 Memory Usage: 1438kB
36. 5.845 17.768 ↑ 1.9 31,072 3 / 3

Hash Left Join (cost=106.73..1,047.68 rows=57,602 width=44) (actual time=1.564..17.768 rows=31,072 loops=3)

  • Hash Cond: (actv_log.rsn_tp_id = rsn_tp.gnl_tp_id)
37. 8.670 10.657 ↓ 1.0 25,227 3 / 3

Hash Join (cost=26.66..710.49 rows=25,002 width=26) (actual time=0.287..10.657 rows=25,227 loops=3)

  • Hash Cond: (actv_log.actn_tp_id = actn_tp.gnl_tp_id)
38. 1.716 1.716 ↓ 1.0 25,227 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.716 rows=25,227 loops=3)

39. 0.126 0.271 ↑ 1.0 584 3 / 3

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

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

  • Filter: (is_actv = '1'::numeric)
  • Rows Removed by Filter: 5
41. 0.354 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
42. 0.421 0.912 ↓ 1.1 1,434 3 / 3

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

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

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

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

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

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

Hash (cost=1.14..1.14 rows=14 width=22) (actual time=0.019..0.019 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.000 0.200 ↓ 0.0 0 3 / 3

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

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

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

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

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

51. 0.199 0.199 ↓ 0.0 0 3 / 3

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

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

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

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

Planning time : 6.759 ms
Execution time : 5,945.689 ms