explain.depesz.com

PostgreSQL's explain analyze made readable

Result: PvJ0

Settings
# exclusive inclusive rows x rows loops node
1. 0.009 162,809.747 ↑ 4,444.8 44 1

Append (cost=715,708,686.07..715,717,546.21 rows=195,571 width=120) (actual time=64,213.626..162,809.747 rows=44 loops=1)

  • Planning time: 6.066 ms
  • Execution time: 162846.877 ms
2.          

CTE picklist_0

3. 0.254 0.254 ↑ 1.0 6 1

Seq Scan on t233_opportunitystagenamepicklistdim (cost=0.00..46.54 rows=6 width=4) (actual time=0.006..0.254 rows=6 loops=1)

  • Filter: (correlated_value = ANY ('{"06 - Won, Deploy & Expand","6 - Won, Deploy & Expand","Closed - Won","06 - Won. Deploy & Expand",Won,"06 - Won, Deploy & Expand"}'::text[]))
  • Rows Removed by Filter: 1225
4.          

CTE picklist_1

5. 0.295 0.295 ↑ 1.0 7 1

Seq Scan on t233_opportunitystagenamepicklistdim t233_opportunitystagenamepicklistdim_1 (cost=0.00..48.08 rows=7 width=4) (actual time=0.009..0.295 rows=7 loops=1)

  • Filter: (correlated_value = ANY ('{"HPE Not Pursued",Lost,Close:Duplicate,"HP Not Pursued",Duplicate,Error,"Closed - Lost"}'::text[]))
  • Rows Removed by Filter: 1224
6.          

CTE picklist_4

7. 0.445 0.445 ↑ 1.0 13 1

Seq Scan on t233_opportunitystagenamepicklistdim t233_opportunitystagenamepicklistdim_2 (cost=0.00..57.31 rows=13 width=4) (actual time=0.018..0.445 rows=13 loops=1)

  • Filter: (correlated_value = ANY ('{"06 - Won, Deploy & Expand",Lost,"6 - Won, Deploy & Expand",Close:Duplicate,"HP Not Pursued","06 - Won, Deploy & Expand",Error,"HPE Not Pursued","Closed - Won","06 - Won. Deploy & Expand",Won,Duplicate,"Closed - Lost"}'::text[]))
  • Rows Removed by Filter: 1218
8.          

CTE ownercte

9. 8.408 667.993 ↑ 19.2 8,420 1

Hash Join (cost=93,554.35..260,133.24 rows=161,644 width=4) (actual time=351.613..667.993 rows=8,420 loops=1)

  • Hash Cond: (t166_userrolehierarchy.c662_user_role_id = t67_userroledim.sid)
10. 154.911 647.266 ↑ 4.7 34,130 1

Hash Join (cost=71,156.53..235,030.61 rows=161,644 width=8) (actual time=338.785..647.266 rows=34,130 loops=1)

  • Hash Cond: (t166_userrolehierarchy.sid = distinctclosedateowner.ownerid)
11. 225.060 357.217 ↓ 1.0 1,322,322 1

Bitmap Heap Scan on t166_userrolehierarchy (cost=37,314.65..194,764.43 rows=1,284,052 width=8) (actual time=139.486..357.217 rows=1,322,322 loops=1)

  • Recheck Cond: ((c663_ancestor_role_id = ANY ('{436,247157}'::integer[])) AND (end_stamp = '32503680000000'::bigint))
  • Heap Blocks: exact=39414
12. 132.157 132.157 ↓ 1.0 1,325,657 1

Bitmap Index Scan on ix_t166_userrolehierarchy_ancestor_end_start_timestamp (cost=0.00..36,993.64 rows=1,284,052 width=0) (actual time=132.157..132.157 rows=1,325,657 loops=1)

  • Index Cond: ((c663_ancestor_role_id = ANY ('{436,247157}'::integer[])) AND (end_stamp = '32503680000000'::bigint))
13. 4.993 135.138 ↓ 1.4 33,916 1

Hash (cost=33,534.31..33,534.31 rows=24,605 width=4) (actual time=135.138..135.138 rows=33,916 loops=1)

  • Buckets: 65536 (originally 32768) Batches: 1 (originally 1) Memory Usage: 1705kB
14. 40.859 130.145 ↓ 1.4 33,916 1

HashAggregate (cost=33,288.26..33,534.31 rows=24,605 width=4) (actual time=125.796..130.145 rows=33,916 loops=1)

  • Group Key: distinctclosedateowner.ownerid
15. 69.922 89.286 ↓ 1.2 196,760 1

Bitmap Heap Scan on distinctclosedateowner (cost=3,397.11..32,888.10 rows=160,066 width=4) (actual time=22.374..89.286 rows=196,760 loops=1)

  • Recheck Cond: ((closedate <= 20190131) AND (closedate >= 20181101))
  • Heap Blocks: exact=17913
16. 19.364 19.364 ↓ 1.2 196,760 1

Bitmap Index Scan on ix_closedate_distinctclosedateowner (cost=0.00..3,357.09 rows=160,066 width=0) (actual time=19.364..19.364 rows=196,760 loops=1)

  • Index Cond: ((closedate <= 20190131) AND (closedate >= 20181101))
17. 1.456 12.319 ↑ 9.3 8,370 1

Hash (cost=21,117.18..21,117.18 rows=78,051 width=4) (actual time=12.319..12.319 rows=8,370 loops=1)

  • Buckets: 131072 Batches: 2 Memory Usage: 1177kB
18. 6.269 10.863 ↑ 9.3 8,370 1

Bitmap Heap Scan on t67_userroledim (cost=4,261.99..21,117.18 rows=78,051 width=4) (actual time=5.038..10.863 rows=8,370 loops=1)

  • Recheck Cond: ((end_stamp = '32503680000000'::bigint) AND ((c377_portaltype IS NULL) OR (c377_portaltype = 'None'::text)))
  • Filter: ((NOT deleted) AND (sid <> '-2'::integer))
  • Rows Removed by Filter: 5639
  • Heap Blocks: exact=2150
19. 4.594 4.594 ↑ 5.6 14,039 1

Bitmap Index Scan on ix_t67_userroledim_sid_end_start_timestamp_partial (cost=0.00..4,242.48 rows=78,925 width=0) (actual time=4.594..4.594 rows=14,039 loops=1)

  • Index Cond: (end_stamp = '32503680000000'::bigint)
20.          

CTE bucketac

21. 36.832 64,289.446 ↑ 4,309.3 19 1

GroupAggregate (cost=149,304,420.79..298,199,406.52 rows=81,876 width=92) (actual time=64,213.597..64,289.446 rows=19 loops=1)

  • Group Key: t237_oppfact.c844_opp_forecastcategory, (CASE WHEN (t237_oppfact_1.sid IS NULL) THEN 'deleted'::text WHEN ((t237_oppfact_1.c836_opp_close_date < 20181101) OR (t237_oppfact_1.c836_opp_close_date > 20190131)) THEN 'slipped'::text WHEN (SubPlan 5) THEN CASE WHEN (hashed SubPlan 6) THEN 'won'::text WHEN (hashed SubPlan 7) THEN 'lost'::text ELSE CASE WHEN (t234_opportunityforecastcategorypicklistdim_2.correlated_app_order = t234_opportunityforecastcategorypicklistdim_3.correlated_app_order) THEN 'unchanged'::text WHEN (t234_opportunityforecastcategorypicklistdim_2.correlated_app_order > t234_opportunityforecastcategorypicklistdim_3.correlated_app_order) THEN 'upgraded'::text ELSE 'downgraded'::text END END ELSE 'lostOwnership'::text END)
22. 156.119 64,252.614 ↓ 1.4 110,684 1

Sort (cost=149,304,420.49..149,304,625.18 rows=81,876 width=72) (actual time=64,213.482..64,252.614 rows=110,684 loops=1)

  • Sort Key: t237_oppfact.c844_opp_forecastcategory, (CASE WHEN (t237_oppfact_1.sid IS NULL) THEN 'deleted'::text WHEN ((t237_oppfact_1.c836_opp_close_date < 20181101) OR (t237_oppfact_1.c836_opp_close_date > 20190131)) THEN 'slipped'::text WHEN (SubPlan 5) THEN CASE WHEN (hashed SubPlan 6) THEN 'won'::text WHEN (hashed SubPlan 7) THEN 'lost'::text ELSE CASE WHEN (t234_opportunityforecastcategorypicklistdim_2.correlated_app_order = t234_opportunityforecastcategorypicklistdim_3.correlated_app_order) THEN 'unchanged'::text WHEN (t234_opportunityforecastcategorypicklistdim_2.correlated_app_order > t234_opportunityforecastcategorypicklistdim_3.correlated_app_order) THEN 'upgraded'::text ELSE 'downgraded'::text END END ELSE 'lostOwnership'::text END)
  • Sort Method: external merge Disk: 7024kB
23. 31,776.067 64,096.495 ↓ 1.4 110,684 1

Hash Left Join (cost=7,919.43..149,294,378.94 rows=81,876 width=72) (actual time=721.527..64,096.495 rows=110,684 loops=1)

  • Hash Cond: ((t237_oppfact.c845_opp_currency_code = cur177_t0_r0.sid) AND (t237_oppfact.c836_opp_close_date = cur177_t0_r0.rate_date))
24. 9.694 2,054.900 ↓ 1.8 110,684 1

Nested Loop Left Join (cost=3,677.76..381,910.00 rows=60,175 width=64) (actual time=672.857..2,054.900 rows=110,684 loops=1)

25. 38.348 1,713.154 ↓ 2.5 110,684 1

Hash Left Join (cost=3,677.76..367,062.67 rows=44,226 width=60) (actual time=672.839..1,713.154 rows=110,684 loops=1)

  • Hash Cond: (t237_oppfact_1.c844_opp_forecastcategory = t234_opportunityforecastcategorypicklistdim_3.sid)
26. 79.196 1,674.802 ↓ 2.5 110,684 1

Nested Loop Left Join (cost=3,658.09..366,434.89 rows=44,226 width=60) (actual time=672.826..1,674.802 rows=110,684 loops=1)

27. 35.471 1,042.186 ↓ 2.5 110,684 1

Hash Left Join (cost=3,657.52..13,427.29 rows=44,226 width=28) (actual time=672.812..1,042.186 rows=110,684 loops=1)

  • Hash Cond: (t237_oppfact.c844_opp_forecastcategory = t234_opportunityforecastcategorypicklistdim_2.sid)
28. 27.857 1,006.706 ↓ 2.5 110,684 1

Nested Loop (cost=3,637.85..12,799.50 rows=44,226 width=24) (actual time=672.789..1,006.706 rows=110,684 loops=1)

29. 6.856 676.670 ↓ 40.8 8,167 1

HashAggregate (cost=3,636.99..3,638.99 rows=200 width=4) (actual time=672.277..676.670 rows=8,167 loops=1)

  • Group Key: ownercte_1.c1
30. 669.814 669.814 ↑ 19.2 8,420 1

CTE Scan on ownercte ownercte_1 (cost=0.00..3,232.88 rows=161,644 width=4) (actual time=351.616..669.814 rows=8,420 loops=1)

31. 301.732 302.179 ↓ 2.8 14 8,167

Index Scan using ix_t237_oppfact_owner_closedate_timestamp on t237_oppfact (cost=0.86..45.75 rows=5 width=28) (actual time=0.011..0.037 rows=14 loops=8,167)

  • Index Cond: ((c832_opp_ownerid = ownercte_1.c1) AND (c836_opp_close_date >= 20181101) AND (c836_opp_close_date <= 20190131) AND (start_stamp <= '1541055600000'::bigint) AND (end_stamp > '1541055600000'::bigint))
  • Filter: ((NOT deleted) AND (NOT (hashed SubPlan 8)))
  • Rows Removed by Filter: 3
32.          

SubPlan (forIndex Scan)

33. 0.447 0.447 ↑ 1.0 13 1

CTE Scan on picklist_4 cte0_4 (cost=0.00..0.26 rows=13 width=4) (actual time=0.018..0.447 rows=13 loops=1)

34. 0.005 0.009 ↑ 86.0 5 1

Hash (cost=14.30..14.30 rows=430 width=8) (actual time=0.009..0.009 rows=5 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
35. 0.004 0.004 ↑ 86.0 5 1

Seq Scan on t234_opportunityforecastcategorypicklistdim t234_opportunityforecastcategorypicklistdim_2 (cost=0.00..14.30 rows=430 width=8) (actual time=0.003..0.004 rows=5 loops=1)

36. 553.420 553.420 ↑ 1.0 1 110,684

Index Scan using ix_t237_oppfact_sid_timestamp on t237_oppfact t237_oppfact_1 (cost=0.56..7.97 rows=1 width=32) (actual time=0.005..0.005 rows=1 loops=110,684)

  • Index Cond: ((t237_oppfact.sid = sid) AND (t237_oppfact.sid = sid) AND (start_stamp <= '1542009599999'::bigint) AND (end_stamp > '1542009599999'::bigint))
  • Filter: (NOT deleted)
37. 0.002 0.004 ↑ 86.0 5 1

Hash (cost=14.30..14.30 rows=430 width=8) (actual time=0.004..0.004 rows=5 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
38. 0.002 0.002 ↑ 86.0 5 1

Seq Scan on t234_opportunityforecastcategorypicklistdim t234_opportunityforecastcategorypicklistdim_3 (cost=0.00..14.30 rows=430 width=8) (actual time=0.001..0.002 rows=5 loops=1)

39. 110.684 332.052 ↑ 2.0 1 110,684

Append (cost=0.00..0.32 rows=2 width=16) (actual time=0.002..0.003 rows=1 loops=110,684)

40. 0.000 0.000 ↓ 0.0 0 110,684

Seq Scan on clari_conversion_rate cur177_t1_r1 (cost=0.00..0.00 rows=1 width=16) (actual time=0.000..0.000 rows=0 loops=110,684)

  • Filter: ((to_iso_code = 'USD'::text) AND (t237_oppfact_1.c845_opp_currency_code = sid) AND (t237_oppfact_1.c836_opp_close_date = rate_date))
41. 221.368 221.368 ↑ 1.0 1 110,684

Index Scan using ix_usd_clari_conversion_rate_date_isocode on usd_clari_conversion_rate cur177_t1_r1_1 (cost=0.29..0.32 rows=1 width=16) (actual time=0.002..0.002 rows=1 loops=110,684)

  • Index Cond: ((t237_oppfact_1.c836_opp_close_date = rate_date) AND (t237_oppfact_1.c845_opp_currency_code = sid))
  • Filter: (to_iso_code = 'USD'::text)
42. 18.770 46.973 ↑ 1.0 101,598 1

Hash (cost=2,220.16..2,220.16 rows=101,614 width=16) (actual time=46.973..46.973 rows=101,598 loops=1)

  • Buckets: 131072 Batches: 2 Memory Usage: 3409kB
43. 6.071 28.203 ↑ 1.0 101,598 1

Append (cost=0.00..2,220.16 rows=101,614 width=16) (actual time=0.149..28.203 rows=101,598 loops=1)

44. 0.000 0.000 ↓ 0.0 0 1

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

  • Filter: (to_iso_code = 'USD'::text)
45. 22.132 22.132 ↑ 1.0 101,598 1

Seq Scan on usd_clari_conversion_rate cur177_t0_r0_1 (cost=0.00..2,220.16 rows=101,613 width=16) (actual time=0.148..22.132 rows=101,598 loops=1)

  • Filter: (to_iso_code = 'USD'::text)
46.          

SubPlan (forHash Left Join)

47. 30,218.000 30,218.000 ↑ 38.0 4,256 104,200

CTE Scan on ownercte (cost=0.00..3,232.88 rows=161,644 width=4) (actual time=0.000..0.290 rows=4,256 loops=104,200)

48. 0.257 0.257 ↑ 1.0 6 1

CTE Scan on picklist_0 cte0_2 (cost=0.00..0.12 rows=6 width=4) (actual time=0.007..0.257 rows=6 loops=1)

49. 0.298 0.298 ↑ 1.0 7 1

CTE Scan on picklist_1 cte0_3 (cost=0.00..0.14 rows=7 width=4) (actual time=0.011..0.298 rows=7 loops=1)

50.          

CTE bucketec

51. 3.680 98,520.172 ↑ 4,547.8 25 1

GroupAggregate (cost=210,490,353.64..417,248,974.70 rows=113,695 width=116) (actual time=98,515.471..98,520.172 rows=25 loops=1)

  • Group Key: (CASE WHEN (t237_oppfact_3.sid IS NULL) THEN 'newBucket'::text WHEN (NOT (hashed SubPlan 10)) THEN CASE WHEN (t237_oppfact_3.c836_opp_close_date > 20190131) THEN 'pulledInBucket'::text WHEN (t237_oppfact_3.c836_opp_close_date < 20181101) THEN 'pushedInBucket'::text WHEN (SubPlan 11) THEN 'otherBucket'::text ELSE 'gainedOwnershipBucket'::text END ELSE 'otherBucket'::text END), (CASE WHEN (hashed SubPlan 12) THEN 'won'::text WHEN (hashed SubPlan 13) THEN 'lost'::text ELSE 'newOpen'::text END), t237_oppfact_2.c844_opp_forecastcategory
52. 8.097 98,516.492 ↑ 8.2 13,920 1

Sort (cost=210,490,353.06..210,490,637.29 rows=113,695 width=88) (actual time=98,515.447..98,516.492 rows=13,920 loops=1)

  • Sort Key: (CASE WHEN (t237_oppfact_3.sid IS NULL) THEN 'newBucket'::text WHEN (NOT (hashed SubPlan 10)) THEN CASE WHEN (t237_oppfact_3.c836_opp_close_date > 20190131) THEN 'pulledInBucket'::text WHEN (t237_oppfact_3.c836_opp_close_date < 20181101) THEN 'pushedInBucket'::text WHEN (SubPlan 11) THEN 'otherBucket'::text ELSE 'gainedOwnershipBucket'::text END ELSE 'otherBucket'::text END), (CASE WHEN (hashed SubPlan 12) THEN 'won'::text WHEN (hashed SubPlan 13) THEN 'lost'::text ELSE 'newOpen'::text END), t237_oppfact_2.c844_opp_forecastcategory
  • Sort Method: quicksort Memory: 1481kB
53. 40,635.742 98,508.395 ↑ 8.2 13,920 1

Merge Right Join (cost=3,660,333.02..210,475,363.13 rows=113,695 width=88) (actual time=18,104.885..98,508.395 rows=13,920 loops=1)

  • Merge Cond: ((t237_oppfact_3.sid = t237_oppfact_2.sid) AND (t237_oppfact_3.sid = t237_oppfact_2.sid))
  • Filter: ((t237_oppfact_3.sid IS NULL) OR (t237_oppfact_3.c836_opp_close_date < 20181101) OR (t237_oppfact_3.c836_opp_close_date > 20190131) OR (NOT (SubPlan 14)))
  • Rows Removed by Filter: 130814
54. 6,039.928 19,103.780 ↑ 1.1 6,968,783 1

Sort (cost=3,614,816.38..3,633,664.89 rows=7,539,406 width=16) (actual time=17,584.800..19,103.780 rows=6,968,783 loops=1)

  • Sort Key: t237_oppfact_3.sid
  • Sort Method: external merge Disk: 177096kB
55. 13,063.852 13,063.852 ↑ 1.1 6,968,783 1

Seq Scan on t237_oppfact t237_oppfact_3 (cost=0.00..2,495,891.30 rows=7,539,406 width=16) (actual time=0.168..13,063.852 rows=6,968,783 loops=1)

  • Filter: ((NOT deleted) AND (start_stamp <= '1541055600000'::bigint) AND (end_stamp > '1541055600000'::bigint))
  • Rows Removed by Filter: 52866339
56. 19.729 575.429 ↓ 1.2 144,734 1

Materialize (cost=45,516.05..46,101.85 rows=117,160 width=28) (actual time=518.476..575.429 rows=144,734 loops=1)

57. 105.027 555.700 ↓ 1.2 144,734 1

Sort (cost=45,516.05..45,808.95 rows=117,160 width=28) (actual time=518.473..555.700 rows=144,734 loops=1)

  • Sort Key: t237_oppfact_2.sid
  • Sort Method: external merge Disk: 5936kB
58. 29.581 450.673 ↓ 1.2 144,734 1

Merge Right Join (cost=21,914.53..32,848.78 rows=117,160 width=28) (actual time=381.955..450.673 rows=144,734 loops=1)

  • Merge Cond: ((cur177_t0_r0_2.rate_date = t237_oppfact_2.c836_opp_close_date) AND (cur177_t0_r0_2.sid = t237_oppfact_2.c845_opp_currency_code))
59. 4.683 44.595 ↑ 1.4 71,863 1

Merge Append (cost=0.31..8,292.46 rows=101,614 width=16) (actual time=0.037..44.595 rows=71,863 loops=1)

  • Sort Key: cur177_t0_r0_2.rate_date, cur177_t0_r0_2.sid
60. 0.007 0.010 ↓ 0.0 0 1

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

  • Sort Key: cur177_t0_r0_2.rate_date, cur177_t0_r0_2.sid
  • Sort Method: quicksort Memory: 25kB
61. 0.003 0.003 ↓ 0.0 0 1

Seq Scan on clari_conversion_rate cur177_t0_r0_2 (cost=0.00..0.00 rows=1 width=16) (actual time=0.003..0.003 rows=0 loops=1)

  • Filter: (to_iso_code = 'USD'::text)
62. 39.902 39.902 ↑ 1.4 71,863 1

Index Scan using ix_usd_clari_conversion_rate_date_isocode on usd_clari_conversion_rate cur177_t0_r0_3 (cost=0.29..7,022.26 rows=101,613 width=16) (actual time=0.026..39.902 rows=71,863 loops=1)

  • Filter: (to_iso_code = 'USD'::text)
63. 13.220 376.497 ↓ 1.7 144,734 1

Materialize (cost=21,865.72..22,296.26 rows=86,108 width=28) (actual time=334.878..376.497 rows=144,734 loops=1)

64. 107.190 363.277 ↓ 1.7 144,734 1

Sort (cost=21,865.72..22,080.99 rows=86,108 width=28) (actual time=334.874..363.277 rows=144,734 loops=1)

  • Sort Key: t237_oppfact_2.c836_opp_close_date, t237_oppfact_2.c845_opp_currency_code
  • Sort Method: external merge Disk: 5928kB
65. 30.582 256.087 ↓ 1.7 144,734 1

Nested Loop (cost=3,637.56..12,746.00 rows=86,108 width=28) (actual time=2.628..256.087 rows=144,734 loops=1)

66. 4.317 4.996 ↓ 40.8 8,167 1

HashAggregate (cost=3,636.99..3,638.99 rows=200 width=4) (actual time=2.600..4.996 rows=8,167 loops=1)

  • Group Key: ownercte_4.c1
67. 0.679 0.679 ↑ 19.2 8,420 1

CTE Scan on ownercte ownercte_4 (cost=0.00..3,232.88 rows=161,644 width=4) (actual time=0.001..0.679 rows=8,420 loops=1)

68. 220.509 220.509 ↓ 1.8 18 8,167

Index Scan using ix_t237_oppfact_owner_closedate_timestamp on t237_oppfact t237_oppfact_2 (cost=0.56..45.44 rows=10 width=32) (actual time=0.008..0.027 rows=18 loops=8,167)

  • Index Cond: ((c832_opp_ownerid = ownercte_4.c1) AND (c836_opp_close_date >= 20181101) AND (c836_opp_close_date <= 20190131) AND (start_stamp <= '1542009599999'::bigint) AND (end_stamp > '1542009599999'::bigint))
  • Filter: (NOT deleted)
  • Rows Removed by Filter: 0
69.          

SubPlan (forMerge Right Join)

70. 0.003 0.003 ↑ 1.0 13 1

CTE Scan on picklist_4 cte0_5 (cost=0.00..0.26 rows=13 width=4) (actual time=0.001..0.003 rows=13 loops=1)

71. 83.496 83.496 ↑ 19.2 8,420 147

CTE Scan on ownercte ownercte_2 (cost=0.00..3,232.88 rows=161,644 width=4) (actual time=0.000..0.568 rows=8,420 loops=147)

72. 0.001 0.001 ↑ 1.0 6 1

CTE Scan on picklist_0 cte0_6 (cost=0.00..0.12 rows=6 width=4) (actual time=0.001..0.001 rows=6 loops=1)

73. 0.002 0.002 ↑ 1.0 7 1

CTE Scan on picklist_1 cte0_7 (cost=0.00..0.14 rows=7 width=4) (actual time=0.001..0.002 rows=7 loops=1)

74. 38,109.942 38,109.942 ↑ 37.9 4,268 130,962

CTE Scan on ownercte ownercte_3 (cost=0.00..3,232.88 rows=161,644 width=4) (actual time=0.000..0.291 rows=4,268 loops=130,962)

75. 0.016 64,289.493 ↑ 4,309.3 19 1

Hash Join (cost=19.68..2,782.99 rows=81,876 width=120) (actual time=64,213.625..64,289.493 rows=19 loops=1)

  • Hash Cond: (cte0.c4 = t234_opportunityforecastcategorypicklistdim.sid)
76. 64,289.462 64,289.462 ↑ 4,309.3 19 1

CTE Scan on bucketac cte0 (cost=0.00..1,637.52 rows=81,876 width=92) (actual time=64,213.600..64,289.462 rows=19 loops=1)

77. 0.004 0.015 ↑ 86.0 5 1

Hash (cost=14.30..14.30 rows=430 width=36) (actual time=0.015..0.015 rows=5 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
78. 0.011 0.011 ↑ 86.0 5 1

Seq Scan on t234_opportunityforecastcategorypicklistdim (cost=0.00..14.30 rows=430 width=36) (actual time=0.008..0.011 rows=5 loops=1)

79. 0.021 98,520.245 ↑ 4,547.8 25 1

Subquery Scan on *SELECT* 2 (cost=19.68..5,278.07 rows=113,695 width=120) (actual time=98,515.520..98,520.245 rows=25 loops=1)

80. 0.021 98,520.224 ↑ 4,547.8 25 1

Hash Join (cost=19.68..3,856.88 rows=113,695 width=144) (actual time=98,515.509..98,520.224 rows=25 loops=1)

  • Hash Cond: (cte0_1.c6 = t234_opportunityforecastcategorypicklistdim_1.sid)
81. 98,520.184 98,520.184 ↑ 4,547.8 25 1

CTE Scan on bucketec cte0_1 (cost=0.00..2,273.90 rows=113,695 width=116) (actual time=98,515.475..98,520.184 rows=25 loops=1)

82. 0.005 0.019 ↑ 86.0 5 1

Hash (cost=14.30..14.30 rows=430 width=36) (actual time=0.019..0.019 rows=5 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
83. 0.014 0.014 ↑ 86.0 5 1

Seq Scan on t234_opportunityforecastcategorypicklistdim t234_opportunityforecastcategorypicklistdim_1 (cost=0.00..14.30 rows=430 width=36) (actual time=0.011..0.014 rows=5 loops=1)