explain.depesz.com

PostgreSQL's explain analyze made readable

Result: dkKJ

Settings
# exclusive inclusive rows x rows loops node
1. 0.001 7,706.686 ↑ 3,337.0 10 1

Append (cost=1,852,264.82..1,853,374.16 rows=33,370 width=96) (actual time=7,654.338..7,706.686 rows=10 loops=1)

2.          

CTE picklist_0

3. 0.017 0.017 ↑ 1.0 1 1

Seq Scan on t60_opportunitystagenamepicklistdim (cost=0.00..2.24 rows=1 width=4) (actual time=0.012..0.017 rows=1 loops=1)

  • Filter: (correlated_value = 'Win - 100%'::text)
  • Rows Removed by Filter: 18
4.          

CTE docd_cte_1

5. 22.450 1,750.346 ↑ 2.8 13,187 1

HashAggregate (cost=405,855.62..406,231.02 rows=37,540 width=4) (actual time=1,748.043..1,750.346 rows=13,187 loops=1)

  • Group Key: t67_distinct_opp_owner_closedate.c759_ownerid
6. 93.231 1,727.896 ↑ 1.0 99,727 1

Hash Join (cost=225,550.22..405,604.64 rows=100,391 width=4) (actual time=850.608..1,727.896 rows=99,727 loops=1)

  • Hash Cond: (t67_distinct_opp_owner_closedate.c759_ownerid = t55_userrolehierarchy.sid)
7. 785.936 785.936 ↓ 1.1 213,595 1

Seq Scan on t67_distinct_opp_owner_closedate (cost=0.00..156,103.63 rows=200,782 width=4) (actual time=0.340..785.936 rows=213,595 loops=1)

  • Filter: ((c760_closedate >= 20190202) AND (c760_closedate <= 20190503))
  • Rows Removed by Filter: 5954245
8. 50.768 848.729 ↑ 1.0 363,469 1

Hash (cost=219,341.13..219,341.13 rows=378,407 width=4) (actual time=848.729..848.729 rows=363,469 loops=1)

  • Buckets: 131072 Batches: 8 Memory Usage: 2639kB
9. 47.997 797.961 ↑ 1.0 363,469 1

Unique (cost=213,665.03..215,557.06 rows=378,407 width=4) (actual time=702.569..797.961 rows=363,469 loops=1)

10. 224.640 749.964 ↓ 1.0 389,844 1

Sort (cost=213,665.03..214,611.04 rows=378,407 width=4) (actual time=702.566..749.964 rows=389,844 loops=1)

  • Sort Key: t55_userrolehierarchy.sid
  • Sort Method: external merge Disk: 5336kB
11. 33.217 525.324 ↓ 1.0 389,844 1

Append (cost=25,500.11..173,429.91 rows=378,407 width=4) (actual time=72.380..525.324 rows=389,844 loops=1)

12. 131.532 368.350 ↓ 1.2 389,678 1

Hash Join (cost=25,500.11..120,368.88 rows=316,841 width=4) (actual time=72.380..368.350 rows=389,678 loops=1)

  • Hash Cond: (t55_userrolehierarchy.c697_user_role_id = t33_userroledim.sid)
13. 174.079 221.881 ↑ 1.0 550,251 1

Bitmap Heap Scan on t55_userrolehierarchy (cost=16,969.25..109,211.80 rows=563,970 width=8) (actual time=57.288..221.881 rows=550,251 loops=1)

  • Recheck Cond: ((c698_ancestor_role_id = 437) AND (end_stamp = '32503680000000'::bigint))
  • Heap Blocks: exact=50118
14. 47.802 47.802 ↑ 1.0 550,257 1

Bitmap Index Scan on idx_49_t55_userrolehierarchy_c698_ancestor_role_id_end_stamp_st (cost=0.00..16,828.26 rows=563,970 width=0) (actual time=47.802..47.802 rows=550,257 loops=1)

  • Index Cond: ((c698_ancestor_role_id = 437) AND (end_stamp = '32503680000000'::bigint))
15. 3.929 14.937 ↓ 1.0 26,450 1

Hash (cost=8,207.82..8,207.82 rows=25,843 width=4) (actual time=14.937..14.937 rows=26,450 loops=1)

  • Buckets: 32768 Batches: 1 Memory Usage: 1186kB
16. 9.074 11.008 ↓ 1.0 26,450 1

Bitmap Heap Scan on t33_userroledim (cost=720.57..8,207.82 rows=25,843 width=4) (actual time=2.030..11.008 rows=26,450 loops=1)

  • Recheck Cond: ((end_stamp = '32503680000000'::bigint) AND ((c412_portaltype IS NULL) OR (c412_portaltype = 'None'::text)))
  • Filter: ((NOT deleted) AND (sid <> '-2'::integer))
  • Rows Removed by Filter: 1
  • Heap Blocks: exact=735
17. 1.934 1.934 ↓ 1.0 26,451 1

Bitmap Index Scan on "idx_9_t33_userroledim_sid_start_stamp_end_stamp_(c412_portaltyp" (cost=0.00..714.11 rows=25,843 width=0) (actual time=1.934..1.934 rows=26,451 loops=1)

  • Index Cond: (end_stamp = '32503680000000'::bigint)
18. 107.282 123.757 ↑ 370.9 166 1

Bitmap Heap Scan on t47_userdim (cost=5,627.51..49,276.97 rows=61,566 width=4) (actual time=19.072..123.757 rows=166 loops=1)

  • Recheck Cond: ((c577_userroleid IS NULL) AND (end_stamp = '32503680000000'::bigint))
  • Filter: ((NOT deleted) AND (sid <> '-2'::integer) AND (c587_usertype = 'Standard'::text))
  • Rows Removed by Filter: 188439
  • Heap Blocks: exact=15559
19. 16.475 16.475 ↓ 1.0 188,605 1

Bitmap Index Scan on idx_6_t47_userdim_c577_userroleid_end_stamp_start_stamp_null (cost=0.00..5,612.12 rows=187,969 width=0) (actual time=16.475..16.475 rows=188,605 loops=1)

  • Index Cond: ((c577_userroleid IS NULL) AND (end_stamp = '32503680000000'::bigint))
20.          

CTE picklist_4

21. 0.021 0.021 ↑ 1.0 1 1

Seq Scan on t60_opportunitystagenamepicklistdim t60_opportunitystagenamepicklistdim_1 (cost=0.00..2.24 rows=1 width=4) (actual time=0.016..0.021 rows=1 loops=1)

  • Filter: (correlated_value = 'Lost, Cancelled - 0%'::text)
  • Rows Removed by Filter: 18
22.          

CTE openwont1

23. 83.591 7,021.934 ↑ 1.7 94,932 1

Merge Right Join (cost=1,149,176.90..1,159,828.39 rows=157,981 width=34) (actual time=6,881.646..7,021.934 rows=94,932 loops=1)

  • Merge Cond: ((t54_clari_conversion_rate_1.sid = t52_opp_line_item_fact_1.c641_opp_currency_code) AND (t54_clari_conversion_rate_1.rate_date = t52_opp_line_item_fact_1.c658_opp_close_date))
24. 4.671 38.960 ↑ 1.0 65,896 1

Merge Append (cost=0.31..5,835.47 rows=66,109 width=16) (actual time=0.019..38.960 rows=65,896 loops=1)

  • Sort Key: t54_clari_conversion_rate_1.sid, t54_clari_conversion_rate_1.rate_date
25. 0.004 0.005 ↓ 0.0 0 1

Sort (cost=0.01..0.02 rows=1 width=16) (actual time=0.005..0.005 rows=0 loops=1)

  • Sort Key: t54_clari_conversion_rate_1.sid, t54_clari_conversion_rate_1.rate_date
  • Sort Method: quicksort Memory: 25kB
26. 0.001 0.001 ↓ 0.0 0 1

Seq Scan on t54_clari_conversion_rate t54_clari_conversion_rate_1 (cost=0.00..0.00 rows=1 width=16) (actual time=0.001..0.001 rows=0 loops=1)

  • Filter: (to_iso_code = 'USD'::text)
27. 34.284 34.284 ↑ 1.0 65,896 1

Index Scan using t54_clari_conversion_rate_usd_sidratedateunique on t54_clari_conversion_rate_usd t54_clari_conversion_rate_usd_1 (cost=0.29..5,009.08 rows=66,108 width=16) (actual time=0.014..34.284 rows=65,896 loops=1)

  • Filter: (to_iso_code = 'USD'::text)
28. 9.991 6,898.350 ↑ 1.7 94,932 1

Materialize (cost=1,148,331.89..1,149,121.79 rows=157,981 width=56) (actual time=6,874.519..6,898.350 rows=94,932 loops=1)

29. 103.082 6,888.359 ↑ 1.7 94,932 1

Sort (cost=1,148,331.89..1,148,726.84 rows=157,981 width=56) (actual time=6,874.510..6,888.359 rows=94,932 loops=1)

  • Sort Key: t52_opp_line_item_fact_1.c641_opp_currency_code, t52_opp_line_item_fact_1.c658_opp_close_date
  • Sort Method: external sort Disk: 6496kB
30. 16.260 6,785.277 ↑ 1.7 94,932 1

Nested Loop Left Join (cost=395,210.29..1,129,290.21 rows=157,981 width=56) (actual time=6,397.050..6,785.277 rows=94,932 loops=1)

31. 24.002 6,484.221 ↑ 1.7 94,932 1

Merge Right Join (cost=395,209.72..403,096.55 rows=157,981 width=28) (actual time=6,397.023..6,484.221 rows=94,932 loops=1)

  • Merge Cond: ((t54_clari_conversion_rate.sid = t52_opp_line_item_fact.c641_opp_currency_code) AND (t54_clari_conversion_rate.rate_date = t52_opp_line_item_fact.c658_opp_close_date))
32. 4.625 41.710 ↑ 1.0 65,896 1

Merge Append (cost=0.31..5,835.47 rows=66,109 width=16) (actual time=0.013..41.710 rows=65,896 loops=1)

  • Sort Key: t54_clari_conversion_rate.sid, t54_clari_conversion_rate.rate_date
33. 0.005 0.006 ↓ 0.0 0 1

Sort (cost=0.01..0.02 rows=1 width=16) (actual time=0.006..0.006 rows=0 loops=1)

  • Sort Key: t54_clari_conversion_rate.sid, t54_clari_conversion_rate.rate_date
  • Sort Method: quicksort Memory: 25kB
34. 0.001 0.001 ↓ 0.0 0 1

Seq Scan on t54_clari_conversion_rate (cost=0.00..0.00 rows=1 width=16) (actual time=0.000..0.001 rows=0 loops=1)

  • Filter: (to_iso_code = 'USD'::text)
35. 37.079 37.079 ↑ 1.0 65,896 1

Index Scan using t54_clari_conversion_rate_usd_sidratedateunique on t54_clari_conversion_rate_usd (cost=0.29..5,009.08 rows=66,108 width=16) (actual time=0.007..37.079 rows=65,896 loops=1)

  • Filter: (to_iso_code = 'USD'::text)
36. 9.542 6,418.509 ↑ 1.7 94,932 1

Materialize (cost=395,209.41..395,999.32 rows=157,981 width=28) (actual time=6,393.686..6,418.509 rows=94,932 loops=1)

37. 104.114 6,408.967 ↑ 1.7 94,932 1

Sort (cost=395,209.41..395,604.36 rows=157,981 width=28) (actual time=6,393.683..6,408.967 rows=94,932 loops=1)

  • Sort Key: t52_opp_line_item_fact.c641_opp_currency_code, t52_opp_line_item_fact.c658_opp_close_date
  • Sort Method: external merge Disk: 3896kB
38. 21.344 6,304.853 ↑ 1.7 94,932 1

Nested Loop (cost=845.24..377,788.23 rows=157,981 width=28) (actual time=1,757.600..6,304.853 rows=94,932 loops=1)

39. 7.116 1,760.368 ↓ 65.9 13,187 1

HashAggregate (cost=844.65..846.65 rows=200 width=4) (actual time=1,756.656..1,760.368 rows=13,187 loops=1)

  • Group Key: cte0_6.c1
40. 1,753.252 1,753.252 ↑ 2.8 13,187 1

CTE Scan on docd_cte_1 cte0_6 (cost=0.00..750.80 rows=37,540 width=4) (actual time=1,748.046..1,753.252 rows=13,187 loops=1)

41. 4,523.119 4,523.141 ↑ 1.6 7 13,187

Index Scan using t52_opp_line_item_fact_296_timestamp on t52_opp_line_item_fact (cost=0.58..1,884.60 rows=11 width=32) (actual time=0.278..0.343 rows=7 loops=13,187)

  • Index Cond: ((c647_opp_ownerid = cte0_6.c1) AND (c647_opp_ownerid IS NOT NULL) AND (start_stamp <= '1551513599999'::bigint) AND (end_stamp > '1551513599999'::bigint))
  • Filter: ((NOT deleted) AND (c658_opp_close_date >= 20190202) AND (c658_opp_close_date <= 20190503) AND (NOT (hashed SubPlan 7)))
  • Rows Removed by Filter: 414
42.          

SubPlan (for Index Scan)

43. 0.022 0.022 ↑ 1.0 1 1

CTE Scan on picklist_4 cte0_5 (cost=0.00..0.02 rows=1 width=4) (actual time=0.017..0.022 rows=1 loops=1)

44. 284.796 284.796 ↑ 1.0 1 94,932

Index Scan using t52_opp_line_item_fact_sidendstampunique on t52_opp_line_item_fact t52_opp_line_item_fact_1 (cost=0.56..4.59 rows=1 width=28) (actual time=0.003..0.003 rows=1 loops=94,932)

  • Index Cond: ((t52_opp_line_item_fact.sid = sid) AND (t52_opp_line_item_fact.sid = sid) AND (end_stamp > '1572073199999'::bigint))
  • Filter: ((NOT deleted) AND (start_stamp <= '1572073199999'::bigint))
  • Rows Removed by Filter: 0
45.          

SubPlan (for Merge Right Join)

46. 0.002 0.002 ↑ 1.0 1 1

CTE Scan on picklist_0 cte0_2 (cost=0.00..0.02 rows=1 width=4) (actual time=0.001..0.002 rows=1 loops=1)

47. 1.030 1.030 ↑ 2.8 13,187 1

CTE Scan on docd_cte_1 cte0_3 (cost=0.00..750.80 rows=37,540 width=4) (actual time=0.001..1.030 rows=13,187 loops=1)

48. 0.001 0.001 ↑ 1.0 1 1

CTE Scan on picklist_0 cte0_4 (cost=0.00..0.02 rows=1 width=4) (actual time=0.000..0.001 rows=1 loops=1)

49.          

CTE openwont1ids

50. 45.307 7,106.258 ↓ 474.7 94,932 1

HashAggregate (cost=3,554.57..3,556.57 rows=200 width=4) (actual time=7,091.638..7,106.258 rows=94,932 loops=1)

  • Group Key: cte0_7.c1
51. 7,060.951 7,060.951 ↑ 1.7 94,932 1

CTE Scan on openwont1 cte0_7 (cost=0.00..3,159.62 rows=157,981 width=4) (actual time=6,881.647..7,060.951 rows=94,932 loops=1)

52.          

CTE bucketab

53. 32.278 52.301 ↑ 1,755.3 9 1

HashAggregate (cost=5,529.34..5,687.31 rows=15,798 width=68) (actual time=52.276..52.301 rows=9 loops=1)

  • Group Key: cte0_8.c5, CASE WHEN cte0_8.c6 THEN CASE WHEN cte0_8.c4 THEN 'convertedWon'::text ELSE 'convertedOpen'::text END ELSE CASE WHEN cte0_8.c4 THEN 'unconvertedWon'::text ELSE 'unconvertedOpen'::text END END, cte0_8.c3
54. 20.023 20.023 ↑ 1.7 94,932 1

CTE Scan on openwont1 cte0_8 (cost=0.00..3,159.62 rows=157,981 width=64) (actual time=0.017..20.023 rows=94,932 loops=1)

55.          

CTE picklist_5

56. 0.000 0.000 ↓ 0.0 0

Seq Scan on t60_opportunitystagenamepicklistdim t60_opportunitystagenamepicklistdim_2 (cost=0.00..2.24 rows=2 width=4) (never executed)

  • Filter: (correlated_value = ANY ('{"Lost, Cancelled - 0%","Win - 100%"}'::text[]))
57.          

CTE bucketd

58. 11.297 7,654.323 ↑ 17,572.0 1 1

GroupAggregate (cost=276,251.94..276,954.82 rows=17,572 width=120) (actual time=7,654.323..7,654.323 rows=1 loops=1)

  • Group Key: '1551513599999'::bigint, (CASE WHEN (t52_opp_line_item_fact_3.sid IS NULL) THEN 'trendNew'::text WHEN (NOT (hashed SubPlan 12)) THEN CASE WHEN (t52_opp_line_item_fact_3.c658_opp_close_date > 20190503) THEN 'pulledIn'::text WHEN (t52_opp_line_item_fact_3.c658_opp_close_date < 20190202) THEN 'pushedIn'::text WHEN ((t52_opp_line_item_fact_3.c658_opp_close_date >= 20190202) AND (t52_opp_line_item_fact_3.c658_opp_close_date <= 20190503) AND (hashed SubPlan 13) AND (t52_opp_line_item_fact_3.c647_opp_ownerid IS NOT NULL)) THEN 'other'::text ELSE 'ownerChange'::text END ELSE 'other'::text END)
59. 24.013 7,643.026 ↓ 2.7 48,054 1

Sort (cost=275,407.24..275,451.17 rows=17,572 width=60) (actual time=7,637.004..7,643.026 rows=48,054 loops=1)

  • Sort Key: (CASE WHEN (t52_opp_line_item_fact_3.sid IS NULL) THEN 'trendNew'::text WHEN (NOT (hashed SubPlan 12)) THEN CASE WHEN (t52_opp_line_item_fact_3.c658_opp_close_date > 20190503) THEN 'pulledIn'::text WHEN (t52_opp_line_item_fact_3.c658_opp_close_date < 20190202) THEN 'pushedIn'::text WHEN ((t52_opp_line_item_fact_3.c658_opp_close_date >= 20190202) AND (t52_opp_line_item_fact_3.c658_opp_close_date <= 20190503) AND (hashed SubPlan 13) AND (t52_opp_line_item_fact_3.c647_opp_ownerid IS NOT NULL)) THEN 'other'::text ELSE 'ownerChange'::text END ELSE 'other'::text END)
  • Sort Method: external sort Disk: 2352kB
60. 26.097 7,619.013 ↓ 2.7 48,054 1

Nested Loop Left Join (cost=1,699.49..274,168.33 rows=17,572 width=60) (actual time=7,160.451..7,619.013 rows=48,054 loops=1)

61. 15.240 7,496.808 ↓ 2.7 48,054 1

Nested Loop Left Join (cost=854.24..195,576.55 rows=17,572 width=20) (actual time=7,160.432..7,496.808 rows=48,054 loops=1)

62. 18.674 7,385.460 ↓ 2.7 48,054 1

Hash Join (cost=854.24..189,477.78 rows=17,572 width=20) (actual time=7,160.391..7,385.460 rows=48,054 loops=1)

  • Hash Cond: (t52_opp_line_item_fact_2.c647_opp_ownerid = cte0_12.c1)
63. 15.041 7,359.577 ↓ 3.0 106,202 1

Nested Loop (cost=5.08..188,494.35 rows=35,148 width=24) (actual time=7,152.670..7,359.577 rows=106,202 loops=1)

64. 0.004 0.024 ↑ 1.0 1 1

HashAggregate (cost=0.02..0.03 rows=1 width=4) (actual time=0.023..0.024 rows=1 loops=1)

  • Group Key: cte0_13.c1
65. 0.020 0.020 ↑ 1.0 1 1

CTE Scan on picklist_0 cte0_13 (cost=0.00..0.02 rows=1 width=4) (actual time=0.014..0.020 rows=1 loops=1)

66. 215.612 7,344.512 ↓ 3.0 106,202 1

Index Scan using idx_38_t52_opp_line_item_fact_c658_opp_close_date_c650_opp_stag on t52_opp_line_item_fact t52_opp_line_item_fact_2 (cost=5.06..188,142.83 rows=35,148 width=28) (actual time=7,152.643..7,344.512 rows=106,202 loops=1)

  • Index Cond: ((c658_opp_close_date >= 20190202) AND (c658_opp_close_date <= 20190503) AND (c650_opp_stagename = cte0_13.c1) AND (start_stamp <= '1572073199999'::bigint) AND (end_stamp > '1572073199999'::bigint))
  • Filter: ((NOT deleted) AND (c647_opp_ownerid IS NOT NULL) AND (NOT (hashed SubPlan 14)))
  • Rows Removed by Filter: 83547
67.          

SubPlan (for Index Scan)

68. 7,128.900 7,128.900 ↓ 474.7 94,932 1

CTE Scan on openwont1ids cte0_11 (cost=0.00..4.00 rows=200 width=4) (actual time=7,091.639..7,128.900 rows=94,932 loops=1)

69. 1.782 7.209 ↓ 65.9 13,187 1

Hash (cost=846.65..846.65 rows=200 width=4) (actual time=7.209..7.209 rows=13,187 loops=1)

  • Buckets: 16384 (originally 1024) Batches: 1 (originally 1) Memory Usage: 592kB
70. 4.396 5.427 ↓ 65.9 13,187 1

HashAggregate (cost=844.65..846.65 rows=200 width=4) (actual time=4.045..5.427 rows=13,187 loops=1)

  • Group Key: cte0_12.c1
71. 1.031 1.031 ↑ 2.8 13,187 1

CTE Scan on docd_cte_1 cte0_12 (cost=0.00..750.80 rows=37,540 width=4) (actual time=0.001..1.031 rows=13,187 loops=1)

72. 0.000 96.108 ↑ 2.0 1 48,054

Append (cost=0.00..0.33 rows=2 width=16) (actual time=0.002..0.002 rows=1 loops=48,054)

73. 0.000 0.000 ↓ 0.0 0 48,054

Seq Scan on t54_clari_conversion_rate t54_clari_conversion_rate_2 (cost=0.00..0.00 rows=1 width=16) (actual time=0.000..0.000 rows=0 loops=48,054)

  • Filter: ((to_iso_code = 'USD'::text) AND (t52_opp_line_item_fact_2.c641_opp_currency_code = sid) AND (t52_opp_line_item_fact_2.c658_opp_close_date = rate_date))
74. 96.108 96.108 ↑ 1.0 1 48,054

Index Scan using t54_clari_conversion_rate_usd_sidratedateunique on t54_clari_conversion_rate_usd t54_clari_conversion_rate_usd_2 (cost=0.29..0.33 rows=1 width=16) (actual time=0.001..0.002 rows=1 loops=48,054)

  • Index Cond: ((t52_opp_line_item_fact_2.c641_opp_currency_code = sid) AND (t52_opp_line_item_fact_2.c658_opp_close_date = rate_date))
  • Filter: (to_iso_code = 'USD'::text)
75. 96.108 96.108 ↓ 0.0 0 48,054

Index Scan using t52_opp_line_item_fact_sidendstampunique on t52_opp_line_item_fact t52_opp_line_item_fact_3 (cost=0.56..4.40 rows=1 width=16) (actual time=0.002..0.002 rows=0 loops=48,054)

  • Index Cond: ((t52_opp_line_item_fact_2.sid = sid) AND (t52_opp_line_item_fact_2.sid = sid) AND (end_stamp > '1551513599999'::bigint))
  • Filter: ((NOT deleted) AND (start_stamp <= '1551513599999'::bigint))
  • Rows Removed by Filter: 1
76.          

SubPlan (for Nested Loop Left Join)

77. 0.000 0.000 ↓ 0.0 0

CTE Scan on picklist_5 cte0_9 (cost=0.00..0.04 rows=2 width=4) (never executed)

78. 0.000 0.000 ↓ 0.0 0

CTE Scan on docd_cte_1 cte0_10 (cost=0.00..750.80 rows=37,540 width=4) (never executed)

79. 0.011 7,654.339 ↑ 17,572.0 1 1

Subquery Scan on *SELECT* 1 (cost=0.00..571.09 rows=17,572 width=96) (actual time=7,654.338..7,654.339 rows=1 loops=1)

80. 7,654.328 7,654.328 ↑ 17,572.0 1 1

CTE Scan on bucketd cte0 (cost=0.00..351.44 rows=17,572 width=120) (actual time=7,654.327..7,654.328 rows=1 loops=1)

81. 0.027 52.346 ↑ 1,755.3 9 1

Hash Left Join (cost=1.11..380.26 rows=15,798 width=72) (actual time=52.313..52.346 rows=9 loops=1)

  • Hash Cond: (cte0_1.c6 = t58_opportunityforecastcategorypicklistdim.sid)
82. 52.307 52.307 ↑ 1,755.3 9 1

CTE Scan on bucketab cte0_1 (cost=0.00..315.96 rows=15,798 width=68) (actual time=52.278..52.307 rows=9 loops=1)

83. 0.004 0.012 ↑ 1.0 5 1

Hash (cost=1.05..1.05 rows=5 width=12) (actual time=0.012..0.012 rows=5 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
84. 0.008 0.008 ↑ 1.0 5 1

Seq Scan on t58_opportunityforecastcategorypicklistdim (cost=0.00..1.05 rows=5 width=12) (actual time=0.007..0.008 rows=5 loops=1)

Planning time : 7.414 ms
Execution time : 7,716.933 ms