explain.depesz.com

PostgreSQL's explain analyze made readable

Result: mFQd

Settings
# exclusive inclusive rows x rows loops node
1. 46,607.706 301,775.330 ↑ 62.2 8,426,168 1

Hash Left Join (cost=303,322,255.37..482,097,442.29 rows=524,272,116 width=630) (actual time=213,237.559..301,775.330 rows=8,426,168 loops=1)

  • Hash Cond: (bs.source_spot_id = inv.usn)
2. 35,574.045 243,825.270 ↑ 62.2 8,426,168 1

Hash Right Join (cost=302,939,124.49..331,819,864.49 rows=524,272,116 width=425) (actual time=201,894.535..243,825.270 rows=8,426,168 loops=1)

  • Hash Cond: (asdhh.usn = bs.source_spot_id)
3. 8,373.578 8,373.578 ↓ 19.4 637,100 1

Seq Scan on aired_spot_delivery asdhh (cost=0.00..179,052.88 rows=32,758 width=12) (actual time=23.086..8,373.578 rows=637,100 loops=1)

  • Filter: (upper((demo_cd)::text) = 'HH'::text)
  • Rows Removed by Filter: 5,914,393
4. 9,553.619 199,877.647 ↑ 62.2 8,426,168 1

Hash (cost=267,714,591.04..267,714,591.04 rows=524,272,116 width=417) (actual time=199,877.646..199,877.647 rows=8,426,168 loops=1)

  • Buckets: 16,384 Batches: 65,536 Memory Usage: 164kB
5. 3,611.921 190,324.028 ↑ 62.2 8,426,168 1

Hash Left Join (cost=46,423,626.12..267,714,591.04 rows=524,272,116 width=417) (actual time=144,825.938..190,324.028 rows=8,426,168 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)
6. 18,532.500 186,712.103 ↑ 31.1 8,426,168 1

Hash Left Join (cost=46,423,607.12..235,602,904.93 rows=262,136,058 width=413) (actual time=144,825.907..186,712.103 rows=8,426,168 loops=1)

  • Hash Cond: (bs.source_spot_id = sta.source_spot_id)
7. 16,611.966 161,910.702 ↑ 31.1 8,426,168 1

Hash Left Join (cost=46,042,400.38..202,305,426.91 rows=262,136,058 width=400) (actual time=138,411.712..161,910.702 rows=8,426,168 loops=1)

  • Hash Cond: (bs.source_spot_id = ssi.admiral_spot_id)
8. 2,990.278 141,733.339 ↑ 31.1 8,426,168 1

Hash Left Join (cost=45,833,070.71..172,049,649.05 rows=262,136,058 width=389) (actual time=99,014.745..141,733.339 rows=8,426,168 loops=1)

  • Hash Cond: (bs.secondary_product_conflict_id = dmpc.product_conflict_id)
9. 7,195.756 138,743.058 ↑ 31.1 8,426,168 1

Hash Left Join (cost=45,833,050.59..171,355,042.49 rows=262,136,058 width=389) (actual time=99,014.722..138,743.058 rows=8,426,168 loops=1)

  • Hash Cond: (bs.parent_order_id = prnt.order_id)
10. 10,857.301 131,493.864 ↑ 31.1 8,426,168 1

Hash Left Join (cost=45,827,475.57..141,633,554.95 rows=262,136,058 width=381) (actual time=98,960.608..131,493.864 rows=8,426,168 loops=1)

  • Hash Cond: ((bs.broadcast_week_date_sk = ga.broadcast_date_sk) AND ((bs.network_cd)::text = (ga.network_cd)::text) AND (bs.rate_card_type_id = ga.rate_card_type_id))
11. 2,901.283 120,613.734 ↑ 31.1 8,426,168 1

Hash Left Join (cost=45,823,218.79..82,566,267.98 rows=262,136,058 width=387) (actual time=98,937.258..120,613.734 rows=8,426,168 loops=1)

  • Hash Cond: (bs.team_id = dmtm.team_id)
12. 2,825.841 117,712.450 ↑ 31.1 8,426,168 1

Hash Left Join (cost=45,823,202.49..81,867,731.38 rows=262,136,058 width=387) (actual time=98,937.250..117,712.450 rows=8,426,168 loops=1)

  • Hash Cond: (bs.asr_user_id = dmasr.user_id)
13. 2,936.762 114,886.608 ↑ 31.1 8,426,168 1

Hash Left Join (cost=45,823,190.47..81,171,036.68 rows=262,136,058 width=387) (actual time=98,937.241..114,886.608 rows=8,426,168 loops=1)

  • Hash Cond: (bs.ae_user_id = dmae.user_id)
14. 2,788.947 111,949.843 ↑ 31.1 8,426,168 1

Hash Left Join (cost=45,823,178.44..80,464,694.49 rows=262,136,058 width=387) (actual time=98,937.226..111,949.843 rows=8,426,168 loops=1)

  • Hash Cond: (bs.order_revenue_type_id = dmrt.revenue_type_id)
15. 2,756.140 109,160.895 ↑ 31.1 8,426,168 1

Hash Left Join (cost=45,823,163.04..79,764,423.28 rows=262,136,058 width=387) (actual time=98,937.213..109,160.895 rows=8,426,168 loops=1)

  • Hash Cond: (bs.spot_revenue_type_id = dmspt.spot_revenue_type_id)
16. 7,467.911 106,404.753 ↑ 31.1 8,426,168 1

Hash Right Join (cost=45,823,147.64..79,064,152.06 rows=262,136,058 width=387) (actual time=98,937.187..106,404.753 rows=8,426,168 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))
17. 0.001 0.005 ↓ 0.0 0 1

Hash Join (cost=21.48..48.05 rows=1,310 width=18) (actual time=0.005..0.005 rows=0 loops=1)

  • Hash Cond: (stsp1.selling_period_sk = sp.selling_period_sk)
18. 0.004 0.004 ↓ 0.0 0 1

Seq Scan on dim_selling_title_selling_period stsp1 (cost=0.00..23.10 rows=1,310 width=14) (actual time=0.004..0.004 rows=0 loops=1)

19. 0.000 0.000 ↓ 0.0 0

Hash (cost=15.10..15.10 rows=510 width=12) (never executed)

20. 0.000 0.000 ↓ 0.0 0

Seq Scan on dim_selling_period sp (cost=0.00..15.10 rows=510 width=12) (never executed)

21. 7,729.383 98,936.837 ↑ 31.1 8,426,168 1

Hash (cost=29,234,828.44..29,234,828.44 rows=262,136,058 width=385) (actual time=98,936.837..98,936.837 rows=8,426,168 loops=1)

  • Buckets: 16,384 (originally 16384) Batches: 65,536 (originally 32768) Memory Usage: 2,582,096kB
22. 3,237.874 91,207.454 ↑ 31.1 8,426,168 1

Hash Left Join (cost=1,699,929.22..29,234,828.44 rows=262,136,058 width=385) (actual time=21,265.706..91,207.454 rows=8,426,168 loops=1)

  • Hash Cond: (bs.selling_title_id = dmst.selling_title_id)
23. 3,677.851 87,969.578 ↑ 31.1 8,426,168 1

Hash Left Join (cost=1,699,912.92..28,544,692.79 rows=262,136,058 width=385) (actual time=21,265.690..87,969.578 rows=8,426,168 loops=1)

  • Hash Cond: ((bs.spot_status_cd)::text = (dsst.spot_status_cd)::text)
24. 7,679.323 84,291.726 ↑ 13.5 8,426,168 1

Hash Left Join (cost=1,699,892.56..19,083,611.98 rows=113,994,998 width=381) (actual time=21,265.677..84,291.726 rows=8,426,168 loops=1)

  • Hash Cond: (lower(btrim(replace((bs.division_cd)::text, ' '::text, ''::text))) = (dmdv.division)::text)
25. 3,033.865 76,612.402 ↑ 5.8 8,426,168 1

Hash Left Join (cost=1,699,871.99..6,422,870.29 rows=48,508,510 width=382) (actual time=21,265.589..76,612.402 rows=8,426,168 loops=1)

  • Hash Cond: (bs.rate_card_type_id = dmrct.rate_card_type_id)
26. 3,079.210 73,578.536 ↑ 5.8 8,426,168 1

Hash Left Join (cost=1,699,854.56..6,293,882.71 rows=48,508,510 width=340) (actual time=21,265.556..73,578.536 rows=8,426,168 loops=1)

  • Hash Cond: (bs.property_id = dmdp.property_id)
27. 4,347.656 70,499.322 ↑ 5.8 8,426,168 1

Hash Left Join (cost=1,699,835.11..6,165,243.78 rows=48,508,510 width=340) (actual time=21,265.536..70,499.322 rows=8,426,168 loops=1)

  • Hash Cond: ((bs.network_cd)::text = (dmdn.network_cd)::text)
28. 4,752.548 66,151.550 ↑ 5.8 8,426,168 1

Hash Left Join (cost=1,699,822.47..5,498,239.12 rows=48,508,510 width=336) (actual time=21,265.404..66,151.550 rows=8,426,168 loops=1)

  • Hash Cond: ((bs.lh_deal_cd)::text = (dmdd.source_deal_id)::text)
29. 3,143.657 61,391.599 ↑ 5.8 8,426,168 1

Hash Left Join (cost=1,698,292.76..5,369,366.15 rows=48,508,510 width=341) (actual time=21,257.859..61,391.599 rows=8,426,168 loops=1)

  • Hash Cond: (bs.brand_id = dmbd.brand_id)
30. 3,240.790 58,247.941 ↑ 5.8 8,426,168 1

Hash Left Join (cost=1,698,276.46..5,241,940.34 rows=48,508,510 width=341) (actual time=21,257.844..58,247.941 rows=8,426,168 loops=1)

  • Hash Cond: (bs.order_type_id = dot.order_type_id)
31. 3,982.415 55,007.150 ↑ 2.2 8,426,168 1

Hash Left Join (cost=1,698,254.53..3,498,106.07 rows=18,308,760 width=335) (actual time=21,257.829..55,007.150 rows=8,426,168 loops=1)

  • Hash Cond: (bs.order_status_id = dos.order_status_id)
32. 2,916.608 51,024.729 ↓ 1.1 8,426,168 1

Hash Left Join (cost=1,698,233.73..2,838,207.04 rows=7,628,650 width=335) (actual time=21,257.810..51,024.729 rows=8,426,168 loops=1)

  • Hash Cond: (bs.agency_id = dmag.agency_id)
33. 3,119.607 48,108.120 ↓ 1.1 8,426,168 1

Hash Left Join (cost=1,698,218.33..2,817,966.31 rows=7,628,650 width=335) (actual time=21,257.797..48,108.120 rows=8,426,168 loops=1)

  • Hash Cond: (bs.advertiser_id = dmad.advertiser_id)
34. 3,308.450 44,988.512 ↓ 1.1 8,426,168 1

Hash Left Join (cost=1,698,202.94..2,797,872.44 rows=7,628,650 width=335) (actual time=21,257.782..44,988.512 rows=8,426,168 loops=1)

  • Hash Cond: (bs.order_id = ord_st.order_id)
35. 2,975.353 41,679.899 ↓ 1.1 8,426,168 1

Hash Left Join (cost=1,698,184.80..2,768,375.26 rows=7,628,650 width=335) (actual time=21,257.605..41,679.899 rows=8,426,168 loops=1)

  • Hash Cond: (bs.order_id = dmo.source_order_id)
36. 15,195.183 38,704.544 ↓ 1.1 8,426,168 1

Hash Right Join (cost=1,698,169.85..2,539,195.47 rows=7,628,650 width=327) (actual time=21,257.552..38,704.544 rows=8,426,168 loops=1)

  • Hash Cond: (sds.source_spot_id = bs.source_spot_id)
37. 2,269.289 2,269.289 ↑ 1.0 10,976,509 1

Seq Scan on stage_deal_to_spot sds (cost=0.00..233,818.38 rows=10,978,838 width=16) (actual time=0.122..2,269.289 rows=10,976,509 loops=1)

38. 7,478.384 21,240.072 ↓ 1.1 8,426,168 1

Hash (cost=1,282,467.73..1,282,467.73 rows=7,628,650 width=315) (actual time=21,240.072..21,240.072 rows=8,426,168 loops=1)

  • Buckets: 16,384 Batches: 1,024 Memory Usage: 2,844kB
39. 13,761.688 13,761.688 ↓ 1.1 8,426,168 1

Seq Scan on blended_spots bs (cost=0.00..1,282,467.73 rows=7,628,650 width=315) (actual time=0.116..13,761.688 rows=8,426,168 loops=1)

  • Filter: ((source_spot_id_desc = ANY ('{"usn - aired spot","usn - booked spot"}'::text[])) OR (additional_admiral_order = 1) OR (is_manual_adjustment = 1))
  • Rows Removed by Filter: 11,327,026
40. 0.000 0.002 ↓ 0.0 0 1

Hash (cost=12.20..12.20 rows=220 width=16) (actual time=0.002..0.002 rows=0 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 8kB
41. 0.002 0.002 ↓ 0.0 0 1

Seq Scan on dim_order dmo (cost=0.00..12.20 rows=220 width=16) (actual time=0.002..0.002 rows=0 loops=1)

42. 0.089 0.163 ↑ 1.0 628 1

Hash (cost=10.28..10.28 rows=628 width=8) (actual time=0.163..0.163 rows=628 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 33kB
43. 0.074 0.074 ↑ 1.0 628 1

Seq Scan on assign_order_status ord_st (cost=0.00..10.28 rows=628 width=8) (actual time=0.006..0.074 rows=628 loops=1)

44. 0.000 0.001 ↓ 0.0 0 1

Hash (cost=12.40..12.40 rows=240 width=8) (actual time=0.001..0.001 rows=0 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 8kB
45. 0.001 0.001 ↓ 0.0 0 1

Seq Scan on dim_advertiser dmad (cost=0.00..12.40 rows=240 width=8) (actual time=0.001..0.001 rows=0 loops=1)

46. 0.000 0.001 ↓ 0.0 0 1

Hash (cost=12.40..12.40 rows=240 width=8) (actual time=0.001..0.001 rows=0 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 8kB
47. 0.001 0.001 ↓ 0.0 0 1

Seq Scan on dim_agency dmag (cost=0.00..12.40 rows=240 width=8) (actual time=0.001..0.001 rows=0 loops=1)

48. 0.003 0.006 ↑ 68.6 7 1

Hash (cost=14.80..14.80 rows=480 width=8) (actual time=0.006..0.006 rows=7 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 9kB
49. 0.003 0.003 ↑ 68.6 7 1

Seq Scan on dim_order_status dos (cost=0.00..14.80 rows=480 width=8) (actual time=0.002..0.003 rows=7 loops=1)

50. 0.000 0.001 ↓ 0.0 0 1

Hash (cost=15.30..15.30 rows=530 width=12) (actual time=0.001..0.001 rows=0 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 8kB
51. 0.001 0.001 ↓ 0.0 0 1

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

52. 0.000 0.001 ↓ 0.0 0 1

Hash (cost=12.80..12.80 rows=280 width=8) (actual time=0.001..0.001 rows=0 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 8kB
53. 0.001 0.001 ↓ 0.0 0 1

Seq Scan on dim_brand dmbd (cost=0.00..12.80 rows=280 width=8) (actual time=0.001..0.001 rows=0 loops=1)

54. 3.731 7.403 ↑ 1.0 19,898 1

Hash (cost=1,280.98..1,280.98 rows=19,898 width=20) (actual time=7.403..7.403 rows=19,898 loops=1)

  • Buckets: 32,768 Batches: 1 Memory Usage: 1,267kB
55. 3.672 3.672 ↑ 1.0 19,898 1

Seq Scan on dim_deal dmdd (cost=0.00..1,280.98 rows=19,898 width=20) (actual time=0.115..3.672 rows=19,898 loops=1)

56. 0.066 0.116 ↑ 1.0 340 1

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

  • Buckets: 1,024 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.001 0.004 ↓ 0.0 0 1

Hash (cost=14.20..14.20 rows=420 width=8) (actual time=0.003..0.004 rows=0 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 8kB
59. 0.003 0.003 ↓ 0.0 0 1

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

60. 0.000 0.001 ↓ 0.0 0 1

Hash (cost=13.30..13.30 rows=330 width=46) (actual time=0.001..0.001 rows=0 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 8kB
61. 0.001 0.001 ↓ 0.0 0 1

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

62. 0.000 0.001 ↓ 0.0 0 1

Hash (cost=14.70..14.70 rows=470 width=62) (actual time=0.001..0.001 rows=0 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 8kB
63. 0.001 0.001 ↓ 0.0 0 1

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

64. 0.000 0.001 ↓ 0.0 0 1

Hash (cost=14.60..14.60 rows=460 width=36) (actual time=0.001..0.001 rows=0 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 8kB
65. 0.001 0.001 ↓ 0.0 0 1

Seq Scan on dim_spot_status dsst (cost=0.00..14.60 rows=460 width=36) (actual time=0.001..0.001 rows=0 loops=1)

66. 0.001 0.002 ↓ 0.0 0 1

Hash (cost=12.80..12.80 rows=280 width=8) (actual time=0.002..0.002 rows=0 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 8kB
67. 0.001 0.001 ↓ 0.0 0 1

Seq Scan on dim_selling_title dmst (cost=0.00..12.80 rows=280 width=8) (actual time=0.001..0.001 rows=0 loops=1)

68. 0.001 0.002 ↓ 0.0 0 1

Hash (cost=12.40..12.40 rows=240 width=8) (actual time=0.002..0.002 rows=0 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 8kB
69. 0.001 0.001 ↓ 0.0 0 1

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

70. 0.000 0.001 ↓ 0.0 0 1

Hash (cost=12.40..12.40 rows=240 width=8) (actual time=0.001..0.001 rows=0 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 8kB
71. 0.001 0.001 ↓ 0.0 0 1

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

72. 0.000 0.003 ↓ 0.0 0 1

Hash (cost=10.90..10.90 rows=90 width=8) (actual time=0.003..0.003 rows=0 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 8kB
73. 0.003 0.003 ↓ 0.0 0 1

Seq Scan on dim_user dmae (cost=0.00..10.90 rows=90 width=8) (actual time=0.003..0.003 rows=0 loops=1)

74. 0.000 0.001 ↓ 0.0 0 1

Hash (cost=10.90..10.90 rows=90 width=8) (actual time=0.001..0.001 rows=0 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 8kB
75. 0.001 0.001 ↓ 0.0 0 1

Seq Scan on dim_user dmasr (cost=0.00..10.90 rows=90 width=8) (actual time=0.001..0.001 rows=0 loops=1)

76. 0.000 0.001 ↓ 0.0 0 1

Hash (cost=12.80..12.80 rows=280 width=8) (actual time=0.001..0.001 rows=0 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 8kB
77. 0.001 0.001 ↓ 0.0 0 1

Seq Scan on dim_team dmtm (cost=0.00..12.80 rows=280 width=8) (actual time=0.001..0.001 rows=0 loops=1)

78. 8.285 22.829 ↓ 0.0 0 1

Hash (cost=1,972.92..1,972.92 rows=101,992 width=15) (actual time=22.829..22.829 rows=0 loops=1)

  • Buckets: 131,072 Batches: 2 Memory Usage: 1,024kB
79. 14.544 14.544 ↑ 1.0 101,992 1

Seq Scan on genesis_avails ga (cost=0.00..1,972.92 rows=101,992 width=15) (actual time=0.132..14.544 rows=101,992 loops=1)

80. 32.014 53.438 ↑ 1.0 175,245 1

Hash (cost=2,528.45..2,528.45 rows=175,245 width=12) (actual time=53.437..53.438 rows=175,245 loops=1)

  • Buckets: 131,072 Batches: 4 Memory Usage: 2,572kB
81. 21.424 21.424 ↑ 1.0 175,245 1

Seq Scan on parents prnt (cost=0.00..2,528.45 rows=175,245 width=12) (actual time=0.120..21.424 rows=175,245 loops=1)

82. 0.001 0.003 ↓ 0.0 0 1

Hash (cost=14.50..14.50 rows=450 width=8) (actual time=0.003..0.003 rows=0 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 8kB
83. 0.002 0.002 ↓ 0.0 0 1

Seq Scan on dim_product_conflict dmpc (cost=0.00..14.50 rows=450 width=8) (actual time=0.002..0.002 rows=0 loops=1)

84. 1,153.442 3,565.397 ↓ 1.0 5,826,946 1

Hash (cost=108,045.52..108,045.52 rows=5,826,652 width=15) (actual time=3,565.397..3,565.397 rows=5,826,946 loops=1)

  • Buckets: 131,072 Batches: 128 Memory Usage: 2,995kB
85. 2,411.955 2,411.955 ↓ 1.0 5,826,946 1

Seq Scan on stage_spot_isci ssi (cost=0.00..108,045.52 rows=5,826,652 width=15) (actual time=7.453..2,411.955 rows=5,826,946 loops=1)

86. 2,533.827 6,268.901 ↑ 1.0 10,976,509 1

Hash (cost=179,681.55..179,681.55 rows=10,976,655 width=17) (actual time=6,268.900..6,268.901 rows=10,976,509 loops=1)

  • Buckets: 65,536 Batches: 256 Memory Usage: 2,699kB
87. 3,735.074 3,735.074 ↑ 1.0 10,976,509 1

Seq Scan on spot_tracking_audience sta (cost=0.00..179,681.55 rows=10,976,655 width=17) (actual time=5.380..3,735.074 rows=10,976,509 loops=1)

88. 0.001 0.004 ↓ 0.0 0 1

Hash (cost=14.00..14.00 rows=400 width=62) (actual time=0.004..0.004 rows=0 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 8kB
89. 0.003 0.003 ↓ 0.0 0 1

Seq Scan on dim_audience dmda (cost=0.00..14.00 rows=400 width=62) (actual time=0.003..0.003 rows=0 loops=1)

90. 2,279.294 11,342.354 ↑ 1.0 11,348,823 1

Hash (cost=196,937.28..196,937.28 rows=11,348,928 width=8) (actual time=11,342.354..11,342.354 rows=11,348,823 loops=1)

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

Seq Scan on invoice_data inv (cost=0.00..196,937.28 rows=11,348,928 width=8) (actual time=4.947..9,063.060 rows=11,348,823 loops=1)

Planning time : 95.912 ms
Execution time : 350,052.695 ms