explain.depesz.com

PostgreSQL's explain analyze made readable

Result: dXwR

Settings
# exclusive inclusive rows x rows loops node
1. 30,199.146 462,002.577 ↑ 5.1 8,448,728 1

Hash Left Join (cost=57,406,126.02..74,363,070.78 rows=43,386,216 width=634) (actual time=397,393.618..462,002.577 rows=8,448,728 loops=1)

  • Hash Cond: (bs.source_spot_id = ssi.admiral_spot_id)
2. 20,326.672 431,781.782 ↑ 5.1 8,448,728 1

Hash Left Join (cost=57,406,056.78..65,848,341.98 rows=43,386,216 width=421) (actual time=397,371.812..431,781.782 rows=8,448,728 loops=1)

  • Hash Cond: (bs.source_spot_id = inv.usn)
3. 10,373.275 406,570.991 ↑ 5.1 8,448,728 1

Hash Right Join (cost=57,022,933.47..59,536,631.50 rows=43,386,216 width=417) (actual time=392,487.138..406,570.991 rows=8,448,728 loops=1)

  • Hash Cond: (asdhh.usn = bs.source_spot_id)
4. 3,800.984 3,800.984 ↓ 19.4 638,424 1

Seq Scan on aired_spot_delivery asdhh (cost=0.00..179,527.04 rows=32,843 width=12) (actual time=5.375..3,800.984 rows=638,424 loops=1)

  • Filter: (upper((demo_cd)::text) = 'HH'::text)
  • Rows Removed by Filter: 5,930,084
5. 9,116.964 392,396.732 ↑ 5.1 8,448,728 1

Hash (cost=54,150,290.77..54,150,290.77 rows=43,386,216 width=409) (actual time=392,396.732..392,396.732 rows=8,448,728 loops=1)

  • Buckets: 16,384 Batches: 8,192 Memory Usage: 521kB
6. 4,140.223 383,279.768 ↑ 5.1 8,448,728 1

Hash Left Join (cost=14,125,888.84..54,150,290.77 rows=43,386,216 width=409) (actual time=141,275.147..383,279.768 rows=8,448,728 loops=1)

  • Hash Cond: ((CASE WHEN ((bs.audience_cd)::text = 'NG'::text) THEN 'No Audience Name'::character varying ELSE bs.audience_cd END)::text = (dmda.audience)::text)
7. 21,596.659 379,139.474 ↑ 5.1 8,448,728 1

Hash Left Join (cost=14,125,882.03..53,499,490.72 rows=43,386,216 width=405) (actual time=141,275.056..379,139.474 rows=8,448,728 loops=1)

  • Hash Cond: (bs.source_spot_id = sta.source_spot_id)
8. 7,517.659 353,703.441 ↑ 5.1 8,448,728 1

Hash Left Join (cost=13,835,731.04..47,782,607.61 rows=43,386,216 width=392) (actual time=137,203.908..353,703.441 rows=8,448,728 loops=1)

  • Hash Cond: (bs.parent_order_id = prnt.order_id)
9. 17,687.872 346,137.060 ↑ 5.1 8,448,728 1

Hash Left Join (cost=13,829,759.50..42,857,653.30 rows=43,386,216 width=384) (actual time=137,154.654..346,137.060 rows=8,448,728 loops=1)

  • Hash Cond: (bs.order_id = ordl.order_id)
10. 7,738.226 328,279.495 ↑ 5.1 8,448,728 1

Nested Loop Left Join (cost=13,823,959.95..37,848,187.28 rows=43,386,216 width=388) (actual time=136,984.272..328,279.495 rows=8,448,728 loops=1)

11. 3,641.857 295,195.085 ↑ 5.1 8,448,728 1

Hash Left Join (cost=13,823,959.53..17,999,669.19 rows=42,855,427 width=394) (actual time=136,984.242..295,195.085 rows=8,448,728 loops=1)

  • Hash Cond: (bs.secondary_product_conflict_id = dmpc.product_conflict_id)
12. 3,678.759 291,548.694 ↑ 5.1 8,448,728 1

Hash Left Join (cost=13,823,945.15..17,886,016.30 rows=42,855,427 width=394) (actual time=136,979.684..291,548.694 rows=8,448,728 loops=1)

  • Hash Cond: (bs.team_id = dmtm.team_id)
13. 3,818.724 287,866.605 ↑ 5.1 8,448,728 1

Hash Left Join (cost=13,823,935.18..17,771,712.20 rows=42,855,427 width=394) (actual time=136,976.338..287,866.605 rows=8,448,728 loops=1)

  • Hash Cond: (bs.asr_user_id = dmasr.user_id)
14. 3,875.363 284,046.122 ↑ 5.1 8,448,728 1

Hash Left Join (cost=13,823,642.91..17,658,854.47 rows=42,855,427 width=394) (actual time=136,974.535..284,046.122 rows=8,448,728 loops=1)

  • Hash Cond: (bs.ae_user_id = dmae.user_id)
15. 3,835.983 280,022.597 ↑ 5.1 8,448,728 1

Hash Left Join (cost=13,823,350.64..17,545,996.74 rows=42,855,427 width=394) (actual time=136,826.331..280,022.597 rows=8,448,728 loops=1)

  • Hash Cond: (bs.order_revenue_type_id = dmrt.revenue_type_id)
16. 3,999.718 276,185.658 ↑ 5.1 8,448,728 1

Hash Left Join (cost=13,823,335.24..17,431,499.85 rows=42,855,427 width=394) (actual time=136,825.358..276,185.658 rows=8,448,728 loops=1)

  • Hash Cond: (bs.spot_revenue_type_id = dmspt.spot_revenue_type_id)
17. 135,274.684 272,185.049 ↑ 5.1 8,448,728 1

Hash Right Join (cost=13,823,319.84..17,317,002.95 rows=42,855,427 width=394) (actual time=136,824.444..272,185.049 rows=8,448,728 loops=1)

  • Hash Cond: (stsp1.selling_title_sk = dmst.selling_title_sk)
  • Join Filter: ((bs.broadcast_week_date >= sp.start_date) AND (bs.broadcast_week_date <= sp.end_date))
  • Rows Removed by Join Filter: 221,038,667
18. 23.410 210.356 ↑ 1.0 80,743 1

Hash Join (cost=5.04..1,704.07 rows=80,743 width=18) (actual time=6.019..210.356 rows=80,743 loops=1)

  • Hash Cond: (stsp1.selling_period_sk = sp.selling_period_sk)
19. 185.821 185.821 ↑ 1.0 80,743 1

Seq Scan on dim_selling_title_selling_period stsp1 (cost=0.00..1,480.43 rows=80,743 width=14) (actual time=4.876..185.821 rows=80,743 loops=1)

20. 0.027 1.125 ↑ 1.0 135 1

Hash (cost=3.35..3.35 rows=135 width=12) (actual time=1.125..1.125 rows=135 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 14kB
21. 1.098 1.098 ↑ 1.0 135 1

Seq Scan on dim_selling_period sp (cost=0.00..3.35 rows=135 width=12) (actual time=1.079..1.098 rows=135 loops=1)

22. 13,757.660 136,700.009 ↑ 5.1 8,448,728 1

Hash (cost=11,111,368.97..11,111,368.97 rows=42,855,427 width=392) (actual time=136,700.009..136,700.009 rows=8,448,728 loops=1)

  • Buckets: 16,384 (originally 16384) Batches: 16,384 (originally 8192) Memory Usage: 127,309kB
23. 4,610.815 122,942.349 ↑ 5.1 8,448,728 1

Hash Left Join (cost=338,040.95..11,111,368.97 rows=42,855,427 width=392) (actual time=3,411.255..122,942.349 rows=8,448,728 loops=1)

  • Hash Cond: (bs.selling_title_id = dmst.selling_title_id)
24. 8,934.604 118,267.004 ↑ 5.1 8,448,728 1

Hash Left Join (cost=336,524.54..10,997,345.91 rows=42,855,427 width=392) (actual time=3,346.471..118,267.004 rows=8,448,728 loops=1)

  • Hash Cond: (lower(btrim(replace((bs.division_cd)::text, ' '::text, ''::text))) = (dmdv.division)::text)
25. 4,379.371 109,332.392 ↑ 2.2 8,448,728 1

Hash Left Join (cost=336,503.96..6,237,637.47 rows=18,236,352 width=392) (actual time=3,346.401..109,332.392 rows=8,448,728 loops=1)

  • Hash Cond: ((bs.spot_status_cd)::text = (dsst.spot_status_cd)::text)
26. 3,701.463 104,953.008 ↑ 2.2 8,448,728 1

Hash Left Join (cost=336,502.65..5,986,934.94 rows=18,236,352 width=388) (actual time=3,346.379..104,953.008 rows=8,448,728 loops=1)

  • Hash Cond: (bs.rate_card_type_id = dmrct.rate_card_type_id)
27. 3,745.159 101,251.535 ↑ 2.2 8,448,728 1

Hash Left Join (cost=336,485.22..5,938,432.30 rows=18,236,352 width=346) (actual time=3,346.357..101,251.535 rows=8,448,728 loops=1)

  • Hash Cond: (bs.property_id = dmdp.property_id)
28. 4,394.442 97,506.355 ↑ 2.2 8,448,728 1

Hash Left Join (cost=336,465.77..5,890,059.51 rows=18,236,352 width=346) (actual time=3,346.321..97,506.355 rows=8,448,728 loops=1)

  • Hash Cond: ((bs.network_cd)::text = (dmdn.network_cd)::text)
29. 10,433.410 93,111.748 ↑ 2.2 8,448,728 1

Hash Left Join (cost=336,453.12..5,639,297.02 rows=18,236,352 width=342) (actual time=3,346.125..93,111.748 rows=8,448,728 loops=1)

  • Hash Cond: (bs.brand_id = dmbd.brand_id)
30. 4,536.327 82,468.936 ↑ 2.2 8,448,728 1

Hash Left Join (cost=332,304.40..3,948,413.07 rows=18,236,352 width=342) (actual time=3,136.176..82,468.936 rows=8,448,728 loops=1)

  • Hash Cond: ((bs.lh_deal_cd)::text = (dmdd.source_deal_id)::text)
31. 4,086.591 77,925.609 ↑ 2.2 8,448,728 1

Hash Left Join (cost=330,757.47..3,898,988.16 rows=18,236,352 width=347) (actual time=3,129.037..77,925.609 rows=8,448,728 loops=1)

  • Hash Cond: (bs.order_type_id = dot.order_type_id)
32. 3,756.466 73,837.959 ↓ 1.2 8,448,728 1

Hash Left Join (cost=330,735.55..3,243,363.60 rows=6,883,478 width=341) (actual time=3,127.967..73,837.959 rows=8,448,728 loops=1)

  • Hash Cond: (bs.agency_id = dmag.agency_id)
33. 4,076.470 70,076.829 ↓ 1.2 8,448,728 1

Hash Left Join (cost=330,137.72..3,224,692.28 rows=6,883,478 width=341) (actual time=3,123.164..70,076.829 rows=8,448,728 loops=1)

  • Hash Cond: (bs.advertiser_id = dmad.advertiser_id)
34. 22,742.007 65,914.823 ↓ 1.2 8,448,728 1

Hash Left Join (cost=329,162.37..3,205,645.14 rows=6,883,478 width=341) (actual time=3,037.487..65,914.823 rows=8,448,728 loops=1)

  • Hash Cond: (bs.source_spot_id = sds.source_spot_id)
35. 3,257.552 40,496.688 ↓ 1.2 8,448,728 1

Hash Left Join (cost=13,683.31..2,090,265.52 rows=6,883,478 width=329) (actual time=360.827..40,496.688 rows=8,448,728 loops=1)

  • Hash Cond: (bs.order_status_id = dos.order_status_id)
36. 14,063.713 37,239.126 ↓ 1.2 8,448,728 1

Hash Left Join (cost=13,647.21..1,995,581.59 rows=6,883,478 width=329) (actual time=360.801..37,239.126 rows=8,448,728 loops=1)

  • Hash Cond: (bs.order_id = ord_st.order_id)
37. 14,073.458 22,869.226 ↓ 1.2 8,448,728 1

Hash Left Join (cost=7,819.62..1,302,879.19 rows=6,883,478 width=325) (actual time=54.084..22,869.226 rows=8,448,728 loops=1)

  • Hash Cond: (bs.order_id = dmo.source_order_id)
38. 8,742.370 8,742.370 ↓ 1.2 8,448,728 1

Seq Scan on blended_spots bs (cost=0.00..621,430.74 rows=6,883,478 width=317) (actual time=0.098..8,742.370 rows=8,448,728 loops=1)

  • Filter: ((source_spot_id_desc = ANY ('{"usn - aired spot","usn - booked spot"}'::text[])) OR (additional_admiral_spot = 1) OR (is_manual_adjustment = 1))
39. 29.665 53.398 ↑ 1.0 179,050 1

Hash (cost=4,706.50..4,706.50 rows=179,050 width=16) (actual time=53.398..53.398 rows=179,050 loops=1)

  • Buckets: 131,072 Batches: 4 Memory Usage: 3,139kB
40. 23.733 23.733 ↑ 1.0 179,050 1

Seq Scan on dim_order dmo (cost=0.00..4,706.50 rows=179,050 width=16) (actual time=0.103..23.733 rows=179,050 loops=1)

41. 28.101 306.187 ↑ 1.0 173,226 1

Hash (cost=2,985.26..2,985.26 rows=173,226 width=8) (actual time=306.186..306.187 rows=173,226 loops=1)

  • Buckets: 131,072 Batches: 4 Memory Usage: 2,728kB
42. 278.086 278.086 ↑ 1.0 173,226 1

Seq Scan on assign_order_status ord_st (cost=0.00..2,985.26 rows=173,226 width=8) (actual time=4.837..278.086 rows=173,226 loops=1)

43. 0.004 0.010 ↑ 165.7 7 1

Hash (cost=21.60..21.60 rows=1,160 width=8) (actual time=0.010..0.010 rows=7 loops=1)

  • Buckets: 2,048 Batches: 1 Memory Usage: 17kB
44. 0.006 0.006 ↑ 165.7 7 1

Seq Scan on dim_order_status dos (cost=0.00..21.60 rows=1,160 width=8) (actual time=0.005..0.006 rows=7 loops=1)

45. 1,490.185 2,676.128 ↑ 1.0 8,354,625 1

Hash (cost=170,251.25..170,251.25 rows=8,354,625 width=16) (actual time=2,676.128..2,676.128 rows=8,354,625 loops=1)

  • Buckets: 131,072 Batches: 256 Memory Usage: 2,674kB
46. 1,185.943 1,185.943 ↑ 1.0 8,354,625 1

Seq Scan on stage_deal_to_spot sds (cost=0.00..170,251.25 rows=8,354,625 width=16) (actual time=0.112..1,185.943 rows=8,354,625 loops=1)

47. 4.634 85.536 ↑ 1.0 28,771 1

Hash (cost=615.71..615.71 rows=28,771 width=8) (actual time=85.536..85.536 rows=28,771 loops=1)

  • Buckets: 32,768 Batches: 1 Memory Usage: 1,380kB
48. 80.902 80.902 ↑ 1.0 28,771 1

Seq Scan on dim_advertiser dmad (cost=0.00..615.71 rows=28,771 width=8) (actual time=0.105..80.902 rows=28,771 loops=1)

49. 2.500 4.664 ↑ 1.0 17,548 1

Hash (cost=378.48..378.48 rows=17,548 width=8) (actual time=4.664..4.664 rows=17,548 loops=1)

  • Buckets: 32,768 Batches: 1 Memory Usage: 942kB
50. 2.164 2.164 ↑ 1.0 17,548 1

Seq Scan on dim_agency dmag (cost=0.00..378.48 rows=17,548 width=8) (actual time=0.005..2.164 rows=17,548 loops=1)

51. 0.005 1.059 ↑ 132.5 4 1

Hash (cost=15.30..15.30 rows=530 width=12) (actual time=1.059..1.059 rows=4 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 9kB
52. 1.054 1.054 ↑ 132.5 4 1

Seq Scan on dim_order_type dot (cost=0.00..15.30 rows=530 width=12) (actual time=1.054..1.054 rows=4 loops=1)

53. 3.504 7.000 ↑ 1.0 20,041 1

Hash (cost=1,296.41..1,296.41 rows=20,041 width=19) (actual time=7.000..7.000 rows=20,041 loops=1)

  • Buckets: 32,768 Batches: 1 Memory Usage: 1,274kB
54. 3.496 3.496 ↑ 1.0 20,041 1

Seq Scan on dim_deal dmdd (cost=0.00..1,296.41 rows=20,041 width=19) (actual time=0.101..3.496 rows=20,041 loops=1)

55. 19.458 209.402 ↑ 1.0 112,299 1

Hash (cost=2,305.99..2,305.99 rows=112,299 width=8) (actual time=209.402..209.402 rows=112,299 loops=1)

  • Buckets: 131,072 Batches: 2 Memory Usage: 3,224kB
56. 189.944 189.944 ↑ 1.0 112,299 1

Seq Scan on dim_brand dmbd (cost=0.00..2,305.99 rows=112,299 width=8) (actual time=0.102..189.944 rows=112,299 loops=1)

57. 0.099 0.165 ↑ 1.0 340 1

Hash (cost=8.40..8.40 rows=340 width=14) (actual time=0.165..0.165 rows=340 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 24kB
58. 0.066 0.066 ↑ 1.0 340 1

Seq Scan on dim_network dmdn (cost=0.00..8.40 rows=340 width=14) (actual time=0.009..0.066 rows=340 loops=1)

59. 0.011 0.021 ↑ 12.0 35 1

Hash (cost=14.20..14.20 rows=420 width=8) (actual time=0.021..0.021 rows=35 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 10kB
60. 0.010 0.010 ↑ 12.0 35 1

Seq Scan on dim_property dmdp (cost=0.00..14.20 rows=420 width=8) (actual time=0.004..0.010 rows=35 loops=1)

61. 0.005 0.010 ↑ 16.5 20 1

Hash (cost=13.30..13.30 rows=330 width=46) (actual time=0.010..0.010 rows=20 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 9kB
62. 0.005 0.005 ↑ 16.5 20 1

Seq Scan on dim_rate_card_type dmrct (cost=0.00..13.30 rows=330 width=46) (actual time=0.003..0.005 rows=20 loops=1)

63. 0.009 0.013 ↑ 1.0 14 1

Hash (cost=1.14..1.14 rows=14 width=36) (actual time=0.013..0.013 rows=14 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 9kB
64. 0.004 0.004 ↑ 1.0 14 1

Seq Scan on dim_spot_status dsst (cost=0.00..1.14 rows=14 width=36) (actual time=0.003..0.004 rows=14 loops=1)

65. 0.004 0.008 ↑ 39.2 12 1

Hash (cost=14.70..14.70 rows=470 width=62) (actual time=0.008..0.008 rows=12 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 9kB
66. 0.004 0.004 ↑ 39.2 12 1

Seq Scan on dim_division dmdv (cost=0.00..14.70 rows=470 width=62) (actual time=0.002..0.004 rows=12 loops=1)

67. 6.536 64.530 ↑ 1.0 42,774 1

Hash (cost=981.74..981.74 rows=42,774 width=8) (actual time=64.530..64.530 rows=42,774 loops=1)

  • Buckets: 65,536 Batches: 1 Memory Usage: 2,183kB
68. 57.994 57.994 ↑ 1.0 42,774 1

Seq Scan on dim_selling_title dmst (cost=0.00..981.74 rows=42,774 width=8) (actual time=4.825..57.994 rows=42,774 loops=1)

69. 0.006 0.891 ↑ 48.0 5 1

Hash (cost=12.40..12.40 rows=240 width=8) (actual time=0.891..0.891 rows=5 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 9kB
70. 0.885 0.885 ↑ 48.0 5 1

Seq Scan on dim_spot_revenue_type dmspt (cost=0.00..12.40 rows=240 width=8) (actual time=0.884..0.885 rows=5 loops=1)

71. 0.007 0.956 ↑ 10.0 24 1

Hash (cost=12.40..12.40 rows=240 width=8) (actual time=0.956..0.956 rows=24 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 9kB
72. 0.949 0.949 ↑ 10.0 24 1

Seq Scan on dim_revenue_type dmrt (cost=0.00..12.40 rows=240 width=8) (actual time=0.947..0.949 rows=24 loops=1)

73. 1.435 148.162 ↑ 1.0 6,812 1

Hash (cost=207.12..207.12 rows=6,812 width=8) (actual time=148.162..148.162 rows=6,812 loops=1)

  • Buckets: 8,192 Batches: 1 Memory Usage: 331kB
74. 146.727 146.727 ↑ 1.0 6,812 1

Seq Scan on dim_user dmae (cost=0.00..207.12 rows=6,812 width=8) (actual time=0.006..146.727 rows=6,812 loops=1)

75. 0.963 1.759 ↑ 1.0 6,812 1

Hash (cost=207.12..207.12 rows=6,812 width=8) (actual time=1.759..1.759 rows=6,812 loops=1)

  • Buckets: 8,192 Batches: 1 Memory Usage: 331kB
76. 0.796 0.796 ↑ 1.0 6,812 1

Seq Scan on dim_user dmasr (cost=0.00..207.12 rows=6,812 width=8) (actual time=0.003..0.796 rows=6,812 loops=1)

77. 0.067 3.330 ↑ 1.0 265 1

Hash (cost=6.65..6.65 rows=265 width=8) (actual time=3.330..3.330 rows=265 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 19kB
78. 3.263 3.263 ↑ 1.0 265 1

Seq Scan on dim_team dmtm (cost=0.00..6.65 rows=265 width=8) (actual time=0.917..3.263 rows=265 loops=1)

79. 0.097 4.534 ↑ 1.0 417 1

Hash (cost=9.17..9.17 rows=417 width=8) (actual time=4.534..4.534 rows=417 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 25kB
80. 4.437 4.437 ↑ 1.0 417 1

Seq Scan on dim_product_conflict dmpc (cost=0.00..9.17 rows=417 width=8) (actual time=0.872..4.437 rows=417 loops=1)

81. 25,346.184 25,346.184 ↑ 1.0 1 8,448,728

Index Scan using idx_blnd_genesis_join on genesis_avails ga (cost=0.42..0.45 rows=1 width=15) (actual time=0.003..0.003 rows=1 loops=8,448,728)

  • Index Cond: ((bs.rate_card_type_id = rate_card_type_id) AND (bs.broadcast_week_date_sk = broadcast_date_sk) AND ((bs.network_cd)::text = (network_cd)::text))
82. 25.568 169.693 ↑ 1.0 176,913 1

Hash (cost=2,896.13..2,896.13 rows=176,913 width=4) (actual time=169.693..169.693 rows=176,913 loops=1)

  • Buckets: 131,072 Batches: 4 Memory Usage: 2,594kB
83. 144.125 144.125 ↑ 1.0 176,913 1

Seq Scan on order_info ordl (cost=0.00..2,896.13 rows=176,913 width=4) (actual time=3.431..144.125 rows=176,913 loops=1)

84. 27.820 48.722 ↑ 1.0 176,913 1

Hash (cost=2,896.13..2,896.13 rows=176,913 width=12) (actual time=48.722..48.722 rows=176,913 loops=1)

  • Buckets: 131,072 Batches: 4 Memory Usage: 2,941kB
85. 20.902 20.902 ↑ 1.0 176,913 1

Seq Scan on order_info prnt (cost=0.00..2,896.13 rows=176,913 width=12) (actual time=0.088..20.902 rows=176,913 loops=1)

86. 1,539.075 3,839.374 ↑ 1.0 8,354,625 1

Hash (cost=136,762.55..136,762.55 rows=8,354,755 width=17) (actual time=3,839.374..3,839.374 rows=8,354,625 loops=1)

  • Buckets: 65,536 Batches: 256 Memory Usage: 2,168kB
87. 2,300.299 2,300.299 ↑ 1.0 8,354,625 1

Seq Scan on spot_tracking_audience sta (cost=0.00..136,762.55 rows=8,354,755 width=17) (actual time=3.504..2,300.299 rows=8,354,625 loops=1)

88. 0.038 0.071 ↑ 1.0 214 1

Hash (cost=4.14..4.14 rows=214 width=10) (actual time=0.071..0.071 rows=214 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 17kB
89. 0.033 0.033 ↑ 1.0 214 1

Seq Scan on dim_audience dmda (cost=0.00..4.14 rows=214 width=10) (actual time=0.006..0.033 rows=214 loops=1)

90. 1,967.968 4,884.119 ↓ 1.0 11,348,823 1

Hash (cost=196,934.36..196,934.36 rows=11,348,636 width=8) (actual time=4,884.119..4,884.119 rows=11,348,823 loops=1)

  • Buckets: 131,072 Batches: 256 Memory Usage: 2,760kB
91. 2,916.151 2,916.151 ↓ 1.0 11,348,823 1

Seq Scan on invoice_data inv (cost=0.00..196,934.36 rows=11,348,636 width=8) (actual time=7.321..2,916.151 rows=11,348,823 loops=1)

92. 0.615 21.649 ↑ 1.0 2,233 1

Hash (cost=41.33..41.33 rows=2,233 width=16) (actual time=21.649..21.649 rows=2,233 loops=1)

  • Buckets: 4,096 Batches: 1 Memory Usage: 128kB
93. 21.034 21.034 ↑ 1.0 2,233 1

Seq Scan on stage_spot_isci ssi (cost=0.00..41.33 rows=2,233 width=16) (actual time=0.772..21.034 rows=2,233 loops=1)

Planning time : 139.699 ms
Execution time : 504,212.273 ms