explain.depesz.com

PostgreSQL's explain analyze made readable

Result: I6A8

Settings
# exclusive inclusive rows x rows loops node
1. 0.006 3,594.649 ↑ 4,450.4 44 1

Append (cost=1,393,075.85..1,401,947.04 rows=195,818 width=120) (actual time=2,525.020..3,594.649 rows=44 loops=1)

2.          

CTE picklist_0

3. 0.294 0.294 ↑ 1.0 6 1

Seq Scan on t233_opportunitystagenamepicklistdim (cost=0.00..46.54 rows=6 width=4) (actual time=0.008..0.294 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.279 0.279 ↑ 1.0 7 1

Seq Scan on t233_opportunitystagenamepicklistdim t233_opportunitystagenamepicklistdim_1 (cost=0.00..48.08 rows=7 width=4) (actual time=0.005..0.279 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.449 0.449 ↑ 1.0 13 1

Seq Scan on t233_opportunitystagenamepicklistdim t233_opportunitystagenamepicklistdim_2 (cost=0.00..57.31 rows=13 width=4) (actual time=0.014..0.449 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. 15.469 1,084.511 ↑ 3.0 8,167 1

HashAggregate (cost=271,324.15..271,570.20 rows=24,605 width=4) (actual time=1,083.680..1,084.511 rows=8,167 loops=1)

  • Group Key: distinctclosedateowner.ownerid
10.          

CTE owners

11. 198.744 656.215 ↑ 9.9 129,854 1

Hash Join (cost=59,737.43..236,613.36 rows=1,284,535 width=4) (actual time=153.085..656.215 rows=129,854 loops=1)

  • Hash Cond: (t166_userrolehierarchy.c662_user_role_id = t67_userroledim.sid)
12. 312.350 444.952 ↓ 1.0 1,322,764 1

Bitmap Heap Scan on t166_userrolehierarchy (cost=37,339.61..194,848.64 rows=1,284,535 width=8) (actual time=139.876..444.952 rows=1,322,764 loops=1)

  • Recheck Cond: ((c663_ancestor_role_id = ANY ('{436,247157}'::integer[])) AND (end_stamp = '32503680000000'::bigint))
  • Heap Blocks: exact=39466
13. 132.602 132.602 ↓ 1.0 1,326,433 1

Bitmap Index Scan on ix_t166_userrolehierarchy_ancestor_end_start_timestamp (cost=0.00..37,018.48 rows=1,284,535 width=0) (actual time=132.602..132.602 rows=1,326,433 loops=1)

  • Index Cond: ((c663_ancestor_role_id = ANY ('{436,247157}'::integer[])) AND (end_stamp = '32503680000000'::bigint))
14. 1.401 12.519 ↑ 9.3 8,370 1

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

  • Buckets: 131072 Batches: 2 Memory Usage: 1177kB
15. 6.635 11.118 ↑ 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=4.909..11.118 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: 5666
  • Heap Blocks: exact=2151
16. 4.483 4.483 ↑ 5.6 14,066 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.483..4.483 rows=14,066 loops=1)

  • Index Cond: (end_stamp = '32503680000000'::bigint)
17. 77.823 1,069.042 ↓ 1.2 93,387 1

Nested Loop (cost=28,902.47..34,510.71 rows=80,033 width=4) (actual time=724.012..1,069.042 rows=93,387 loops=1)

18. 62.538 749.453 ↓ 604.4 120,883 1

HashAggregate (cost=28,902.04..28,904.04 rows=200 width=4) (actual time=723.984..749.453 rows=120,883 loops=1)

  • Group Key: owners.c1
19. 686.915 686.915 ↑ 9.9 129,854 1

CTE Scan on owners (cost=0.00..25,690.70 rows=1,284,535 width=4) (actual time=153.087..686.915 rows=129,854 loops=1)

20. 241.766 241.766 ↑ 6.0 1 120,883

Index Only Scan using ix_distinctclosedateowner_owner_closedate on distinctclosedateowner (cost=0.43..27.97 rows=6 width=4) (actual time=0.002..0.002 rows=1 loops=120,883)

  • Index Cond: ((ownerid = owners.c1) AND (closedate <= 20190131) AND (closedate >= 20181101))
  • Heap Fetches: 93387
21.          

CTE bucketac

22. 35.746 2,597.693 ↑ 4,317.1 19 1

GroupAggregate (cost=411,503.76..415,399.90 rows=82,024 width=92) (actual time=2,524.995..2,597.693 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 (hashed SubPlan 6) THEN CASE WHEN (hashed SubPlan 7) THEN 'won'::text WHEN (hashed SubPlan 8) 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)
23. 122.462 2,561.947 ↓ 1.3 110,684 1

Sort (cost=410,949.85..411,154.91 rows=82,024 width=72) (actual time=2,524.894..2,561.947 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 (hashed SubPlan 6) THEN CASE WHEN (hashed SubPlan 7) THEN 'won'::text WHEN (hashed SubPlan 8) 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
24. 127.554 2,439.485 ↓ 1.3 110,684 1

Hash Left Join (cost=5,393.19..400,888.15 rows=82,024 width=72) (actual time=1,137.985..2,439.485 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))
25. 75.687 2,264.976 ↓ 1.8 110,684 1

Nested Loop Left Join (cost=594.38..378,940.65 rows=60,230 width=64) (actual time=1,088.665..2,264.976 rows=110,684 loops=1)

26. 29.917 1,967.921 ↓ 2.5 110,684 1

Hash Left Join (cost=594.38..364,093.29 rows=44,226 width=60) (actual time=1,088.649..1,967.921 rows=110,684 loops=1)

  • Hash Cond: (t237_oppfact_1.c844_opp_forecastcategory = t234_opportunityforecastcategorypicklistdim_3.sid)
27. 100.713 1,938.000 ↓ 2.5 110,684 1

Nested Loop Left Join (cost=574.71..363,465.51 rows=44,226 width=60) (actual time=1,088.638..1,938.000 rows=110,684 loops=1)

28. 28.145 1,394.551 ↓ 2.5 110,684 1

Hash Left Join (cost=574.14..10,343.91 rows=44,226 width=28) (actual time=1,088.625..1,394.551 rows=110,684 loops=1)

  • Hash Cond: (t237_oppfact.c844_opp_forecastcategory = t234_opportunityforecastcategorypicklistdim_2.sid)
29. 14.717 1,366.396 ↓ 2.5 110,684 1

Nested Loop (cost=554.47..9,716.13 rows=44,226 width=24) (actual time=1,088.601..1,366.396 rows=110,684 loops=1)

30. 4.202 1,090.335 ↓ 40.8 8,167 1

HashAggregate (cost=553.61..555.61 rows=200 width=4) (actual time=1,088.102..1,090.335 rows=8,167 loops=1)

  • Group Key: ownercte_1.c1
31. 1,086.133 1,086.133 ↑ 3.0 8,167 1

CTE Scan on ownercte ownercte_1 (cost=0.00..492.10 rows=24,605 width=4) (actual time=1,083.684..1,086.133 rows=8,167 loops=1)

32. 260.893 261.344 ↓ 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.010..0.032 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 9)))
  • Rows Removed by Filter: 3
33.          

SubPlan (forIndex Scan)

34. 0.451 0.451 ↑ 1.0 13 1

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

35. 0.005 0.010 ↑ 86.0 5 1

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

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
36. 0.005 0.005 ↑ 86.0 5 1

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

37. 442.736 442.736 ↑ 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.004..0.004 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)
38. 0.003 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
39. 0.001 0.001 ↑ 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.001 rows=5 loops=1)

40. 0.000 221.368 ↑ 2.0 1 110,684

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

41. 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))
42. 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)
43. 18.697 45.820 ↓ 1.0 101,732 1

Hash (cost=2,222.31..2,222.31 rows=101,706 width=16) (actual time=45.820..45.820 rows=101,732 loops=1)

  • Buckets: 131072 Batches: 2 Memory Usage: 3412kB
44. 5.833 27.123 ↓ 1.0 101,732 1

Append (cost=0.00..2,222.31 rows=101,706 width=16) (actual time=0.125..27.123 rows=101,732 loops=1)

45. 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)
46. 21.290 21.290 ↓ 1.0 101,732 1

Seq Scan on usd_clari_conversion_rate cur177_t0_r0_1 (cost=0.00..2,222.31 rows=101,705 width=16) (actual time=0.123..21.290 rows=101,732 loops=1)

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

SubPlan (forHash Left Join)

48. 0.558 0.558 ↑ 3.0 8,167 1

CTE Scan on ownercte (cost=0.00..492.10 rows=24,605 width=4) (actual time=0.001..0.558 rows=8,167 loops=1)

49. 0.297 0.297 ↑ 1.0 6 1

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

50. 0.280 0.280 ↑ 1.0 7 1

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

51.          

CTE bucketec

52. 3.901 996.838 ↑ 4,551.8 25 1

GroupAggregate (cost=701,097.89..705,934.13 rows=113,794 width=116) (actual time=991.969..996.838 rows=25 loops=1)

  • Group Key: (CASE WHEN (t237_oppfact_3.sid IS NULL) THEN 'newBucket'::text WHEN (NOT (hashed SubPlan 11)) 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 (hashed SubPlan 12) THEN 'otherBucket'::text ELSE 'gainedOwnershipBucket'::text END ELSE 'otherBucket'::text END), (CASE WHEN (hashed SubPlan 13) THEN 'won'::text WHEN (hashed SubPlan 14) THEN 'lost'::text ELSE 'newOpen'::text END), t237_oppfact_2.c844_opp_forecastcategory
53. 8.364 992.937 ↑ 8.2 13,920 1

Sort (cost=700,543.69..700,828.18 rows=113,794 width=88) (actual time=991.950..992.937 rows=13,920 loops=1)

  • Sort Key: (CASE WHEN (t237_oppfact_3.sid IS NULL) THEN 'newBucket'::text WHEN (NOT (hashed SubPlan 11)) 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 (hashed SubPlan 12) THEN 'otherBucket'::text ELSE 'gainedOwnershipBucket'::text END ELSE 'otherBucket'::text END), (CASE WHEN (hashed SubPlan 13) THEN 'won'::text WHEN (hashed SubPlan 14) THEN 'lost'::text ELSE 'newOpen'::text END), t237_oppfact_2.c844_opp_forecastcategory
  • Sort Method: quicksort Memory: 1481kB
54. 19.709 984.573 ↑ 8.2 13,920 1

Hash Left Join (cost=5,907.46..685,541.23 rows=113,794 width=88) (actual time=49.727..984.573 rows=13,920 loops=1)

  • Hash Cond: ((t237_oppfact_2.c845_opp_currency_code = cur177_t0_r0_2.sid) AND (t237_oppfact_2.c836_opp_close_date = cur177_t0_r0_2.rate_date))
55. 84.466 919.267 ↑ 6.0 13,920 1

Nested Loop Left Join (cost=1,108.36..657,756.42 rows=83,558 width=44) (actual time=4.646..919.267 rows=13,920 loops=1)

  • 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 (hashed SubPlan 15)))
  • Rows Removed by Filter: 130814
56. 38.510 255.285 ↓ 1.7 144,734 1

Nested Loop (cost=554.18..9,662.63 rows=86,104 width=28) (actual time=2.471..255.285 rows=144,734 loops=1)

57. 3.838 4.433 ↓ 40.8 8,167 1

HashAggregate (cost=553.61..555.61 rows=200 width=4) (actual time=2.449..4.433 rows=8,167 loops=1)

  • Group Key: ownercte_4.c1
58. 0.595 0.595 ↑ 3.0 8,167 1

CTE Scan on ownercte ownercte_4 (cost=0.00..492.10 rows=24,605 width=4) (actual time=0.001..0.595 rows=8,167 loops=1)

59. 212.342 212.342 ↓ 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.026 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
60. 578.936 578.936 ↑ 1.0 1 144,734

Index Scan using ix_t237_oppfact_sid_timestamp on t237_oppfact t237_oppfact_3 (cost=0.56..7.50 rows=1 width=16) (actual time=0.004..0.004 rows=1 loops=144,734)

  • Index Cond: ((t237_oppfact_2.sid = sid) AND (t237_oppfact_2.sid = sid) AND (start_stamp <= '1541055600000'::bigint) AND (end_stamp > '1541055600000'::bigint))
  • Filter: (NOT deleted)
61.          

SubPlan (forNested Loop Left Join)

62. 0.580 0.580 ↑ 3.0 8,167 1

CTE Scan on ownercte ownercte_3 (cost=0.00..492.10 rows=24,605 width=4) (actual time=0.000..0.580 rows=8,167 loops=1)

63. 17.794 45.004 ↓ 1.0 101,732 1

Hash (cost=2,222.31..2,222.31 rows=101,706 width=16) (actual time=45.004..45.004 rows=101,732 loops=1)

  • Buckets: 131072 Batches: 2 Memory Usage: 3412kB
64. 6.058 27.210 ↓ 1.0 101,732 1

Append (cost=0.00..2,222.31 rows=101,706 width=16) (actual time=0.123..27.210 rows=101,732 loops=1)

65. 0.001 0.001 ↓ 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.001..0.001 rows=0 loops=1)

  • Filter: (to_iso_code = 'USD'::text)
66. 21.151 21.151 ↓ 1.0 101,732 1

Seq Scan on usd_clari_conversion_rate cur177_t0_r0_3 (cost=0.00..2,222.31 rows=101,705 width=16) (actual time=0.121..21.151 rows=101,732 loops=1)

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

SubPlan (forHash Left Join)

68. 0.002 0.002 ↑ 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.002 rows=13 loops=1)

69. 0.589 0.589 ↑ 3.0 8,167 1

CTE Scan on ownercte ownercte_2 (cost=0.00..492.10 rows=24,605 width=4) (actual time=0.000..0.589 rows=8,167 loops=1)

70. 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.000..0.001 rows=6 loops=1)

71. 0.001 0.001 ↑ 1.0 7 1

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

72. 0.017 2,597.738 ↑ 4,317.1 19 1

Hash Join (cost=19.68..2,787.99 rows=82,024 width=120) (actual time=2,525.020..2,597.738 rows=19 loops=1)

  • Hash Cond: (cte0.c4 = t234_opportunityforecastcategorypicklistdim.sid)
73. 2,597.710 2,597.710 ↑ 4,317.1 19 1

CTE Scan on bucketac cte0 (cost=0.00..1,640.48 rows=82,024 width=92) (actual time=2,524.998..2,597.710 rows=19 loops=1)

74. 0.004 0.011 ↑ 86.0 5 1

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

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
75. 0.007 0.007 ↑ 86.0 5 1

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

76. 0.014 996.905 ↑ 4,551.8 25 1

Subquery Scan on *SELECT* 2 (cost=19.68..5,282.65 rows=113,794 width=120) (actual time=992.008..996.905 rows=25 loops=1)

77. 0.024 996.891 ↑ 4,551.8 25 1

Hash Join (cost=19.68..3,860.22 rows=113,794 width=144) (actual time=992.000..996.891 rows=25 loops=1)

  • Hash Cond: (cte0_1.c6 = t234_opportunityforecastcategorypicklistdim_1.sid)
78. 996.855 996.855 ↑ 4,551.8 25 1

CTE Scan on bucketec cte0_1 (cost=0.00..2,275.88 rows=113,794 width=116) (actual time=991.975..996.855 rows=25 loops=1)

79. 0.005 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
80. 0.007 0.007 ↑ 86.0 5 1

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