explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Asuw

Settings
# exclusive inclusive rows x rows loops node
1. 0.017 626.546 ↑ 1,139.6 12 1

Append (cost=1,485,216.32..1,485,683.90 rows=13,675 width=96) (actual time=624.932..626.546 rows=12 loops=1)

2.          

CTE picklist_0

3. 0.318 0.318 ↑ 1.0 6 1

Seq Scan on t233_opportunitystagenamepicklistdim (cost=0.00..46.54 rows=6 width=4) (actual time=0.009..0.318 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_2

5. 0.325 0.325 ↑ 1.0 7 1

Seq Scan on t233_opportunitystagenamepicklistdim t233_opportunitystagenamepicklistdim_1 (cost=0.00..48.08 rows=7 width=4) (actual time=0.012..0.325 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 openwont1

7. 2.704 202.206 ↑ 1.6 1,963 1

Nested Loop Left Join (cost=17,887.83..224,048.55 rows=3,085 width=34) (actual time=2.887..202.206 rows=1,963 loops=1)

8. 1.286 193.667 ↑ 1.3 1,963 1

Nested Loop Left Join (cost=17,887.56..170,582.03 rows=2,585 width=56) (actual time=2.837..193.667 rows=1,963 loops=1)

9. 1.848 188.455 ↑ 1.1 1,963 1

Nested Loop Left Join (cost=17,887.56..169,051.38 rows=2,166 width=56) (actual time=2.820..188.455 rows=1,963 loops=1)

10. 12.007 178.755 ↑ 1.1 1,963 1

Hash Join (cost=17,887.00..150,769.85 rows=2,166 width=28) (actual time=2.806..178.755 rows=1,963 loops=1)

  • Hash Cond: (t236_opp_line_item_fact.c804_opp_ownerid = t166_userrolehierarchy_2.sid)
11. 164.013 164.342 ↓ 11.0 154,924 1

Index Scan using ix_t236_opp_line_item_fact_closedate_timestamp on t236_opp_line_item_fact (cost=0.72..132,829.38 rows=14,120 width=32) (actual time=0.363..164.342 rows=154,924 loops=1)

  • Index Cond: ((c805_opp_close_date >= 20180201) AND (c805_opp_close_date <= 20180430) AND (start_stamp <= '1520668799999'::bigint) AND (end_stamp > '1520668799999'::bigint))
  • Filter: ((NOT deleted) AND (NOT (hashed SubPlan 7)))
  • Rows Removed by Filter: 1085
12.          

SubPlan (forIndex Scan)

13. 0.329 0.329 ↑ 1.0 7 1

CTE Scan on picklist_2 cte0_4 (cost=0.00..0.14 rows=7 width=4) (actual time=0.013..0.329 rows=7 loops=1)

14. 0.093 2.406 ↑ 2.5 737 1

Hash (cost=17,863.14..17,863.14 rows=1,851 width=4) (actual time=2.406..2.406 rows=737 loops=1)

  • Buckets: 2048 Batches: 1 Memory Usage: 42kB
15. 0.295 2.313 ↑ 2.5 737 1

HashAggregate (cost=17,844.63..17,863.14 rows=1,851 width=4) (actual time=2.231..2.313 rows=737 loops=1)

  • Group Key: t166_userrolehierarchy_2.sid
16. 0.682 2.018 ↑ 2.0 934 1

Nested Loop Semi Join (cost=60.05..17,839.98 rows=1,860 width=4) (actual time=0.127..2.018 rows=934 loops=1)

17. 0.307 0.402 ↑ 2.0 934 1

Bitmap Heap Scan on t166_userrolehierarchy t166_userrolehierarchy_2 (cost=59.63..6,838.33 rows=1,860 width=8) (actual time=0.110..0.402 rows=934 loops=1)

  • Recheck Cond: ((c663_ancestor_role_id = 237423) AND (end_stamp = '32503680000000'::bigint))
  • Heap Blocks: exact=130
18. 0.095 0.095 ↑ 2.0 944 1

Bitmap Index Scan on ix_t166_userrolehierarchy_ancestor_end_start_timestamp (cost=0.00..59.16 rows=1,860 width=0) (actual time=0.095..0.095 rows=944 loops=1)

  • Index Cond: ((c663_ancestor_role_id = 237423) AND (end_stamp = '32503680000000'::bigint))
19. 0.934 0.934 ↑ 1.0 1 934

Index Scan using ix_t67_userroledim_sid_timestamp_partial on t67_userroledim t67_userroledim_2 (cost=0.42..5.90 rows=1 width=4) (actual time=0.001..0.001 rows=1 loops=934)

  • Index Cond: ((sid = t166_userrolehierarchy_2.c662_user_role_id) AND (end_stamp = '32503680000000'::bigint))
  • Filter: ((NOT deleted) AND (sid <> '-2'::integer))
20. 7.852 7.852 ↑ 1.0 1 1,963

Index Scan using ix_t236_opp_line_item_fact_sid_timestamp on t236_opp_line_item_fact t236_opp_line_item_fact_1 (cost=0.56..8.43 rows=1 width=28) (actual time=0.004..0.004 rows=1 loops=1,963)

  • Index Cond: ((t236_opp_line_item_fact.sid = sid) AND (t236_opp_line_item_fact.sid = sid) AND (start_stamp <= '1540796399999'::bigint) AND (end_stamp > '1540796399999'::bigint))
  • Filter: (NOT deleted)
21. 0.000 3.926 ↑ 2.0 1 1,963

Append (cost=0.00..0.69 rows=2 width=16) (actual time=0.002..0.002 rows=1 loops=1,963)

22. 0.000 0.000 ↓ 0.0 0 1,963

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,963)

  • Filter: ((to_iso_code = 'USD'::text) AND (t236_opp_line_item_fact.c821_opp_currency_code = sid) AND (t236_opp_line_item_fact.c805_opp_close_date = rate_date))
23. 3.926 3.926 ↑ 1.0 1 1,963

Index Scan using ix_usd_clari_conversion_rate_date_isocode on usd_clari_conversion_rate cur177_t0_r0_1 (cost=0.29..0.69 rows=1 width=16) (actual time=0.002..0.002 rows=1 loops=1,963)

  • Index Cond: ((t236_opp_line_item_fact.c805_opp_close_date = rate_date) AND (t236_opp_line_item_fact.c821_opp_currency_code = sid))
  • Filter: (to_iso_code = 'USD'::text)
24. 0.000 3.926 ↑ 2.0 1 1,963

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

25. 0.000 0.000 ↓ 0.0 0 1,963

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=1,963)

  • Filter: ((to_iso_code = 'USD'::text) AND (t236_opp_line_item_fact_1.c821_opp_currency_code = sid) AND (t236_opp_line_item_fact_1.c805_opp_close_date = rate_date))
26. 3.926 3.926 ↑ 1.0 1 1,963

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=1,963)

  • Index Cond: ((t236_opp_line_item_fact_1.c805_opp_close_date = rate_date) AND (t236_opp_line_item_fact_1.c821_opp_currency_code = sid))
  • Filter: (to_iso_code = 'USD'::text)
27.          

SubPlan (forNested Loop Left Join)

28. 0.000 0.000 ↑ 1.0 6 1

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

29. 0.000 0.000 ↑ 1.0 6 1

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

30. 0.000 0.000 ↓ 0.0 0

Nested Loop Semi Join (cost=0.98..17.04 rows=1 width=0) (never executed)

31. 0.000 0.000 ↓ 0.0 0

Index Scan using ix_t166_userrolehierarchy_sid_ancestor_end_start_timestamp on t166_userrolehierarchy (cost=0.56..8.58 rows=1 width=4) (never executed)

  • Index Cond: ((sid = t236_opp_line_item_fact_1.c804_opp_ownerid) AND (c663_ancestor_role_id = 237423) AND (end_stamp = '32503680000000'::bigint))
32. 0.000 0.000 ↓ 0.0 0

Index Scan using ix_t67_userroledim_sid_end_start_timestamp_partial on t67_userroledim (cost=0.42..8.44 rows=1 width=4) (never executed)

  • Index Cond: ((sid = t166_userrolehierarchy.c662_user_role_id) AND (end_stamp = '32503680000000'::bigint))
  • Filter: ((NOT deleted) AND (sid <> '-2'::integer))
33. 0.684 1.909 ↑ 2.0 934 1

Nested Loop Semi Join (cost=60.05..17,839.98 rows=1,860 width=4) (actual time=0.101..1.909 rows=934 loops=1)

34. 0.214 0.291 ↑ 2.0 934 1

Bitmap Heap Scan on t166_userrolehierarchy t166_userrolehierarchy_1 (cost=59.63..6,838.33 rows=1,860 width=8) (actual time=0.092..0.291 rows=934 loops=1)

  • Recheck Cond: ((c663_ancestor_role_id = 237423) AND (end_stamp = '32503680000000'::bigint))
  • Heap Blocks: exact=130
35. 0.077 0.077 ↑ 2.0 944 1

Bitmap Index Scan on ix_t166_userrolehierarchy_ancestor_end_start_timestamp (cost=0.00..59.16 rows=1,860 width=0) (actual time=0.077..0.077 rows=944 loops=1)

  • Index Cond: ((c663_ancestor_role_id = 237423) AND (end_stamp = '32503680000000'::bigint))
36. 0.934 0.934 ↑ 1.0 1 934

Index Scan using ix_t67_userroledim_sid_timestamp_partial on t67_userroledim t67_userroledim_1 (cost=0.42..5.90 rows=1 width=4) (actual time=0.001..0.001 rows=1 loops=934)

  • Index Cond: ((sid = t166_userrolehierarchy_1.c662_user_role_id) AND (end_stamp = '32503680000000'::bigint))
  • Filter: ((NOT deleted) AND (sid <> '-2'::integer))
37.          

CTE openwont1ids

38. 1.057 204.266 ↓ 9.8 1,963 1

HashAggregate (cost=69.41..71.41 rows=200 width=4) (actual time=204.006..204.266 rows=1,963 loops=1)

  • Group Key: cte0_5.c1
39. 203.209 203.209 ↑ 1.6 1,963 1

CTE Scan on openwont1 cte0_5 (cost=0.00..61.70 rows=3,085 width=4) (actual time=2.889..203.209 rows=1,963 loops=1)

40.          

CTE bucketab

41. 0.654 0.988 ↑ 38.5 8 1

HashAggregate (cost=107.98..111.06 rows=308 width=68) (actual time=0.985..0.988 rows=8 loops=1)

  • 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
42. 0.334 0.334 ↑ 1.6 1,963 1

CTE Scan on openwont1 cte0_6 (cost=0.00..61.70 rows=3,085 width=64) (actual time=0.002..0.334 rows=1,963 loops=1)

43.          

CTE picklist_3

44. 0.410 0.410 ↑ 1.0 13 1

Seq Scan on t233_opportunitystagenamepicklistdim t233_opportunitystagenamepicklistdim_2 (cost=0.00..57.31 rows=13 width=4) (actual time=0.008..0.410 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
45.          

CTE bucketd

46. 0.454 625.494 ↑ 3,341.8 4 1

GroupAggregate (cost=1,032,692.10..1,260,833.37 rows=13,367 width=120) (actual time=624.905..625.494 rows=4 loops=1)

  • Group Key: '1520668799999'::bigint, (CASE WHEN (t236_opp_line_item_fact_3.sid IS NULL) THEN 'trendNew'::text WHEN (NOT (hashed SubPlan 12)) THEN CASE WHEN (t236_opp_line_item_fact_3.c805_opp_close_date > 20180430) THEN 'pulledIn'::text WHEN (t236_opp_line_item_fact_3.c805_opp_close_date < 20180201) THEN 'pushedIn'::text WHEN (alternatives: SubPlan 13 or hashed SubPlan 14) THEN 'other'::text ELSE 'ownerChange'::text END ELSE 'other'::text END)
47. 0.819 625.040 ↑ 6.4 2,080 1

Sort (cost=1,032,691.81..1,032,725.22 rows=13,367 width=60) (actual time=624.889..625.040 rows=2,080 loops=1)

  • Sort Key: (CASE WHEN (t236_opp_line_item_fact_3.sid IS NULL) THEN 'trendNew'::text WHEN (NOT (hashed SubPlan 12)) THEN CASE WHEN (t236_opp_line_item_fact_3.c805_opp_close_date > 20180430) THEN 'pulledIn'::text WHEN (t236_opp_line_item_fact_3.c805_opp_close_date < 20180201) THEN 'pushedIn'::text WHEN (alternatives: SubPlan 13 or hashed SubPlan 14) THEN 'other'::text ELSE 'ownerChange'::text END ELSE 'other'::text END)
  • Sort Method: quicksort Memory: 259kB
48. 1.272 624.221 ↑ 6.4 2,080 1

Nested Loop Left Join (cost=17,892.33..1,031,775.74 rows=13,367 width=60) (actual time=443.512..624.221 rows=2,080 loops=1)

49. 0.000 616.500 ↑ 5.4 2,080 1

Nested Loop Left Join (cost=17,892.04..799,908.52 rows=11,202 width=36) (actual time=443.499..616.500 rows=2,080 loops=1)

50. 10.454 610.464 ↑ 5.4 2,080 1

Hash Join (cost=17,891.47..721,545.23 rows=11,202 width=20) (actual time=443.491..610.464 rows=2,080 loops=1)

  • Hash Cond: (t236_opp_line_item_fact_2.c804_opp_ownerid = t166_userrolehierarchy_5.sid)
51. 26.471 597.546 ↓ 1.8 130,155 1

Nested Loop (cost=5.20..703,378.63 rows=73,025 width=24) (actual time=440.829..597.546 rows=130,155 loops=1)

52. 0.010 0.331 ↑ 1.0 6 1

HashAggregate (cost=0.14..0.20 rows=6 width=4) (actual time=0.324..0.331 rows=6 loops=1)

  • Group Key: cte0_9.c1
53. 0.321 0.321 ↑ 1.0 6 1

CTE Scan on picklist_0 cte0_9 (cost=0.00..0.12 rows=6 width=4) (actual time=0.010..0.321 rows=6 loops=1)

54. 366.057 570.744 ↓ 1.8 21,692 6

Index Scan using ix_t236_opp_line_item_fact_closedate_stage_timestamp on t236_opp_line_item_fact t236_opp_line_item_fact_2 (cost=5.06..117,108.03 rows=12,171 width=28) (actual time=73.414..95.124 rows=21,692 loops=6)

  • Index Cond: ((c805_opp_close_date >= 20180201) AND (c805_opp_close_date <= 20180430) AND (c819_opp_stagename = cte0_9.c1) AND (start_stamp <= '1540796399999'::bigint) AND (end_stamp > '1540796399999'::bigint))
  • Filter: ((NOT deleted) AND (NOT (hashed SubPlan 15)))
  • Rows Removed by Filter: 28
55.          

SubPlan (forIndex Scan)

56. 204.687 204.687 ↓ 9.8 1,963 1

CTE Scan on openwont1ids cte0_8 (cost=0.00..4.00 rows=200 width=4) (actual time=204.007..204.687 rows=1,963 loops=1)

57. 0.114 2.464 ↑ 2.5 737 1

Hash (cost=17,863.14..17,863.14 rows=1,851 width=4) (actual time=2.464..2.464 rows=737 loops=1)

  • Buckets: 2048 Batches: 1 Memory Usage: 42kB
58. 0.298 2.350 ↑ 2.5 737 1

HashAggregate (cost=17,844.63..17,863.14 rows=1,851 width=4) (actual time=2.268..2.350 rows=737 loops=1)

  • Group Key: t166_userrolehierarchy_5.sid
59. 0.708 2.052 ↑ 2.0 934 1

Nested Loop Semi Join (cost=60.05..17,839.98 rows=1,860 width=4) (actual time=0.129..2.052 rows=934 loops=1)

60. 0.313 0.410 ↑ 2.0 934 1

Bitmap Heap Scan on t166_userrolehierarchy t166_userrolehierarchy_5 (cost=59.63..6,838.33 rows=1,860 width=8) (actual time=0.113..0.410 rows=934 loops=1)

  • Recheck Cond: ((c663_ancestor_role_id = 237423) AND (end_stamp = '32503680000000'::bigint))
  • Heap Blocks: exact=130
61. 0.097 0.097 ↑ 2.0 944 1

Bitmap Index Scan on ix_t166_userrolehierarchy_ancestor_end_start_timestamp (cost=0.00..59.16 rows=1,860 width=0) (actual time=0.097..0.097 rows=944 loops=1)

  • Index Cond: ((c663_ancestor_role_id = 237423) AND (end_stamp = '32503680000000'::bigint))
62. 0.934 0.934 ↑ 1.0 1 934

Index Scan using ix_t67_userroledim_sid_timestamp_partial on t67_userroledim t67_userroledim_5 (cost=0.42..5.90 rows=1 width=4) (actual time=0.001..0.001 rows=1 loops=934)

  • Index Cond: ((sid = t166_userrolehierarchy_5.c662_user_role_id) AND (end_stamp = '32503680000000'::bigint))
  • Filter: ((NOT deleted) AND (sid <> '-2'::integer))
63. 6.240 6.240 ↓ 0.0 0 2,080

Index Scan using ix_t236_opp_line_item_fact_sid_timestamp on t236_opp_line_item_fact t236_opp_line_item_fact_3 (cost=0.56..6.99 rows=1 width=16) (actual time=0.003..0.003 rows=0 loops=2,080)

  • Index Cond: ((t236_opp_line_item_fact_2.sid = sid) AND (t236_opp_line_item_fact_2.sid = sid) AND (start_stamp <= '1520668799999'::bigint) AND (end_stamp > '1520668799999'::bigint))
  • Filter: (NOT deleted)
64. 0.000 4.160 ↑ 2.0 1 2,080

Append (cost=0.00..0.34 rows=2 width=16) (actual time=0.002..0.002 rows=1 loops=2,080)

65. 0.000 0.000 ↓ 0.0 0 2,080

Seq Scan on clari_conversion_rate cur177_t0_r0_2 (cost=0.00..0.00 rows=1 width=16) (actual time=0.000..0.000 rows=0 loops=2,080)

  • Filter: ((to_iso_code = 'USD'::text) AND (t236_opp_line_item_fact_2.c821_opp_currency_code = sid) AND (t236_opp_line_item_fact_2.c805_opp_close_date = rate_date))
66. 4.160 4.160 ↑ 1.0 1 2,080

Index Scan using ix_usd_clari_conversion_rate_date_isocode on usd_clari_conversion_rate cur177_t0_r0_3 (cost=0.29..0.34 rows=1 width=16) (actual time=0.001..0.002 rows=1 loops=2,080)

  • Index Cond: ((t236_opp_line_item_fact_2.c805_opp_close_date = rate_date) AND (t236_opp_line_item_fact_2.c821_opp_currency_code = sid))
  • Filter: (to_iso_code = 'USD'::text)
67.          

SubPlan (forNested Loop Left Join)

68. 0.415 0.415 ↑ 1.0 13 1

CTE Scan on picklist_3 cte0_7 (cost=0.00..0.26 rows=13 width=4) (actual time=0.011..0.415 rows=13 loops=1)

69. 0.000 0.000 ↓ 0.0 0

Nested Loop Semi Join (cost=0.98..17.04 rows=1 width=0) (never executed)

70. 0.000 0.000 ↓ 0.0 0

Index Scan using ix_t166_userrolehierarchy_sid_ancestor_end_start_timestamp on t166_userrolehierarchy t166_userrolehierarchy_3 (cost=0.56..8.58 rows=1 width=4) (never executed)

  • Index Cond: ((sid = t236_opp_line_item_fact_3.c804_opp_ownerid) AND (c663_ancestor_role_id = 237423) AND (end_stamp = '32503680000000'::bigint))
71. 0.000 0.000 ↓ 0.0 0

Index Scan using ix_t67_userroledim_sid_end_start_timestamp_partial on t67_userroledim t67_userroledim_3 (cost=0.42..8.44 rows=1 width=4) (never executed)

  • Index Cond: ((sid = t166_userrolehierarchy_3.c662_user_role_id) AND (end_stamp = '32503680000000'::bigint))
  • Filter: ((NOT deleted) AND (sid <> '-2'::integer))
72. 0.655 1.874 ↑ 2.0 934 1

Nested Loop Semi Join (cost=60.05..17,839.98 rows=1,860 width=4) (actual time=0.107..1.874 rows=934 loops=1)

73. 0.204 0.285 ↑ 2.0 934 1

Bitmap Heap Scan on t166_userrolehierarchy t166_userrolehierarchy_4 (cost=59.63..6,838.33 rows=1,860 width=8) (actual time=0.098..0.285 rows=934 loops=1)

  • Recheck Cond: ((c663_ancestor_role_id = 237423) AND (end_stamp = '32503680000000'::bigint))
  • Heap Blocks: exact=130
74. 0.081 0.081 ↑ 2.0 944 1

Bitmap Index Scan on ix_t166_userrolehierarchy_ancestor_end_start_timestamp (cost=0.00..59.16 rows=1,860 width=0) (actual time=0.081..0.081 rows=944 loops=1)

  • Index Cond: ((c663_ancestor_role_id = 237423) AND (end_stamp = '32503680000000'::bigint))
75. 0.934 0.934 ↑ 1.0 1 934

Index Scan using ix_t67_userroledim_sid_timestamp_partial on t67_userroledim t67_userroledim_4 (cost=0.42..5.90 rows=1 width=4) (actual time=0.001..0.001 rows=1 loops=934)

  • Index Cond: ((sid = t166_userrolehierarchy_4.c662_user_role_id) AND (end_stamp = '32503680000000'::bigint))
  • Filter: ((NOT deleted) AND (sid <> '-2'::integer))
76. 0.010 625.510 ↑ 3,341.8 4 1

Subquery Scan on *SELECT* 1 (cost=0.00..434.43 rows=13,367 width=96) (actual time=624.916..625.510 rows=4 loops=1)

77. 625.500 625.500 ↑ 3,341.8 4 1

CTE Scan on bucketd cte0 (cost=0.00..267.34 rows=13,367 width=120) (actual time=624.909..625.500 rows=4 loops=1)

78. 0.014 1.019 ↑ 38.5 8 1

Hash Join (cost=19.68..30.07 rows=308 width=96) (actual time=1.011..1.019 rows=8 loops=1)

  • Hash Cond: (cte0_1.c6 = t234_opportunityforecastcategorypicklistdim.sid)
79. 0.993 0.993 ↑ 38.5 8 1

CTE Scan on bucketab cte0_1 (cost=0.00..6.16 rows=308 width=68) (actual time=0.987..0.993 rows=8 loops=1)

80. 0.006 0.012 ↑ 86.0 5 1

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

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
81. 0.006 0.006 ↑ 86.0 5 1

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