explain.depesz.com

PostgreSQL's explain analyze made readable

Result: H5di

Settings
# exclusive inclusive rows x rows loops node
1. 0.066 1,499.221 ↑ 32.2 163 1

Nested Loop (cost=394,005.97..5,122,369.69 rows=5,252 width=96) (actual time=250.993..1,499.221 rows=163 loops=1)

2.          

CTE multitimecte

3. 0.025 0.025 ↑ 1.0 13 1

Values Scan on "*VALUES*" (cost=0.00..0.16 rows=13 width=8) (actual time=0.003..0.025 rows=13 loops=1)

4.          

CTE picklist_0

5. 0.035 0.035 ↑ 1.0 2 1

Seq Scan on t77_opportunitystagenamepicklistdim (cost=0.00..4.44 rows=2 width=4) (actual time=0.012..0.035 rows=2 loops=1)

  • Filter: (correlated_value = ANY ('{"6 - Order Accepted","5 - Field Closed Won"}'::text[]))
  • Rows Removed by Filter: 113
6.          

CTE picklist_2

7. 0.023 0.023 ↑ 1.0 1 1

Seq Scan on t77_opportunitystagenamepicklistdim t77_opportunitystagenamepicklistdim_1 (cost=0.00..4.44 rows=1 width=4) (actual time=0.010..0.023 rows=1 loops=1)

  • Filter: (correlated_value = '7 - Closed (Not Won)'::text)
  • Rows Removed by Filter: 114
8.          

CTE picklist_3

9. 0.033 0.033 ↑ 1.0 3 1

Seq Scan on t77_opportunitystagenamepicklistdim t77_opportunitystagenamepicklistdim_2 (cost=0.00..4.58 rows=3 width=4) (actual time=0.007..0.033 rows=3 loops=1)

  • Filter: (correlated_value = ANY ('{"6 - Order Accepted","5 - Field Closed Won","7 - Closed (Not Won)"}'::text[]))
  • Rows Removed by Filter: 112
10. 0.034 0.034 ↑ 1.0 13 1

CTE Scan on multitimecte multitimecte_alias (cost=0.00..0.26 rows=13 width=8) (actual time=0.007..0.034 rows=13 loops=1)

11. 0.026 1,499.121 ↑ 31.1 13 13

Append (cost=393,992.35..394,019.29 rows=404 width=96) (actual time=110.723..115.317 rows=13 loops=13)

12.          

CTE openwont1

13. 78.833 985.283 ↓ 1.5 8,188 13

Hash Left Join (cost=34,522.72..342,690.38 rows=5,421 width=34) (actual time=11.147..75.791 rows=8,188 loops=13)

  • Hash Cond: (t65_oppfact_1.c917_opp_currency_code = t59_claricurrencytypedim_1.sid)
14. 38.940 851.760 ↓ 1.5 8,188 13

Nested Loop Left Join (cost=34,521.50..117,762.75 rows=5,421 width=56) (actual time=11.137..65.520 rows=8,188 loops=13)

15. 25.280 387.036 ↓ 1.5 8,188 13

Hash Left Join (cost=34,520.95..72,698.81 rows=5,421 width=28) (actual time=11.126..29.772 rows=8,188 loops=13)

  • Hash Cond: (t65_oppfact.c917_opp_currency_code = t59_claricurrencytypedim.sid)
16. 48.875 361.738 ↓ 1.5 8,188 13

Hash Join (cost=34,519.82..72,671.34 rows=5,421 width=24) (actual time=11.121..27.826 rows=8,188 loops=13)

  • Hash Cond: (t65_oppfact.c1008_opp_ownerid = t61_userrolehierarchy_2.sid)
17. 181.820 255.034 ↓ 1.5 8,188 13

Bitmap Heap Scan on t65_oppfact (cost=3,353.64..41,478.41 rows=5,421 width=28) (actual time=6.636..19.618 rows=8,188 loops=13)

  • Recheck Cond: ((c927_opp_close_date >= 20180701) AND (c927_opp_close_date <= 20180930) AND (start_stamp <= $9) AND (end_stamp > $9))
  • Filter: ((NOT deleted) AND (NOT (hashed SubPlan 9)))
  • Rows Removed by Filter: 4331
  • Heap Blocks: exact=85295
18. 73.190 73.190 ↓ 1.2 12,520 13

Bitmap Index Scan on ix_t65_oppfact_closedate_stagename_timestamp (cost=0.00..3,352.26 rows=10,842 width=0) (actual time=5.630..5.630 rows=12,520 loops=13)

  • Index Cond: ((c927_opp_close_date >= 20180701) AND (c927_opp_close_date <= 20180930) AND (start_stamp <= $9) AND (end_stamp > $9))
19.          

SubPlan (forBitmap Heap Scan)

20. 0.024 0.024 ↑ 1.0 1 1

CTE Scan on picklist_2 cte0_4 (cost=0.00..0.02 rows=1 width=4) (actual time=0.011..0.024 rows=1 loops=1)

21. 0.855 57.829 ↑ 1.1 6,046 1

Hash (cost=31,083.91..31,083.91 rows=6,582 width=4) (actual time=57.829..57.829 rows=6,046 loops=1)

  • Buckets: 8192 Batches: 1 Memory Usage: 277kB
22. 2.138 56.974 ↑ 1.1 6,046 1

HashAggregate (cost=31,018.09..31,083.91 rows=6,582 width=4) (actual time=56.221..56.974 rows=6,046 loops=1)

  • Group Key: t61_userrolehierarchy_2.sid
23. 12.621 54.836 ↑ 1.0 6,502 1

Hash Semi Join (cost=4,315.67..31,001.64 rows=6,582 width=4) (actual time=12.363..54.836 rows=6,502 loops=1)

  • Hash Cond: (t61_userrolehierarchy_2.c898_user_role_id = t42_userroledim_2.sid)
24. 31.553 41.637 ↑ 1.0 97,968 1

Bitmap Heap Scan on t61_userrolehierarchy t61_userrolehierarchy_2 (cost=3,138.89..29,419.97 rows=101,272 width=8) (actual time=11.777..41.637 rows=97,968 loops=1)

  • Recheck Cond: ((c899_ancestor_role_id = ANY ('{1172,22279}'::integer[])) AND (end_stamp = '32503680000000'::bigint))
  • Heap Blocks: exact=10585
25. 10.084 10.084 ↓ 1.1 109,831 1

Bitmap Index Scan on idx_t61_userrolehierarchy_c899_ancestor_role_id_end_sta34629852 (cost=0.00..3,113.58 rows=101,272 width=0) (actual time=10.084..10.084 rows=109,831 loops=1)

  • Index Cond: ((c899_ancestor_role_id = ANY ('{1172,22279}'::integer[])) AND (end_stamp = '32503680000000'::bigint))
26. 0.056 0.578 ↑ 1.3 451 1

Hash (cost=1,169.49..1,169.49 rows=583 width=4) (actual time=0.578..0.578 rows=451 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 24kB
27. 0.452 0.522 ↑ 1.3 451 1

Bitmap Heap Scan on t42_userroledim t42_userroledim_2 (cost=41.12..1,169.49 rows=583 width=4) (actual time=0.092..0.522 rows=451 loops=1)

  • Recheck Cond: ((end_stamp = '32503680000000'::bigint) AND ((c572_portaltype IS NULL) OR (c572_portaltype = 'None'::text)))
  • Filter: ((NOT deleted) AND (sid <> '-2'::integer))
  • Rows Removed by Filter: 127
  • Heap Blocks: exact=172
28. 0.070 0.070 ↑ 1.0 578 1

Bitmap Index Scan on ix_t42_userroledim_sid_timestamp_partial (cost=0.00..40.97 rows=585 width=0) (actual time=0.070..0.070 rows=578 loops=1)

  • Index Cond: (end_stamp = '32503680000000'::bigint)
29. 0.004 0.018 ↓ 3.0 3 1

Hash (cost=1.11..1.11 rows=1 width=12) (actual time=0.018..0.018 rows=3 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
30. 0.014 0.014 ↓ 3.0 3 1

Seq Scan on t59_claricurrencytypedim (cost=0.00..1.11 rows=1 width=12) (actual time=0.013..0.014 rows=3 loops=1)

  • Filter: (to_iso_code = 'USD'::text)
  • Rows Removed by Filter: 6
31. 425.784 425.784 ↑ 1.0 1 106,446

Index Scan using idx_t65_oppfact_sid_end_stamp_start_stamp on t65_oppfact t65_oppfact_1 (cost=0.56..8.30 rows=1 width=28) (actual time=0.004..0.004 rows=1 loops=106,446)

  • Index Cond: ((t65_oppfact.sid = sid) AND (t65_oppfact.sid = sid) AND (end_stamp > '1546243199999'::bigint) AND (start_stamp <= '1546243199999'::bigint))
  • Filter: (NOT deleted)
32. 0.004 0.010 ↓ 3.0 3 1

Hash (cost=1.11..1.11 rows=1 width=12) (actual time=0.010..0.010 rows=3 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
33. 0.006 0.006 ↓ 3.0 3 1

Seq Scan on t59_claricurrencytypedim t59_claricurrencytypedim_1 (cost=0.00..1.11 rows=1 width=12) (actual time=0.005..0.006 rows=3 loops=1)

  • Filter: (to_iso_code = 'USD'::text)
  • Rows Removed by Filter: 6
34.          

SubPlan (forHash Left Join)

35. 0.002 0.002 ↑ 1.0 2 1

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

36. 0.000 0.000 ↑ 1.0 2 1

CTE Scan on picklist_0 cte0_3 (cost=0.00..0.04 rows=2 width=4) (actual time=0.000..0.000 rows=2 loops=1)

37. 0.000 0.000 ↓ 0.0 0

Nested Loop Semi Join (cost=0.71..41.47 rows=1 width=0) (never executed)

38. 0.000 0.000 ↓ 0.0 0

Index Scan using idx_t61_userrolehierarchy_sid_c899_ancestor_role_id_end34629852 on t61_userrolehierarchy (cost=0.43..16.85 rows=2 width=4) (never executed)

  • Index Cond: ((sid = t65_oppfact_1.c1008_opp_ownerid) AND (c899_ancestor_role_id = ANY ('{1172,22279}'::integer[])) AND (end_stamp = '32503680000000'::bigint))
39. 0.000 0.000 ↓ 0.0 0

Index Scan using ix_t42_userroledim_sid_timestamp_partial on t42_userroledim (cost=0.28..8.30 rows=1 width=4) (never executed)

  • Index Cond: ((sid = t61_userrolehierarchy.c898_user_role_id) AND (end_stamp = '32503680000000'::bigint))
  • Filter: ((NOT deleted) AND (sid <> '-2'::integer))
40. 12.906 54.678 ↑ 1.0 6,502 1

Hash Semi Join (cost=4,315.67..31,001.64 rows=6,582 width=4) (actual time=12.299..54.678 rows=6,502 loops=1)

  • Hash Cond: (t61_userrolehierarchy_1.c898_user_role_id = t42_userroledim_1.sid)
41. 31.171 41.184 ↑ 1.0 97,968 1

Bitmap Heap Scan on t61_userrolehierarchy t61_userrolehierarchy_1 (cost=3,138.89..29,419.97 rows=101,272 width=8) (actual time=11.697..41.184 rows=97,968 loops=1)

  • Recheck Cond: ((c899_ancestor_role_id = ANY ('{1172,22279}'::integer[])) AND (end_stamp = '32503680000000'::bigint))
  • Heap Blocks: exact=10585
42. 10.013 10.013 ↓ 1.1 109,831 1

Bitmap Index Scan on idx_t61_userrolehierarchy_c899_ancestor_role_id_end_sta34629852 (cost=0.00..3,113.58 rows=101,272 width=0) (actual time=10.013..10.013 rows=109,831 loops=1)

  • Index Cond: ((c899_ancestor_role_id = ANY ('{1172,22279}'::integer[])) AND (end_stamp = '32503680000000'::bigint))
43. 0.064 0.588 ↑ 1.3 451 1

Hash (cost=1,169.49..1,169.49 rows=583 width=4) (actual time=0.588..0.588 rows=451 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 24kB
44. 0.445 0.524 ↑ 1.3 451 1

Bitmap Heap Scan on t42_userroledim t42_userroledim_1 (cost=41.12..1,169.49 rows=583 width=4) (actual time=0.103..0.524 rows=451 loops=1)

  • Recheck Cond: ((end_stamp = '32503680000000'::bigint) AND ((c572_portaltype IS NULL) OR (c572_portaltype = 'None'::text)))
  • Filter: ((NOT deleted) AND (sid <> '-2'::integer))
  • Rows Removed by Filter: 127
  • Heap Blocks: exact=172
45. 0.079 0.079 ↑ 1.0 578 1

Bitmap Index Scan on ix_t42_userroledim_sid_timestamp_partial (cost=0.00..40.97 rows=585 width=0) (actual time=0.079..0.079 rows=578 loops=1)

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

CTE openwont1ids

47. 54.223 1,081.483 ↓ 40.9 8,188 13

HashAggregate (cost=121.97..123.97 rows=200 width=4) (actual time=81.984..83.191 rows=8,188 loops=13)

  • Group Key: cte0_5.c1
48. 1,027.260 1,027.260 ↓ 1.5 8,188 13

CTE Scan on openwont1 cte0_5 (cost=0.00..108.42 rows=5,421 width=4) (actual time=11.150..79.020 rows=8,188 loops=13)

49.          

CTE bucketab

50. 35.087 55.055 ↑ 60.2 9 13

HashAggregate (cost=189.73..195.15 rows=542 width=68) (actual time=4.232..4.235 rows=9 loops=13)

  • Group Key: cte0_6.c5, CASE WHEN cte0_6.c6 THEN CASE WHEN cte0_6.c4 THEN 'convertedWon'::text ELSE 'convertedOpen'::text END ELSE CASE WHEN cte0_6.c4 THEN 'unconvertedWon'::text ELSE 'unconvertedOpen'::text END END, cte0_6.c3
51. 19.968 19.968 ↓ 1.5 8,188 13

CTE Scan on openwont1 cte0_6 (cost=0.00..108.42 rows=5,421 width=64) (actual time=0.002..1.536 rows=8,188 loops=13)

52.          

CTE bucketd

53. 3.445 1,443.676 ↑ 97.5 4 13

GroupAggregate (cost=34,796.16..50,982.84 rows=390 width=120) (actual time=110.716..111.052 rows=4 loops=13)

  • Group Key: ($9), (CASE WHEN (t65_oppfact_3.sid IS NULL) THEN 'trendNew'::text WHEN (NOT (hashed SubPlan 13)) THEN CASE WHEN (t65_oppfact_3.c927_opp_close_date > 20180930) THEN 'pulledIn'::text WHEN (t65_oppfact_3.c927_opp_close_date < 20180701) THEN 'pushedIn'::text WHEN (alternatives: SubPlan 14 or hashed SubPlan 15) THEN 'other'::text ELSE 'ownerChange'::text END ELSE 'other'::text END)
54. 5.473 1,440.231 ↓ 2.9 1,143 13

Sort (cost=34,796.09..34,797.07 rows=390 width=60) (actual time=110.705..110.787 rows=1,143 loops=13)

  • Sort Key: (CASE WHEN (t65_oppfact_3.sid IS NULL) THEN 'trendNew'::text WHEN (NOT (hashed SubPlan 13)) THEN CASE WHEN (t65_oppfact_3.c927_opp_close_date > 20180930) THEN 'pulledIn'::text WHEN (t65_oppfact_3.c927_opp_close_date < 20180701) THEN 'pushedIn'::text WHEN (alternatives: SubPlan 14 or hashed SubPlan 15) THEN 'other'::text ELSE 'ownerChange'::text END ELSE 'other'::text END)
  • Sort Method: quicksort Memory: 25kB
55. 10.020 1,434.758 ↓ 2.9 1,143 13

Nested Loop Left Join (cost=6.44..34,779.31 rows=390 width=60) (actual time=90.703..110.366 rows=1,143 loops=13)

56. 10.114 1,380.145 ↓ 2.9 1,143 13

Nested Loop Left Join (cost=5.81..15,386.54 rows=390 width=20) (actual time=90.689..106.165 rows=1,143 loops=13)

  • Join Filter: (t65_oppfact_2.c917_opp_currency_code = t59_claricurrencytypedim_2.sid)
  • Rows Removed by Join Filter: 2285
57. 2.682 1,370.031 ↓ 2.9 1,143 13

Nested Loop Semi Join (cost=5.81..15,379.58 rows=390 width=16) (actual time=90.684..105.387 rows=1,143 loops=13)

58. 4.797 1,293.084 ↓ 2.9 1,143 13

Nested Loop (cost=5.11..10,285.19 rows=390 width=20) (actual time=90.656..99.468 rows=1,143 loops=13)

59. 0.026 0.117 ↑ 1.0 2 13

Unique (cost=0.05..0.06 rows=2 width=4) (actual time=0.006..0.009 rows=2 loops=13)

60. 0.052 0.091 ↑ 1.0 2 13

Sort (cost=0.05..0.06 rows=2 width=4) (actual time=0.006..0.007 rows=2 loops=13)

  • Sort Key: cte0_9.c1
  • Sort Method: quicksort Memory: 25kB
61. 0.039 0.039 ↑ 1.0 2 13

CTE Scan on picklist_0 cte0_9 (cost=0.00..0.04 rows=2 width=4) (actual time=0.001..0.003 rows=2 loops=13)

62. 181.181 1,288.170 ↓ 2.9 571 26

Index Scan using ix_t65_oppfact_closedate_stagename_timestamp on t65_oppfact t65_oppfact_2 (cost=5.06..5,140.62 rows=195 width=24) (actual time=47.108..49.545 rows=571 loops=26)

  • Index Cond: ((c927_opp_close_date >= 20180701) AND (c927_opp_close_date <= 20180930) AND (c933_opp_stagename = cte0_9.c1) AND (start_stamp <= '1546243199999'::bigint) AND (end_stamp > '1546243199999'::bigint))
  • Filter: ((NOT deleted) AND (NOT (hashed SubPlan 16)))
  • Rows Removed by Filter: 1209
63.          

SubPlan (forIndex Scan)

64. 1,106.989 1,106.989 ↓ 40.9 8,188 13

CTE Scan on openwont1ids cte0_8 (cost=0.00..4.00 rows=200 width=4) (actual time=82.014..85.153 rows=8,188 loops=13)

65. 14.853 74.265 ↑ 1.0 1 14,853

Nested Loop Semi Join (cost=0.71..13.05 rows=1 width=4) (actual time=0.005..0.005 rows=1 loops=14,853)

66. 29.706 29.706 ↑ 2.0 1 14,853

Index Scan using idx_t61_userrolehierarchy_sid_c899_ancestor_role_id_end34629852 on t61_userrolehierarchy t61_userrolehierarchy_5 (cost=0.43..12.25 rows=2 width=8) (actual time=0.002..0.002 rows=1 loops=14,853)

  • Index Cond: ((sid = t65_oppfact_2.c1008_opp_ownerid) AND (c899_ancestor_role_id = ANY ('{1172,22279}'::integer[])) AND (end_stamp = '32503680000000'::bigint))
67. 29.706 29.706 ↑ 1.0 1 14,853

Index Scan using ix_t42_userroledim_sid_timestamp_partial on t42_userroledim t42_userroledim_5 (cost=0.28..0.36 rows=1 width=4) (actual time=0.002..0.002 rows=1 loops=14,853)

  • Index Cond: ((sid = t61_userrolehierarchy_5.c898_user_role_id) AND (end_stamp = '32503680000000'::bigint))
  • Filter: ((NOT deleted) AND (sid <> '-2'::integer))
68. 0.000 0.000 ↓ 3.0 3 14,853

Materialize (cost=0.00..1.12 rows=1 width=12) (actual time=0.000..0.000 rows=3 loops=14,853)

69. 0.012 0.012 ↓ 3.0 3 1

Seq Scan on t59_claricurrencytypedim t59_claricurrencytypedim_2 (cost=0.00..1.11 rows=1 width=12) (actual time=0.010..0.012 rows=3 loops=1)

  • Filter: (to_iso_code = 'USD'::text)
  • Rows Removed by Filter: 6
70. 44.559 44.559 ↓ 0.0 0 14,853

Index Scan using idx_t65_oppfact_sid_end_stamp_start_stamp on t65_oppfact t65_oppfact_3 (cost=0.56..8.24 rows=1 width=16) (actual time=0.003..0.003 rows=0 loops=14,853)

  • Index Cond: ((t65_oppfact_2.sid = sid) AND (t65_oppfact_2.sid = sid) AND (end_stamp > $9) AND (start_stamp <= $9))
  • Filter: (NOT deleted)
71.          

SubPlan (forNested Loop Left Join)

72. 0.034 0.034 ↑ 1.0 3 1

CTE Scan on picklist_3 cte0_7 (cost=0.00..0.06 rows=3 width=4) (actual time=0.008..0.034 rows=3 loops=1)

73. 0.000 0.000 ↓ 0.0 0

Nested Loop Semi Join (cost=0.71..41.47 rows=1 width=0) (never executed)

74. 0.000 0.000 ↓ 0.0 0

Index Scan using idx_t61_userrolehierarchy_sid_c899_ancestor_role_id_end34629852 on t61_userrolehierarchy t61_userrolehierarchy_3 (cost=0.43..16.85 rows=2 width=4) (never executed)

  • Index Cond: ((sid = t65_oppfact_3.c1008_opp_ownerid) AND (c899_ancestor_role_id = ANY ('{1172,22279}'::integer[])) AND (end_stamp = '32503680000000'::bigint))
75. 0.000 0.000 ↓ 0.0 0

Index Scan using ix_t42_userroledim_sid_timestamp_partial on t42_userroledim t42_userroledim_3 (cost=0.28..8.30 rows=1 width=4) (never executed)

  • Index Cond: ((sid = t61_userrolehierarchy_3.c898_user_role_id) AND (end_stamp = '32503680000000'::bigint))
  • Filter: ((NOT deleted) AND (sid <> '-2'::integer))
76. 0.000 0.000 ↓ 0.0 0

Hash Semi Join (cost=4,315.67..31,001.64 rows=6,582 width=4) (never executed)

  • Hash Cond: (t61_userrolehierarchy_4.c898_user_role_id = t42_userroledim_4.sid)
77. 0.000 0.000 ↓ 0.0 0

Bitmap Heap Scan on t61_userrolehierarchy t61_userrolehierarchy_4 (cost=3,138.89..29,419.97 rows=101,272 width=8) (never executed)

  • Recheck Cond: ((c899_ancestor_role_id = ANY ('{1172,22279}'::integer[])) AND (end_stamp = '32503680000000'::bigint))
78. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on idx_t61_userrolehierarchy_c899_ancestor_role_id_end_sta34629852 (cost=0.00..3,113.58 rows=101,272 width=0) (never executed)

  • Index Cond: ((c899_ancestor_role_id = ANY ('{1172,22279}'::integer[])) AND (end_stamp = '32503680000000'::bigint))
79. 0.000 0.000 ↓ 0.0 0

Hash (cost=1,169.49..1,169.49 rows=583 width=4) (never executed)

80. 0.000 0.000 ↓ 0.0 0

Bitmap Heap Scan on t42_userroledim t42_userroledim_4 (cost=41.12..1,169.49 rows=583 width=4) (never executed)

  • Recheck Cond: ((end_stamp = '32503680000000'::bigint) AND ((c572_portaltype IS NULL) OR (c572_portaltype = 'None'::text)))
  • Filter: ((NOT deleted) AND (sid <> '-2'::integer))
81. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on ix_t42_userroledim_sid_timestamp_partial (cost=0.00..40.97 rows=585 width=0) (never executed)

  • Index Cond: (end_stamp = '32503680000000'::bigint)
82. 0.078 1,443.806 ↑ 97.5 4 13

Subquery Scan on *SELECT* 1 (cost=0.00..12.67 rows=390 width=96) (actual time=110.722..111.062 rows=4 loops=13)

83. 1,443.728 1,443.728 ↑ 97.5 4 13

CTE Scan on bucketd cte0 (cost=0.00..7.80 rows=390 width=120) (actual time=110.718..111.056 rows=4 loops=13)

84. 0.080 55.289 ↑ 1.6 9 13

Hash Join (cost=1.11..14.13 rows=14 width=96) (actual time=4.244..4.253 rows=9 loops=13)

  • Hash Cond: (cte0_1.c6 = t75_opportunityforecastcategorypicklistdim.sid)
85. 55.198 55.198 ↑ 60.2 9 13

CTE Scan on bucketab cte0_1 (cost=0.00..10.84 rows=542 width=68) (actual time=4.239..4.246 rows=9 loops=13)

86. 0.006 0.011 ↑ 1.0 5 1

Hash (cost=1.05..1.05 rows=5 width=36) (actual time=0.011..0.011 rows=5 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
87. 0.005 0.005 ↑ 1.0 5 1

Seq Scan on t75_opportunityforecastcategorypicklistdim (cost=0.00..1.05 rows=5 width=36) (actual time=0.004..0.005 rows=5 loops=1)