#	exclusive	inclusive	rows x	rows	loops	node
1.	0.002	7,192.464	↑ 923.8	24	1	→ Append (cost=10,001,318.62..10,022,824.98 rows=22,171 width=120) (actual time=4,127.583..7,192.464 rows=24 loops=1)
2.						CTE picklist_0
3.	0.321	0.321	↑ 1.0	6	1	→ Seq Scan on t35_opportunitystagenamepicklistdim (cost=0.00..70.54 rows=6 width=4) (actual time=0.008..0.321 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.317	0.317	↑ 1.0	7	1	→ Seq Scan on t35_opportunitystagenamepicklistdim t35_opportunitystagenamepicklistdim_1 (cost=0.00..72.08 rows=7 width=4) (actual time=0.005..0.317 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.438	0.438	↑ 1.0	13	1	→ Seq Scan on t35_opportunitystagenamepicklistdim t35_opportunitystagenamepicklistdim_2 (cost=0.00..81.31 rows=13 width=4) (actual time=0.012..0.438 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.	16.887	922.817	↑ 3.0	8,167	1	→ HashAggregate (cost=430,090.01..430,334.38 rows=24,437 width=4) (actual time=921.782..922.817 rows=8,167 loops=1) Group Key: distinctclosedateowner.ownerid
10.	60.209	905.930	↑ 1.6	93,387	1	→ Hash Join (cost=396,392.55..429,715.64 rows=149,749 width=4) (actual time=785.806..905.930 rows=93,387 loops=1) Hash Cond: (distinctclosedateowner.ownerid = t166_userrolehierarchy.sid)
11.	63.463	82.737	↓ 1.3	196,760	1	→ Bitmap Heap Scan on distinctclosedateowner (cost=3,179.36..32,515.59 rows=149,749 width=4) (actual time=22.319..82.737 rows=196,760 loops=1) Recheck Cond: ((closedate <= 20190131) AND (closedate >= 20181101)) Heap Blocks: exact=17913
12.	19.274	19.274	↓ 1.3	196,760	1	→ Bitmap Index Scan on ix_closedate_distinctclosedateowner (cost=0.00..3,141.92 rows=149,749 width=0) (actual time=19.274..19.274 rows=196,760 loops=1) Index Cond: ((closedate <= 20190131) AND (closedate >= 20181101))
13.	17.227	762.984	↑ 1.6	120,703	1	→ Hash (cost=390,004.96..390,004.96 rows=195,539 width=4) (actual time=762.984..762.984 rows=120,703 loops=1) Buckets: 131072 Batches: 4 Memory Usage: 2089kB
14.	15.109	745.757	↑ 1.6	120,703	1	→ Unique (cost=383,596.87..390,004.96 rows=195,539 width=4) (actual time=714.948..745.757 rows=120,703 loops=1)
15.	70.635	730.648	↑ 9.9	129,568	1	→ Sort (cost=383,596.87..386,800.91 rows=1,281,618 width=4) (actual time=714.947..730.648 rows=129,568 loops=1) Sort Key: t166_userrolehierarchy.sid Sort Method: external merge Disk: 1768kB
16.	202.683	660.013	↑ 9.9	129,568	1	→ Hash Join (cost=59,579.52..236,055.20 rows=1,281,618 width=4) (actual time=148.992..660.013 rows=129,568 loops=1) Hash Cond: (t166_userrolehierarchy.c662_user_role_id = t67_userroledim.sid)
17.	316.264	445.474	↓ 1.0	1,321,359	1	→ Bitmap Heap Scan on t166_userrolehierarchy (cost=37,181.70..194,332.97 rows=1,281,618 width=8) (actual time=136.427..445.474 rows=1,321,359 loops=1) Recheck Cond: ((c663_ancestor_role_id = ANY ('{436,247157}'::integer[])) AND (end_stamp = '32503680000000'::bigint)) Heap Blocks: exact=39199
18.	129.210	129.210	↓ 1.0	1,322,571	1	→ Bitmap Index Scan on ix_t166_userrolehierarchy_ancestor_end_start_timestamp (cost=0.00..36,861.30 rows=1,281,618 width=0) (actual time=129.210..129.210 rows=1,322,571 loops=1) Index Cond: ((c663_ancestor_role_id = ANY ('{436,247157}'::integer[])) AND (end_stamp = '32503680000000'::bigint))
19.	1.393	11.856	↑ 9.3	8,370	1	→ Hash (cost=21,117.18..21,117.18 rows=78,051 width=4) (actual time=11.856..11.856 rows=8,370 loops=1) Buckets: 131072 Batches: 2 Memory Usage: 1177kB
20.	6.088	10.463	↑ 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.779..10.463 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: 5520 Heap Blocks: exact=2138
21.	4.375	4.375	↑ 5.7	13,911	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.375..4.375 rows=13,911 loops=1) Index Cond: (end_stamp = '32503680000000'::bigint)
22.						CTE bucketac
23.	136.944	4,384.772	↑ 46,674.4	19	1	→ GroupAggregate (cost=4,279,451.46..4,321,575.13 rows=886,814 width=92) (actual time=4,127.549..4,384.772 rows=19 loops=1) Group Key: t21_opp_line_item_fact.c320_opp_forecastcategory, (CASE WHEN (t21_opp_line_item_fact_1.sid IS NULL) THEN 'deleted'::text WHEN ((t21_opp_line_item_fact_1.c270_opp_close_date < 20181101) OR (t21_opp_line_item_fact_1.c270_opp_close_date > 20190131)) THEN 'slipped'::text WHEN (hashed SubPlan 5) THEN CASE WHEN (hashed SubPlan 6) THEN 'won'::text WHEN (hashed SubPlan 7) THEN 'lost'::text ELSE CASE WHEN (t34_opportunityforecastcategorypicklistdim_2.correlated_app_order = t34_opportunityforecastcategorypicklistdim_3.correlated_app_order) THEN 'unchanged'::text WHEN (t34_opportunityforecastcategorypicklistdim_2.correlated_app_order > t34_opportunityforecastcategorypicklistdim_3.correlated_app_order) THEN 'upgraded'::text ELSE 'downgraded'::text END END ELSE 'lostOwnership'::text END)
24.	333.907	4,247.828	↑ 2.1	418,251	1	→ Sort (cost=4,278,901.34..4,281,118.37 rows=886,814 width=72) (actual time=4,127.186..4,247.828 rows=418,251 loops=1) Sort Key: t21_opp_line_item_fact.c320_opp_forecastcategory, (CASE WHEN (t21_opp_line_item_fact_1.sid IS NULL) THEN 'deleted'::text WHEN ((t21_opp_line_item_fact_1.c270_opp_close_date < 20181101) OR (t21_opp_line_item_fact_1.c270_opp_close_date > 20190131)) THEN 'slipped'::text WHEN (hashed SubPlan 5) THEN CASE WHEN (hashed SubPlan 6) THEN 'won'::text WHEN (hashed SubPlan 7) THEN 'lost'::text ELSE CASE WHEN (t34_opportunityforecastcategorypicklistdim_2.correlated_app_order = t34_opportunityforecastcategorypicklistdim_3.correlated_app_order) THEN 'unchanged'::text WHEN (t34_opportunityforecastcategorypicklistdim_2.correlated_app_order > t34_opportunityforecastcategorypicklistdim_3.correlated_app_order) THEN 'upgraded'::text ELSE 'downgraded'::text END END ELSE 'lostOwnership'::text END) Sort Method: external merge Disk: 26568kB
25.	400.045	3,913.921	↑ 2.1	418,251	1	→ Hash Left Join (cost=9,523.15..4,118,540.78 rows=886,814 width=72) (actual time=1,021.850..3,913.921 rows=418,251 loops=1) Hash Cond: ((t21_opp_line_item_fact_1.c323_opp_currency_code = cur177_t1_r1.sid) AND (t21_opp_line_item_fact_1.c270_opp_close_date = cur177_t1_r1.rate_date))
26.	218.870	3,467.249	↑ 1.8	418,251	1	→ Hash Left Join (cost=4,763.25..3,910,642.87 rows=753,775 width=60) (actual time=972.951..3,467.249 rows=418,251 loops=1) Hash Cond: ((t21_opp_line_item_fact.c323_opp_currency_code = cur177_t0_r0.sid) AND (t21_opp_line_item_fact.c270_opp_close_date = cur177_t0_r0.rate_date))
27.	115.862	3,202.592	↑ 1.5	418,251	1	→ Hash Left Join (cost=553.47..3,746,887.13 rows=640,694 width=60) (actual time=926.767..3,202.592 rows=418,251 loops=1) Hash Cond: (t21_opp_line_item_fact_1.c320_opp_forecastcategory = t34_opportunityforecastcategorypicklistdim_3.sid)
28.	184.748	3,086.724	↑ 1.5	418,251	1	→ Nested Loop Left Join (cost=552.36..3,738,377.61 rows=640,694 width=60) (actual time=926.754..3,086.724 rows=418,251 loops=1)
29.	95.566	1,647.223	↑ 1.5	418,251	1	→ Hash Left Join (cost=551.80..227,191.22 rows=640,694 width=28) (actual time=926.740..1,647.223 rows=418,251 loops=1) Hash Cond: (t21_opp_line_item_fact.c320_opp_forecastcategory = t34_opportunityforecastcategorypicklistdim_2.sid)
30.	59.715	1,551.650	↑ 1.5	418,251	1	→ Nested Loop (cost=550.69..218,681.69 rows=640,694 width=24) (actual time=926.723..1,551.650 rows=418,251 loops=1)
31.	4.110	928.412	↓ 40.8	8,167	1	→ HashAggregate (cost=549.83..551.83 rows=200 width=4) (actual time=926.234..928.412 rows=8,167 loops=1) Group Key: ownercte_1.c1
32.	924.302	924.302	↑ 3.0	8,167	1	→ CTE Scan on ownercte ownercte_1 (cost=0.00..488.74 rows=24,437 width=4) (actual time=921.784..924.302 rows=8,167 loops=1)
33.	563.079	563.523	↑ 2.6	51	8,167	→ Index Scan using ix_t21_opp_line_item_fact_owner_closedate_timestamp on t21_opp_line_item_fact (cost=0.85..1,089.31 rows=134 width=28) (actual time=0.013..0.069 rows=51 loops=8,167) Index Cond: ((c268_opp_ownerid = ownercte_1.c1) AND (c270_opp_close_date >= 20181101) AND (c270_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: 23
34.						SubPlan (forIndex Scan)
35.	0.444	0.444	↑ 1.0	13	1	→ CTE Scan on picklist_4 cte0_4 (cost=0.00..0.26 rows=13 width=4) (actual time=0.014..0.444 rows=13 loops=1)
36.	0.003	0.007	↑ 1.0	5	1	→ Hash (cost=1.05..1.05 rows=5 width=8) (actual time=0.007..0.007 rows=5 loops=1) Buckets: 1024 Batches: 1 Memory Usage: 9kB
37.	0.004	0.004	↑ 1.0	5	1	→ Seq Scan on t34_opportunityforecastcategorypicklistdim t34_opportunityforecastcategorypicklistdim_2 (cost=0.00..1.05 rows=5 width=8) (actual time=0.004..0.004 rows=5 loops=1)
38.	1,254.753	1,254.753	↑ 1.0	1	418,251	→ Index Scan using ix_t21_opp_line_item_fact_sid_timestamp on t21_opp_line_item_fact t21_opp_line_item_fact_1 (cost=0.56..5.47 rows=1 width=32) (actual time=0.003..0.003 rows=1 loops=418,251) Index Cond: ((t21_opp_line_item_fact.sid = sid) AND (t21_opp_line_item_fact.sid = sid) AND (start_stamp <= '1542009599999'::bigint) AND (end_stamp > '1542009599999'::bigint)) Filter: (NOT deleted)
39.	0.004	0.006	↑ 1.0	5	1	→ Hash (cost=1.05..1.05 rows=5 width=8) (actual time=0.006..0.006 rows=5 loops=1) Buckets: 1024 Batches: 1 Memory Usage: 9kB
40.	0.002	0.002	↑ 1.0	5	1	→ Seq Scan on t34_opportunityforecastcategorypicklistdim t34_opportunityforecastcategorypicklistdim_3 (cost=0.00..1.05 rows=5 width=8) (actual time=0.001..0.002 rows=5 loops=1)
41.	18.689	45.787	↑ 1.0	100,855	1	→ Hash (cost=2,203.80..2,203.80 rows=100,865 width=16) (actual time=45.787..45.787 rows=100,855 loops=1) Buckets: 131072 Batches: 2 Memory Usage: 3391kB
42.	5.984	27.098	↑ 1.0	100,855	1	→ Append (cost=0.00..2,203.80 rows=100,865 width=16) (actual time=0.115..27.098 rows=100,855 loops=1)
43.	0.002	0.002	↓ 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.002..0.002 rows=0 loops=1) Filter: (to_iso_code = 'USD'::text)
44.	21.112	21.112	↑ 1.0	100,855	1	→ Seq Scan on usd_clari_conversion_rate cur177_t0_r0_1 (cost=0.00..2,203.80 rows=100,864 width=16) (actual time=0.113..21.112 rows=100,855 loops=1) Filter: (to_iso_code = 'USD'::text)
45.	19.046	45.310	↑ 1.0	100,855	1	→ Hash (cost=2,203.80..2,203.80 rows=100,865 width=16) (actual time=45.310..45.310 rows=100,855 loops=1) Buckets: 131072 Batches: 2 Memory Usage: 3391kB
46.	6.094	26.264	↑ 1.0	100,855	1	→ Append (cost=0.00..2,203.80 rows=100,865 width=16) (actual time=0.093..26.264 rows=100,855 loops=1)
47.	0.001	0.001	↓ 0.0	0	1	→ Seq Scan on clari_conversion_rate cur177_t1_r1 (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)
48.	20.169	20.169	↑ 1.0	100,855	1	→ Seq Scan on usd_clari_conversion_rate cur177_t1_r1_1 (cost=0.00..2,203.80 rows=100,864 width=16) (actual time=0.091..20.169 rows=100,855 loops=1) Filter: (to_iso_code = 'USD'::text)
49.						SubPlan (forHash Left Join)
50.	0.675	0.675	↑ 3.0	8,167	1	→ CTE Scan on ownercte (cost=0.00..488.74 rows=24,437 width=4) (actual time=0.001..0.675 rows=8,167 loops=1)
51.	0.324	0.324	↑ 1.0	6	1	→ CTE Scan on picklist_0 cte0_2 (cost=0.00..0.12 rows=6 width=4) (actual time=0.009..0.324 rows=6 loops=1)
52.	0.318	0.318	↑ 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.318 rows=7 loops=1)
53.						CTE bucketec
54.	15.990	2,807.583	↓ 5.0	5	1	→ GroupAggregate (cost=5,249,184.02..5,249,184.06 rows=1 width=116) (actual time=2,788.944..2,807.583 rows=5 loops=1) Group Key: (CASE WHEN (t21_opp_line_item_fact_3.sid IS NULL) THEN 'newBucket'::text WHEN (NOT (hashed SubPlan 10)) THEN CASE WHEN (t21_opp_line_item_fact_3.c270_opp_close_date > 20190131) THEN 'pulledInBucket'::text WHEN (t21_opp_line_item_fact_3.c270_opp_close_date < 20181101) THEN 'pushedInBucket'::text WHEN (hashed 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), t21_opp_line_item_fact_2.c320_opp_forecastcategory
55.	144.767	2,791.593	↓ 60,323.0	60,323	1	→ Sort (cost=5,248,633.60..5,248,633.61 rows=1 width=88) (actual time=2,783.531..2,791.593 rows=60,323 loops=1) Sort Key: (CASE WHEN (t21_opp_line_item_fact_3.sid IS NULL) THEN 'newBucket'::text WHEN (NOT (hashed SubPlan 10)) THEN CASE WHEN (t21_opp_line_item_fact_3.c270_opp_close_date > 20190131) THEN 'pulledInBucket'::text WHEN (t21_opp_line_item_fact_3.c270_opp_close_date < 20181101) THEN 'pushedInBucket'::text WHEN (hashed 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), t21_opp_line_item_fact_2.c320_opp_forecastcategory Sort Method: external merge Disk: 3272kB
56.	41.141	2,646.826	↓ 60,323.0	60,323	1	→ Nested Loop Left Join (cost=1,101.38..5,248,633.59 rows=1 width=88) (actual time=2.380..2,646.826 rows=60,323 loops=1)
57.	0.000	2,485.038	↓ 60,323.0	60,323	1	→ Nested Loop Anti Join (cost=550.96..5,248,082.82 rows=1 width=44) (actual time=2.348..2,485.038 rows=60,323 loops=1)
58.	141.551	603.309	↑ 1.9	662,713	1	→ Nested Loop (cost=550.39..213,275.14 rows=1,250,312 width=28) (actual time=2.335..603.309 rows=662,713 loops=1)
59.	3.768	4.406	↓ 40.8	8,167	1	→ HashAggregate (cost=549.83..551.83 rows=200 width=4) (actual time=2.312..4.406 rows=8,167 loops=1) Group Key: ownercte_3.c1
60.	0.638	0.638	↑ 3.0	8,167	1	→ CTE Scan on ownercte ownercte_3 (cost=0.00..488.74 rows=24,437 width=4) (actual time=0.001..0.638 rows=8,167 loops=1)
61.	457.352	457.352	↑ 3.2	81	8,167	→ Index Scan using ix_t21_opp_line_item_fact_owner_closedate_timestamp on t21_opp_line_item_fact t21_opp_line_item_fact_2 (cost=0.56..1,061.01 rows=261 width=32) (actual time=0.009..0.056 rows=81 loops=8,167) Index Cond: ((c268_opp_ownerid = ownercte_3.c1) AND (c270_opp_close_date >= 20181101) AND (c270_opp_close_date <= 20190131) AND (start_stamp <= '1542009599999'::bigint) AND (end_stamp > '1542009599999'::bigint)) Filter: (NOT deleted) Rows Removed by Filter: 0
62.	1,988.139	1,988.139	↑ 1.0	1	662,713	→ Index Scan using ix_t21_opp_line_item_fact_sid_timestamp on t21_opp_line_item_fact t21_opp_line_item_fact_3 (cost=0.56..4.02 rows=1 width=16) (actual time=0.003..0.003 rows=1 loops=662,713) Index Cond: ((t21_opp_line_item_fact_2.sid = sid) AND (t21_opp_line_item_fact_2.sid = sid) AND (start_stamp <= '1541055600000'::bigint) AND (end_stamp > '1541055600000'::bigint)) Filter: (NOT deleted)
63.	0.000	120.646	↑ 2.0	1	60,323	→ Append (cost=0.00..0.32 rows=2 width=16) (actual time=0.002..0.002 rows=1 loops=60,323)
64.	0.000	0.000	↓ 0.0	0	60,323	→ 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=60,323) Filter: ((to_iso_code = 'USD'::text) AND (t21_opp_line_item_fact_2.c323_opp_currency_code = sid) AND (t21_opp_line_item_fact_2.c270_opp_close_date = rate_date))
65.	120.646	120.646	↑ 1.0	1	60,323	→ Index Scan using ix_usd_clari_conversion_rate_date_isocode on usd_clari_conversion_rate cur177_t0_r0_3 (cost=0.29..0.32 rows=1 width=16) (actual time=0.002..0.002 rows=1 loops=60,323) Index Cond: ((t21_opp_line_item_fact_2.c270_opp_close_date = rate_date) AND (t21_opp_line_item_fact_2.c323_opp_currency_code = sid)) Filter: (to_iso_code = 'USD'::text)
66.						SubPlan (forNested Loop Left Join)
67.	0.000	0.000	↓ 0.0		0	→ CTE Scan on picklist_4 cte0_5 (cost=0.00..0.26 rows=13 width=4) (never executed)
68.	0.000	0.000	↓ 0.0		0	→ CTE Scan on ownercte ownercte_2 (cost=0.00..488.74 rows=24,437 width=4) (never executed)
69.	0.000	0.000	↑ 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.000 rows=6 loops=1)
70.	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.001..0.001 rows=7 loops=1)
71.	0.025	4,384.832	↑ 1,166.8	19	1	→ Hash Join (cost=1.11..21,284.64 rows=22,170 width=96) (actual time=4,127.582..4,384.832 rows=19 loops=1) Hash Cond: (cte0.c4 = t34_opportunityforecastcategorypicklistdim.sid)
72.	4,384.789	4,384.789	↑ 46,674.4	19	1	→ CTE Scan on bucketac cte0 (cost=0.00..17,736.28 rows=886,814 width=92) (actual time=4,127.551..4,384.789 rows=19 loops=1)
73.	0.004	0.018	↑ 1.0	5	1	→ Hash (cost=1.05..1.05 rows=5 width=12) (actual time=0.018..0.018 rows=5 loops=1) Buckets: 1024 Batches: 1 Memory Usage: 9kB
74.	0.014	0.014	↑ 1.0	5	1	→ Seq Scan on t34_opportunityforecastcategorypicklistdim (cost=0.00..1.05 rows=5 width=12) (actual time=0.013..0.014 rows=5 loops=1)
75.	0.009	2,807.630	↓ 5.0	5	1	→ Subquery Scan on SELECT 2 (cost=0.03..1.12 rows=1 width=96) (actual time=2,807.624..2,807.630 rows=5 loops=1)
76.	0.018	2,807.621	↓ 5.0	5	1	→ Hash Join (cost=0.03..1.11 rows=1 width=120) (actual time=2,807.617..2,807.621 rows=5 loops=1) Hash Cond: (t34_opportunityforecastcategorypicklistdim_1.sid = cte0_1.c6)
77.	0.006	0.006	↑ 1.0	5	1	→ Seq Scan on t34_opportunityforecastcategorypicklistdim t34_opportunityforecastcategorypicklistdim_1 (cost=0.00..1.05 rows=5 width=12) (actual time=0.004..0.006 rows=5 loops=1)
78.	0.007	2,807.597	↓ 5.0	5	1	→ Hash (cost=0.02..0.02 rows=1 width=116) (actual time=2,807.597..2,807.597 rows=5 loops=1) Buckets: 1024 Batches: 1 Memory Usage: 9kB
79.	2,807.590	2,807.590	↓ 5.0	5	1	→ CTE Scan on bucketec cte0_1 (cost=0.00..0.02 rows=1 width=116) (actual time=2,788.946..2,807.590 rows=5 loops=1)

 Append  (cost=10001318.62..10022824.98 rows=22171 width=120) (actual time=4127.583..7192.464 rows=24 loops=1)
   CTE picklist_0
     ->  Seq Scan on t35_opportunitystagenamepicklistdim  (cost=0.00..70.54 rows=6 width=4) (actual time=0.008..0.321 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
   CTE picklist_1
     ->  Seq Scan on t35_opportunitystagenamepicklistdim t35_opportunitystagenamepicklistdim_1  (cost=0.00..72.08 rows=7 width=4) (actual time=0.005..0.317 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
   CTE picklist_4
     ->  Seq Scan on t35_opportunitystagenamepicklistdim t35_opportunitystagenamepicklistdim_2  (cost=0.00..81.31 rows=13 width=4) (actual time=0.012..0.438 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
   CTE ownercte
     ->  HashAggregate  (cost=430090.01..430334.38 rows=24437 width=4) (actual time=921.782..922.817 rows=8167 loops=1)
           Group Key: distinctclosedateowner.ownerid
           ->  Hash Join  (cost=396392.55..429715.64 rows=149749 width=4) (actual time=785.806..905.930 rows=93387 loops=1)
                 Hash Cond: (distinctclosedateowner.ownerid = t166_userrolehierarchy.sid)
                 ->  Bitmap Heap Scan on distinctclosedateowner  (cost=3179.36..32515.59 rows=149749 width=4) (actual time=22.319..82.737 rows=196760 loops=1)
                       Recheck Cond: ((closedate <= 20190131) AND (closedate >= 20181101))
                       Heap Blocks: exact=17913
                       ->  Bitmap Index Scan on ix_closedate_distinctclosedateowner  (cost=0.00..3141.92 rows=149749 width=0) (actual time=19.274..19.274 rows=196760 loops=1)
                             Index Cond: ((closedate <= 20190131) AND (closedate >= 20181101))
                 ->  Hash  (cost=390004.96..390004.96 rows=195539 width=4) (actual time=762.984..762.984 rows=120703 loops=1)
                       Buckets: 131072  Batches: 4  Memory Usage: 2089kB
                       ->  Unique  (cost=383596.87..390004.96 rows=195539 width=4) (actual time=714.948..745.757 rows=120703 loops=1)
                             ->  Sort  (cost=383596.87..386800.91 rows=1281618 width=4) (actual time=714.947..730.648 rows=129568 loops=1)
                                   Sort Key: t166_userrolehierarchy.sid
                                   Sort Method: external merge  Disk: 1768kB
                                   ->  Hash Join  (cost=59579.52..236055.20 rows=1281618 width=4) (actual time=148.992..660.013 rows=129568 loops=1)
                                         Hash Cond: (t166_userrolehierarchy.c662_user_role_id = t67_userroledim.sid)
                                         ->  Bitmap Heap Scan on t166_userrolehierarchy  (cost=37181.70..194332.97 rows=1281618 width=8) (actual time=136.427..445.474 rows=1321359 loops=1)
                                               Recheck Cond: ((c663_ancestor_role_id = ANY ('{436,247157}'::integer[])) AND (end_stamp = '32503680000000'::bigint))
                                               Heap Blocks: exact=39199
                                               ->  Bitmap Index Scan on ix_t166_userrolehierarchy_ancestor_end_start_timestamp  (cost=0.00..36861.30 rows=1281618 width=0) (actual time=129.210..129.210 rows=1322571 loops=1)
                                                     Index Cond: ((c663_ancestor_role_id = ANY ('{436,247157}'::integer[])) AND (end_stamp = '32503680000000'::bigint))
                                         ->  Hash  (cost=21117.18..21117.18 rows=78051 width=4) (actual time=11.856..11.856 rows=8370 loops=1)
                                               Buckets: 131072  Batches: 2  Memory Usage: 1177kB
                                               ->  Bitmap Heap Scan on t67_userroledim  (cost=4261.99..21117.18 rows=78051 width=4) (actual time=4.779..10.463 rows=8370 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: 5520
                                                     Heap Blocks: exact=2138
                                                     ->  Bitmap Index Scan on ix_t67_userroledim_sid_end_start_timestamp_partial  (cost=0.00..4242.48 rows=78925 width=0) (actual time=4.375..4.375 rows=13911 loops=1)
                                                           Index Cond: (end_stamp = '32503680000000'::bigint)
   CTE bucketac
     ->  GroupAggregate  (cost=4279451.46..4321575.13 rows=886814 width=92) (actual time=4127.549..4384.772 rows=19 loops=1)
           Group Key: t21_opp_line_item_fact.c320_opp_forecastcategory, (CASE WHEN (t21_opp_line_item_fact_1.sid IS NULL) THEN 'deleted'::text WHEN ((t21_opp_line_item_fact_1.c270_opp_close_date < 20181101) OR (t21_opp_line_item_fact_1.c270_opp_close_date > 20190131)) THEN 'slipped'::text WHEN (hashed SubPlan 5) THEN CASE WHEN (hashed SubPlan 6) THEN 'won'::text WHEN (hashed SubPlan 7) THEN 'lost'::text ELSE CASE WHEN (t34_opportunityforecastcategorypicklistdim_2.correlated_app_order = t34_opportunityforecastcategorypicklistdim_3.correlated_app_order) THEN 'unchanged'::text WHEN (t34_opportunityforecastcategorypicklistdim_2.correlated_app_order > t34_opportunityforecastcategorypicklistdim_3.correlated_app_order) THEN 'upgraded'::text ELSE 'downgraded'::text END END ELSE 'lostOwnership'::text END)
           ->  Sort  (cost=4278901.34..4281118.37 rows=886814 width=72) (actual time=4127.186..4247.828 rows=418251 loops=1)
                 Sort Key: t21_opp_line_item_fact.c320_opp_forecastcategory, (CASE WHEN (t21_opp_line_item_fact_1.sid IS NULL) THEN 'deleted'::text WHEN ((t21_opp_line_item_fact_1.c270_opp_close_date < 20181101) OR (t21_opp_line_item_fact_1.c270_opp_close_date > 20190131)) THEN 'slipped'::text WHEN (hashed SubPlan 5) THEN CASE WHEN (hashed SubPlan 6) THEN 'won'::text WHEN (hashed SubPlan 7) THEN 'lost'::text ELSE CASE WHEN (t34_opportunityforecastcategorypicklistdim_2.correlated_app_order = t34_opportunityforecastcategorypicklistdim_3.correlated_app_order) THEN 'unchanged'::text WHEN (t34_opportunityforecastcategorypicklistdim_2.correlated_app_order > t34_opportunityforecastcategorypicklistdim_3.correlated_app_order) THEN 'upgraded'::text ELSE 'downgraded'::text END END ELSE 'lostOwnership'::text END)
                 Sort Method: external merge  Disk: 26568kB
                 ->  Hash Left Join  (cost=9523.15..4118540.78 rows=886814 width=72) (actual time=1021.850..3913.921 rows=418251 loops=1)
                       Hash Cond: ((t21_opp_line_item_fact_1.c323_opp_currency_code = cur177_t1_r1.sid) AND (t21_opp_line_item_fact_1.c270_opp_close_date = cur177_t1_r1.rate_date))
                       ->  Hash Left Join  (cost=4763.25..3910642.87 rows=753775 width=60) (actual time=972.951..3467.249 rows=418251 loops=1)
                             Hash Cond: ((t21_opp_line_item_fact.c323_opp_currency_code = cur177_t0_r0.sid) AND (t21_opp_line_item_fact.c270_opp_close_date = cur177_t0_r0.rate_date))
                             ->  Hash Left Join  (cost=553.47..3746887.13 rows=640694 width=60) (actual time=926.767..3202.592 rows=418251 loops=1)
                                   Hash Cond: (t21_opp_line_item_fact_1.c320_opp_forecastcategory = t34_opportunityforecastcategorypicklistdim_3.sid)
                                   ->  Nested Loop Left Join  (cost=552.36..3738377.61 rows=640694 width=60) (actual time=926.754..3086.724 rows=418251 loops=1)
                                         ->  Hash Left Join  (cost=551.80..227191.22 rows=640694 width=28) (actual time=926.740..1647.223 rows=418251 loops=1)
                                               Hash Cond: (t21_opp_line_item_fact.c320_opp_forecastcategory = t34_opportunityforecastcategorypicklistdim_2.sid)
                                               ->  Nested Loop  (cost=550.69..218681.69 rows=640694 width=24) (actual time=926.723..1551.650 rows=418251 loops=1)
                                                     ->  HashAggregate  (cost=549.83..551.83 rows=200 width=4) (actual time=926.234..928.412 rows=8167 loops=1)
                                                           Group Key: ownercte_1.c1
                                                           ->  CTE Scan on ownercte ownercte_1  (cost=0.00..488.74 rows=24437 width=4) (actual time=921.784..924.302 rows=8167 loops=1)
                                                     ->  Index Scan using ix_t21_opp_line_item_fact_owner_closedate_timestamp on t21_opp_line_item_fact  (cost=0.85..1089.31 rows=134 width=28) (actual time=0.013..0.069 rows=51 loops=8167)
                                                           Index Cond: ((c268_opp_ownerid = ownercte_1.c1) AND (c270_opp_close_date >= 20181101) AND (c270_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: 23
                                                           SubPlan 8
                                                             ->  CTE Scan on picklist_4 cte0_4  (cost=0.00..0.26 rows=13 width=4) (actual time=0.014..0.444 rows=13 loops=1)
                                               ->  Hash  (cost=1.05..1.05 rows=5 width=8) (actual time=0.007..0.007 rows=5 loops=1)
                                                     Buckets: 1024  Batches: 1  Memory Usage: 9kB
                                                     ->  Seq Scan on t34_opportunityforecastcategorypicklistdim t34_opportunityforecastcategorypicklistdim_2  (cost=0.00..1.05 rows=5 width=8) (actual time=0.004..0.004 rows=5 loops=1)
                                         ->  Index Scan using ix_t21_opp_line_item_fact_sid_timestamp on t21_opp_line_item_fact t21_opp_line_item_fact_1  (cost=0.56..5.47 rows=1 width=32) (actual time=0.003..0.003 rows=1 loops=418251)
                                               Index Cond: ((t21_opp_line_item_fact.sid = sid) AND (t21_opp_line_item_fact.sid = sid) AND (start_stamp <= '1542009599999'::bigint) AND (end_stamp > '1542009599999'::bigint))
                                               Filter: (NOT deleted)
                                   ->  Hash  (cost=1.05..1.05 rows=5 width=8) (actual time=0.006..0.006 rows=5 loops=1)
                                         Buckets: 1024  Batches: 1  Memory Usage: 9kB
                                         ->  Seq Scan on t34_opportunityforecastcategorypicklistdim t34_opportunityforecastcategorypicklistdim_3  (cost=0.00..1.05 rows=5 width=8) (actual time=0.001..0.002 rows=5 loops=1)
                             ->  Hash  (cost=2203.80..2203.80 rows=100865 width=16) (actual time=45.787..45.787 rows=100855 loops=1)
                                   Buckets: 131072  Batches: 2  Memory Usage: 3391kB
                                   ->  Append  (cost=0.00..2203.80 rows=100865 width=16) (actual time=0.115..27.098 rows=100855 loops=1)
                                         ->  Seq Scan on clari_conversion_rate cur177_t0_r0  (cost=0.00..0.00 rows=1 width=16) (actual time=0.002..0.002 rows=0 loops=1)
                                               Filter: (to_iso_code = 'USD'::text)
                                         ->  Seq Scan on usd_clari_conversion_rate cur177_t0_r0_1  (cost=0.00..2203.80 rows=100864 width=16) (actual time=0.113..21.112 rows=100855 loops=1)
                                               Filter: (to_iso_code = 'USD'::text)
                       ->  Hash  (cost=2203.80..2203.80 rows=100865 width=16) (actual time=45.310..45.310 rows=100855 loops=1)
                             Buckets: 131072  Batches: 2  Memory Usage: 3391kB
                             ->  Append  (cost=0.00..2203.80 rows=100865 width=16) (actual time=0.093..26.264 rows=100855 loops=1)
                                   ->  Seq Scan on clari_conversion_rate cur177_t1_r1  (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)
                                   ->  Seq Scan on usd_clari_conversion_rate cur177_t1_r1_1  (cost=0.00..2203.80 rows=100864 width=16) (actual time=0.091..20.169 rows=100855 loops=1)
                                         Filter: (to_iso_code = 'USD'::text)
                       SubPlan 5
                         ->  CTE Scan on ownercte  (cost=0.00..488.74 rows=24437 width=4) (actual time=0.001..0.675 rows=8167 loops=1)
                       SubPlan 6
                         ->  CTE Scan on picklist_0 cte0_2  (cost=0.00..0.12 rows=6 width=4) (actual time=0.009..0.324 rows=6 loops=1)
                       SubPlan 7
                         ->  CTE Scan on picklist_1 cte0_3  (cost=0.00..0.14 rows=7 width=4) (actual time=0.006..0.318 rows=7 loops=1)
   CTE bucketec
     ->  GroupAggregate  (cost=5249184.02..5249184.06 rows=1 width=116) (actual time=2788.944..2807.583 rows=5 loops=1)
           Group Key: (CASE WHEN (t21_opp_line_item_fact_3.sid IS NULL) THEN 'newBucket'::text WHEN (NOT (hashed SubPlan 10)) THEN CASE WHEN (t21_opp_line_item_fact_3.c270_opp_close_date > 20190131) THEN 'pulledInBucket'::text WHEN (t21_opp_line_item_fact_3.c270_opp_close_date < 20181101) THEN 'pushedInBucket'::text WHEN (hashed 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), t21_opp_line_item_fact_2.c320_opp_forecastcategory
           ->  Sort  (cost=5248633.60..5248633.61 rows=1 width=88) (actual time=2783.531..2791.593 rows=60323 loops=1)
                 Sort Key: (CASE WHEN (t21_opp_line_item_fact_3.sid IS NULL) THEN 'newBucket'::text WHEN (NOT (hashed SubPlan 10)) THEN CASE WHEN (t21_opp_line_item_fact_3.c270_opp_close_date > 20190131) THEN 'pulledInBucket'::text WHEN (t21_opp_line_item_fact_3.c270_opp_close_date < 20181101) THEN 'pushedInBucket'::text WHEN (hashed 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), t21_opp_line_item_fact_2.c320_opp_forecastcategory
                 Sort Method: external merge  Disk: 3272kB
                 ->  Nested Loop Left Join  (cost=1101.38..5248633.59 rows=1 width=88) (actual time=2.380..2646.826 rows=60323 loops=1)
                       ->  Nested Loop Anti Join  (cost=550.96..5248082.82 rows=1 width=44) (actual time=2.348..2485.038 rows=60323 loops=1)
                             ->  Nested Loop  (cost=550.39..213275.14 rows=1250312 width=28) (actual time=2.335..603.309 rows=662713 loops=1)
                                   ->  HashAggregate  (cost=549.83..551.83 rows=200 width=4) (actual time=2.312..4.406 rows=8167 loops=1)
                                         Group Key: ownercte_3.c1
                                         ->  CTE Scan on ownercte ownercte_3  (cost=0.00..488.74 rows=24437 width=4) (actual time=0.001..0.638 rows=8167 loops=1)
                                   ->  Index Scan using ix_t21_opp_line_item_fact_owner_closedate_timestamp on t21_opp_line_item_fact t21_opp_line_item_fact_2  (cost=0.56..1061.01 rows=261 width=32) (actual time=0.009..0.056 rows=81 loops=8167)
                                         Index Cond: ((c268_opp_ownerid = ownercte_3.c1) AND (c270_opp_close_date >= 20181101) AND (c270_opp_close_date <= 20190131) AND (start_stamp <= '1542009599999'::bigint) AND (end_stamp > '1542009599999'::bigint))
                                         Filter: (NOT deleted)
                                         Rows Removed by Filter: 0
                             ->  Index Scan using ix_t21_opp_line_item_fact_sid_timestamp on t21_opp_line_item_fact t21_opp_line_item_fact_3  (cost=0.56..4.02 rows=1 width=16) (actual time=0.003..0.003 rows=1 loops=662713)
                                   Index Cond: ((t21_opp_line_item_fact_2.sid = sid) AND (t21_opp_line_item_fact_2.sid = sid) AND (start_stamp <= '1541055600000'::bigint) AND (end_stamp > '1541055600000'::bigint))
                                   Filter: (NOT deleted)
                       ->  Append  (cost=0.00..0.32 rows=2 width=16) (actual time=0.002..0.002 rows=1 loops=60323)
                             ->  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=60323)
                                   Filter: ((to_iso_code = 'USD'::text) AND (t21_opp_line_item_fact_2.c323_opp_currency_code = sid) AND (t21_opp_line_item_fact_2.c270_opp_close_date = rate_date))
                             ->  Index Scan using ix_usd_clari_conversion_rate_date_isocode on usd_clari_conversion_rate cur177_t0_r0_3  (cost=0.29..0.32 rows=1 width=16) (actual time=0.002..0.002 rows=1 loops=60323)
                                   Index Cond: ((t21_opp_line_item_fact_2.c270_opp_close_date = rate_date) AND (t21_opp_line_item_fact_2.c323_opp_currency_code = sid))
                                   Filter: (to_iso_code = 'USD'::text)
                       SubPlan 10
                         ->  CTE Scan on picklist_4 cte0_5  (cost=0.00..0.26 rows=13 width=4) (never executed)
                       SubPlan 11
                         ->  CTE Scan on ownercte ownercte_2  (cost=0.00..488.74 rows=24437 width=4) (never executed)
                       SubPlan 12
                         ->  CTE Scan on picklist_0 cte0_6  (cost=0.00..0.12 rows=6 width=4) (actual time=0.000..0.000 rows=6 loops=1)
                       SubPlan 13
                         ->  CTE Scan on picklist_1 cte0_7  (cost=0.00..0.14 rows=7 width=4) (actual time=0.001..0.001 rows=7 loops=1)
   ->  Hash Join  (cost=1.11..21284.64 rows=22170 width=96) (actual time=4127.582..4384.832 rows=19 loops=1)
         Hash Cond: (cte0.c4 = t34_opportunityforecastcategorypicklistdim.sid)
         ->  CTE Scan on bucketac cte0  (cost=0.00..17736.28 rows=886814 width=92) (actual time=4127.551..4384.789 rows=19 loops=1)
         ->  Hash  (cost=1.05..1.05 rows=5 width=12) (actual time=0.018..0.018 rows=5 loops=1)
               Buckets: 1024  Batches: 1  Memory Usage: 9kB
               ->  Seq Scan on t34_opportunityforecastcategorypicklistdim  (cost=0.00..1.05 rows=5 width=12) (actual time=0.013..0.014 rows=5 loops=1)
   ->  Subquery Scan on "*SELECT* 2"  (cost=0.03..1.12 rows=1 width=96) (actual time=2807.624..2807.630 rows=5 loops=1)
         ->  Hash Join  (cost=0.03..1.11 rows=1 width=120) (actual time=2807.617..2807.621 rows=5 loops=1)
               Hash Cond: (t34_opportunityforecastcategorypicklistdim_1.sid = cte0_1.c6)
               ->  Seq Scan on t34_opportunityforecastcategorypicklistdim t34_opportunityforecastcategorypicklistdim_1  (cost=0.00..1.05 rows=5 width=12) (actual time=0.004..0.006 rows=5 loops=1)
               ->  Hash  (cost=0.02..0.02 rows=1 width=116) (actual time=2807.597..2807.597 rows=5 loops=1)
                     Buckets: 1024  Batches: 1  Memory Usage: 9kB
                     ->  CTE Scan on bucketec cte0_1  (cost=0.00..0.02 rows=1 width=116) (actual time=2788.946..2807.590 rows=5 loops=1)
 Planning time: 5.375 ms
 Execution time: 7200.944 ms

Per node type stats

node type	count	sum of times	% of query
Append	4	12.080 ms	0.2 %
Bitmap Heap Scan	3	385.815 ms	5.4 %
Bitmap Index Scan	3	152.859 ms	2.1 %
CTE Scan	12	8,119.081 ms	112.9 %
GroupAggregate	2	152.934 ms	2.1 %
Hash	8	56.373 ms	0.8 %
Hash Join	4	262.935 ms	3.7 %
Hash Left Join	4	830.343 ms	11.5 %
HashAggregate	3	24.765 ms	0.3 %
Index Scan	5	4,383.969 ms	61.0 %
Nested Loop	2	201.266 ms	2.8 %
Nested Loop Anti Join	1	0.000 ms	0.0 %
Nested Loop Left Join	2	225.889 ms	3.1 %
Seq Scan	12	42.386 ms	0.6 %
Sort	3	549.309 ms	7.6 %
Subquery Scan	1	0.009 ms	0.0 %
Unique	1	15.109 ms	0.2 %

Per table stats

Table name	Scan count	Total time	% of query
scan type	count	sum of times	% of table
clari_conversion_rate	3	0.003 ms	0.0 %
Seq Scan	3	0.003 ms	100.0 %
distinctclosedateowner	1	63.463 ms	0.9 %
Bitmap Heap Scan	1	63.463 ms	100.0 %
t166_userrolehierarchy	1	316.264 ms	4.4 %
Bitmap Heap Scan	1	316.264 ms	100.0 %
t21_opp_line_item_fact	4	4,263.323 ms	59.3 %
Index Scan	4	4,263.323 ms	100.0 %
t34_opportunityforecastcategorypicklistdim	4	0.026 ms	0.0 %
Seq Scan	4	0.026 ms	100.0 %
t35_opportunitystagenamepicklistdim	3	1.076 ms	0.0 %
Seq Scan	3	1.076 ms	100.0 %
t67_userroledim	1	6.088 ms	0.1 %
Bitmap Heap Scan	1	6.088 ms	100.0 %
usd_clari_conversion_rate	3	161.927 ms	2.3 %
Index Scan	1	120.646 ms	74.5 %
Seq Scan	2	41.281 ms	25.5 %

explain.depesz.com

PostgreSQL's explain analyze made readable

Result: lOvX

Color mode:

Visible columns:

Per node type stats

Per table stats