explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 926d

Settings
# exclusive inclusive rows x rows loops node
1. 46,217.777 459,906.444 ↑ 5.1 8,453,415 1

Hash Left Join (cost=52,148,164.95..68,028,078.68 rows=43,011,662 width=634) (actual time=400,931.963..459,906.444 rows=8,453,415 loops=1)

  • Hash Cond: (bs.source_spot_id = inv.usn)
2. 10,538.314 410,473.811 ↑ 5.1 8,453,415 1

Hash Right Join (cost=51,765,041.64..54,216,604.24 rows=43,011,662 width=410) (actual time=397,716.558..410,473.811 rows=8,453,415 loops=1)

  • Hash Cond: (asdhh.usn = bs.source_spot_id)
3. 2,289.272 2,289.272 ↓ 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=0.155..2,289.272 rows=638,424 loops=1)

  • Filter: (upper((demo_cd)::text) = 'HH'::text)
  • Rows Removed by Filter: 5930084
4. 12,950.783 397,646.225 ↑ 5.1 8,453,415 1

Hash (cost=48,959,201.86..48,959,201.86 rows=43,011,662 width=402) (actual time=397,646.225..397,646.225 rows=8,453,415 loops=1)

  • Buckets: 16384 Batches: 8192 Memory Usage: 536kB
5. 3,582.282 384,695.442 ↑ 5.1 8,453,415 1

Hash Left Join (cost=14,231,850.69..48,959,201.86 rows=43,011,662 width=402) (actual time=147,443.783..384,695.442 rows=8,453,415 loops=1)

  • Hash Cond: (bs.source_spot_id = ssi.admiral_spot_id)
6. 3,766.192 381,112.543 ↑ 5.1 8,453,415 1

Hash Left Join (cost=14,231,781.45..48,797,725.20 rows=43,011,662 width=390) (actual time=147,443.141..381,112.543 rows=8,453,415 loops=1)

  • Hash Cond: (bs.secondary_product_conflict_id = dmpc.product_conflict_id)
7. 4,674.388 377,346.242 ↑ 5.1 8,453,415 1

Hash Left Join (cost=14,231,767.07..48,683,658.05 rows=43,011,662 width=390) (actual time=147,443.018..377,346.242 rows=8,453,415 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)
8. 27,179.878 372,671.785 ↑ 5.1 8,453,415 1

Hash Left Join (cost=14,231,760.25..48,038,476.30 rows=43,011,662 width=386) (actual time=147,442.930..372,671.785 rows=8,453,415 loops=1)

  • Hash Cond: (bs.source_spot_id = sta.source_spot_id)
9. 9,679.767 342,852.831 ↑ 5.1 8,453,415 1

Hash Left Join (cost=13,941,609.27..42,536,001.62 rows=43,011,662 width=373) (actual time=144,761.651..342,852.831 rows=8,453,415 loops=1)

  • Hash Cond: (bs.parent_order_id = prnt.order_id)
10. 7,051.512 333,120.878 ↑ 5.1 8,453,415 1

Nested Loop Left Join (cost=13,935,489.72..37,821,384.75 rows=43,011,662 width=365) (actual time=144,708.862..333,120.878 rows=8,453,415 loops=1)

11. 3,773.738 300,709.121 ↑ 5.1 8,453,415 1

Hash Left Join (cost=13,935,489.30..17,928,385.87 rows=43,011,662 width=371) (actual time=144,708.830..300,709.121 rows=8,453,415 loops=1)

  • Hash Cond: (bs.team_id = dmtm.team_id)
12. 3,974.545 296,935.309 ↑ 5.1 8,453,415 1

Hash Left Join (cost=13,935,479.34..17,813,665.16 rows=43,011,662 width=371) (actual time=144,708.744..296,935.309 rows=8,453,415 loops=1)

  • Hash Cond: (bs.asr_user_id = dmasr.user_id)
13. 3,897.846 292,959.059 ↑ 5.1 8,453,415 1

Hash Left Join (cost=13,935,187.07..17,700,397.06 rows=43,011,662 width=371) (actual time=144,706.991..292,959.059 rows=8,453,415 loops=1)

  • Hash Cond: (bs.ae_user_id = dmae.user_id)
14. 3,908.154 289,059.203 ↑ 5.1 8,453,415 1

Hash Left Join (cost=13,934,894.80..17,587,128.96 rows=43,011,662 width=371) (actual time=144,704.939..289,059.203 rows=8,453,415 loops=1)

  • Hash Cond: (bs.order_revenue_type_id = dmrt.revenue_type_id)
15. 3,708.851 285,151.035 ↑ 5.1 8,453,415 1

Hash Left Join (cost=13,934,879.40..17,472,214.78 rows=43,011,662 width=371) (actual time=144,704.913..285,151.035 rows=8,453,415 loops=1)

  • Hash Cond: (bs.spot_revenue_type_id = dmspt.spot_revenue_type_id)
16. 136,825.880 281,442.174 ↑ 5.1 8,453,415 1

Hash Right Join (cost=13,934,864.00..17,357,300.60 rows=43,011,662 width=371) (actual time=144,704.883..281,442.174 rows=8,453,415 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: 221132273
17. 21.083 28.325 ↑ 1.0 80,743 1

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

  • Hash Cond: (stsp1.selling_period_sk = sp.selling_period_sk)
18. 7.191 7.191 ↑ 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=0.129..7.191 rows=80,743 loops=1)

19. 0.019 0.051 ↑ 1.0 135 1

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

  • Buckets: 1024 Batches: 1 Memory Usage: 14kB
20. 0.032 0.032 ↑ 1.0 135 1

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

21. 14,973.464 144,587.969 ↑ 5.1 8,453,415 1

Hash (cost=11,297,034.18..11,297,034.18 rows=43,011,662 width=369) (actual time=144,587.969..144,587.969 rows=8,453,415 loops=1)

  • Buckets: 16384 (originally 16384) Batches: 16384 (originally 8192) Memory Usage: 130463kB
22. 5,128.331 129,614.505 ↑ 5.1 8,453,415 1

Hash Left Join (cost=346,467.91..11,297,034.18 rows=43,011,662 width=369) (actual time=2,968.751..129,614.505 rows=8,453,415 loops=1)

  • Hash Cond: (bs.selling_title_id = dmst.selling_title_id)
23. 9,471.749 124,474.471 ↑ 5.1 8,453,415 1

Hash Left Join (cost=344,951.50..11,182,600.97 rows=43,011,662 width=369) (actual time=2,956.779..124,474.471 rows=8,453,415 loops=1)

  • Hash Cond: (lower(btrim(replace((bs.division_cd)::text, ' '::text, ''::text))) = (dmdv.division)::text)
24. 4,647.440 115,002.713 ↑ 2.2 8,453,415 1

Hash Left Join (cost=344,930.92..6,405,540.47 rows=18,302,835 width=369) (actual time=2,956.749..115,002.713 rows=8,453,415 loops=1)

  • Hash Cond: ((bs.spot_status_cd)::text = (dsst.spot_status_cd)::text)
25. 4,018.686 110,355.264 ↑ 2.2 8,453,415 1

Hash Left Join (cost=344,929.61..6,153,930.08 rows=18,302,835 width=365) (actual time=2,956.727..110,355.264 rows=8,453,415 loops=1)

  • Hash Cond: (bs.rate_card_type_id = dmrct.rate_card_type_id)
26. 4,324.951 106,336.565 ↑ 2.2 8,453,415 1

Hash Left Join (cost=344,928.16..6,095,702.73 rows=18,302,835 width=356) (actual time=2,956.702..106,336.565 rows=8,453,415 loops=1)

  • Hash Cond: (bs.property_id = dmdp.property_id)
27. 4,636.901 102,011.599 ↑ 2.2 8,453,415 1

Hash Left Join (cost=344,908.71..6,047,153.68 rows=18,302,835 width=356) (actual time=2,956.674..102,011.599 rows=8,453,415 loops=1)

  • Hash Cond: ((bs.network_cd)::text = (dmdn.network_cd)::text)
28. 11,219.031 97,374.581 ↑ 2.2 8,453,415 1

Hash Left Join (cost=344,896.06..5,795,477.05 rows=18,302,835 width=352) (actual time=2,956.538..97,374.581 rows=8,453,415 loops=1)

  • Hash Cond: (bs.brand_id = dmbd.brand_id)
29. 4,843.720 86,123.807 ↑ 2.2 8,453,415 1

Hash Left Join (cost=340,747.33..4,062,698.57 rows=18,302,835 width=352) (actual time=2,924.263..86,123.807 rows=8,453,415 loops=1)

  • Hash Cond: ((bs.lh_deal_cd)::text = (dmdd.source_deal_id)::text)
30. 3,845.781 81,272.935 ↑ 2.2 8,453,415 1

Hash Left Join (cost=339,200.41..4,013,099.15 rows=18,302,835 width=357) (actual time=2,916.972..81,272.935 rows=8,453,415 loops=1)

  • Hash Cond: (bs.order_type_id = dot.order_type_id)
31. 18,029.507 77,427.146 ↓ 1.2 8,453,415 1

Hash Left Join (cost=339,178.48..3,355,068.67 rows=6,908,803 width=351) (actual time=2,916.947..77,427.146 rows=8,453,415 loops=1)

  • Hash Cond: (bs.order_id = ord_prp.order_id)
32. 3,551.438 59,342.716 ↓ 1.2 8,448,728 1

Hash Left Join (cost=332,995.96..2,541,300.94 rows=6,870,239 width=337) (actual time=2,861.745..59,342.716 rows=8,448,728 loops=1)

  • Hash Cond: (bs.agency_id = dmag.agency_id)
33. 3,763.796 55,786.506 ↓ 1.2 8,448,728 1

Hash Left Join (cost=332,398.14..2,522,664.38 rows=6,870,239 width=337) (actual time=2,856.829..55,786.506 rows=8,448,728 loops=1)

  • Hash Cond: (bs.advertiser_id = dmad.advertiser_id)
34. 22,543.484 52,014.919 ↓ 1.2 8,448,728 1

Hash Left Join (cost=331,422.79..2,503,651.99 rows=6,870,239 width=337) (actual time=2,848.896..52,014.919 rows=8,448,728 loops=1)

  • Hash Cond: (bs.source_spot_id = sds.source_spot_id)
35. 3,193.340 26,677.076 ↓ 1.2 8,448,728 1

Hash Left Join (cost=7,855.73..1,395,057.43 rows=6,870,239 width=325) (actual time=53.889..26,677.076 rows=8,448,728 loops=1)

  • Hash Cond: (bs.order_status_id = dos.order_status_id)
36. 14,956.608 23,483.728 ↓ 1.2 8,448,728 1

Hash Left Join (cost=7,819.62..1,300,555.55 rows=6,870,239 width=325) (actual time=53.868..23,483.728 rows=8,448,728 loops=1)

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

Seq Scan on blended_spots bs (cost=0.00..620,401.14 rows=6,870,239 width=317) (actual time=0.162..8,473.949 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))
38. 29.165 53.171 ↑ 1.0 179,050 1

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

  • Buckets: 131072 Batches: 4 Memory Usage: 3139kB
39. 24.006 24.006 ↑ 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.108..24.006 rows=179,050 loops=1)

40. 0.004 0.008 ↑ 165.7 7 1

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

  • Buckets: 2048 Batches: 1 Memory Usage: 17kB
41. 0.004 0.004 ↑ 165.7 7 1

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

42. 1,545.537 2,794.359 ↑ 1.0 8,354,625 1

Hash (cost=178,339.25..178,339.25 rows=8,354,625 width=16) (actual time=2,794.359..2,794.359 rows=8,354,625 loops=1)

  • Buckets: 131072 Batches: 256 Memory Usage: 2674kB
43. 1,248.822 1,248.822 ↑ 1.0 8,354,625 1

Seq Scan on stage_deal_to_spot sds (cost=0.00..178,339.25 rows=8,354,625 width=16) (actual time=0.126..1,248.822 rows=8,354,625 loops=1)

44. 4.201 7.791 ↑ 1.0 28,771 1

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

  • Buckets: 32768 Batches: 1 Memory Usage: 1380kB
45. 3.590 3.590 ↑ 1.0 28,771 1

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

46. 2.553 4.772 ↑ 1.0 17,548 1

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

  • Buckets: 32768 Batches: 1 Memory Usage: 942kB
47. 2.219 2.219 ↑ 1.0 17,548 1

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

48. 32.647 54.923 ↑ 1.0 173,712 1

Hash (cost=2,993.12..2,993.12 rows=173,712 width=22) (actual time=54.923..54.923 rows=173,712 loops=1)

  • Buckets: 65536 Batches: 4 Memory Usage: 2843kB
49. 22.276 22.276 ↑ 1.0 173,712 1

Seq Scan on assign_order_properties ord_prp (cost=0.00..2,993.12 rows=173,712 width=22) (actual time=0.124..22.276 rows=173,712 loops=1)

50. 0.005 0.008 ↑ 132.5 4 1

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

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
51. 0.003 0.003 ↑ 132.5 4 1

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

52. 3.553 7.152 ↑ 1.0 20,041 1

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

  • Buckets: 32768 Batches: 1 Memory Usage: 1274kB
53. 3.599 3.599 ↑ 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.107..3.599 rows=20,041 loops=1)

54. 17.755 31.743 ↑ 1.0 112,299 1

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

  • Buckets: 131072 Batches: 2 Memory Usage: 3224kB
55. 13.988 13.988 ↑ 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.123..13.988 rows=112,299 loops=1)

56. 0.067 0.117 ↑ 1.0 340 1

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

  • Buckets: 1024 Batches: 1 Memory Usage: 24kB
57. 0.050 0.050 ↑ 1.0 340 1

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

58. 0.007 0.015 ↑ 12.0 35 1

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

  • Buckets: 1024 Batches: 1 Memory Usage: 10kB
59. 0.008 0.008 ↑ 12.0 35 1

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

60. 0.008 0.013 ↑ 1.0 20 1

Hash (cost=1.20..1.20 rows=20 width=13) (actual time=0.013..0.013 rows=20 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
61. 0.005 0.005 ↑ 1.0 20 1

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

62. 0.005 0.009 ↑ 1.0 14 1

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

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

64. 0.005 0.009 ↑ 39.2 12 1

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

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

66. 6.339 11.703 ↑ 1.0 42,774 1

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

  • Buckets: 65536 Batches: 1 Memory Usage: 2183kB
67. 5.364 5.364 ↑ 1.0 42,774 1

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

68. 0.004 0.010 ↑ 48.0 5 1

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

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
69. 0.006 0.006 ↑ 48.0 5 1

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

70. 0.006 0.014 ↑ 10.0 24 1

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

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
71. 0.008 0.008 ↑ 10.0 24 1

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

72. 0.964 2.010 ↑ 1.0 6,812 1

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

  • Buckets: 8192 Batches: 1 Memory Usage: 331kB
73. 1.046 1.046 ↑ 1.0 6,812 1

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

74. 0.946 1.705 ↑ 1.0 6,812 1

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

  • Buckets: 8192 Batches: 1 Memory Usage: 331kB
75. 0.759 0.759 ↑ 1.0 6,812 1

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

76. 0.037 0.074 ↑ 1.0 265 1

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

  • Buckets: 1024 Batches: 1 Memory Usage: 19kB
77. 0.037 0.037 ↑ 1.0 265 1

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

78. 25,360.245 25,360.245 ↑ 1.0 1 8,453,415

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,453,415)

  • Index Cond: ((bs.rate_card_type_id = lighthouse_rate_card_type_id) AND (bs.broadcast_week_date_sk = broadcast_date_sk) AND ((bs.network_cd)::text = (network_cd)::text))
79. 28.891 52.186 ↑ 1.0 176,913 1

Hash (cost=3,044.13..3,044.13 rows=176,913 width=12) (actual time=52.186..52.186 rows=176,913 loops=1)

  • Buckets: 131072 Batches: 4 Memory Usage: 2941kB
80. 23.295 23.295 ↑ 1.0 176,913 1

Seq Scan on order_info prnt (cost=0.00..3,044.13 rows=176,913 width=12) (actual time=0.129..23.295 rows=176,913 loops=1)

81. 1,621.409 2,639.076 ↑ 1.0 8,354,625 1

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

  • Buckets: 65536 Batches: 256 Memory Usage: 2168kB
82. 1,017.667 1,017.667 ↑ 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=0.113..1,017.667 rows=8,354,625 loops=1)

83. 0.037 0.069 ↑ 1.0 214 1

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

  • Buckets: 1024 Batches: 1 Memory Usage: 17kB
84. 0.032 0.032 ↑ 1.0 214 1

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

85. 0.057 0.109 ↑ 1.0 417 1

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

  • Buckets: 1024 Batches: 1 Memory Usage: 25kB
86. 0.052 0.052 ↑ 1.0 417 1

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

87. 0.338 0.617 ↑ 1.0 2,233 1

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

  • Buckets: 4096 Batches: 1 Memory Usage: 128kB
88. 0.279 0.279 ↑ 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.005..0.279 rows=2,233 loops=1)

89. 1,976.168 3,214.856 ↓ 1.0 11,348,823 1

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

  • Buckets: 131072 Batches: 256 Memory Usage: 2760kB
90. 1,238.688 1,238.688 ↓ 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=0.122..1,238.688 rows=11,348,823 loops=1)

Planning time : 16.590 ms
Execution time : 500,783.785 ms