explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Wcer

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 0.000 ↓ 0.0

GroupAggregate (cost=24,012,262,784.65..24,026,351,002.53 rows=75,580 width=92) (actual rows= loops=)

  • Group Key: (CASE WHEN ((SubPlan 1) > '2020-09-30'::date) THEN 'pulledInBucket'::text WHEN ((SubPlan 2) < '2020-07-01'::date) THEN 'pushedInBucket'::text ELSE 'newBucket'::text END), parent.stagename, (CASE WHEN (parent.stagename = ANY ('{"Closed Won",Renewed}'::text[])) THEN 'WON'::text WHEN (parent.stagename = ANY ('{"Closed Lost",Churned}'::text[])) THEN 'LOST'::text ELSE 'ACTIVE'::text END)
2. 0.000 0.000 ↓ 0.0

Sort (cost=24,012,262,784.65..24,012,262,986.47 rows=80,727 width=103) (actual rows= loops=)

  • Sort Key: (CASE WHEN ((SubPlan 1) > '2020-09-30'::date) THEN 'pulledInBucket'::text WHEN ((SubPlan 2) < '2020-07-01'::date) THEN 'pushedInBucket'::text ELSE 'newBucket'::text END), parent.stagename, (CASE WHEN (parent.stagename = ANY ('{"Closed Won",Renewed}'::text[])) THEN 'WON'::text WHEN (parent.stagename = ANY ('{"Closed Lost",Churned}'::text[])) THEN 'LOST'::text ELSE 'ACTIVE'::text END)
3. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on m_00di0000000bkfqeau_opportunity_revision parent (cost=199,633.31..24,012,251,788.09 rows=80,727 width=103) (actual rows= loops=)

  • Recheck Cond: ((closedate >= '2020-07-01'::date) AND (closedate <= '2020-09-30'::date) AND (end_date > '2020-08-05 06:59:59.999+00'::timestamp with time zone) AND ((roleid = ANY ('{00E3r000000TngdEAC,00E3r000000TnkjEAC,00E3r000000TneaEAC,00E3r000000TneVEAS,00E3r000000TnZqEAK,00E3r000000TnfhEAC,00E3r000000TngYEAS,00E3r000000TnhEEAS,00E3r000000TnZfEAK,00E3r000000TnfBEAS,00E3r000000TnkuEAC,00E0Z000001QqicUAC,00E3r000000Tnf2EAC,00E3r000000TngIEAS,00E3r000000TndOEAS,00E3r000000TnhvEAC,00E3r000000TnhUEAS,00E3r000000Tnh5EAC,00E3r000000TnfREAS,00E3r000000TnfsEAC,00E3r000000TneFEAS,00E0Z000001QqiXUAS,00E3r000000TnfmEAC,00E3r000000TneQEAS,00E3r000000TnfMEAS,00E0Z000000Tn1xUAC,00E3r000000TngiEAC,00E3r000000TngtEAC,00E3r000000TnewEAC,00E3r000000Tng9EAC,00E3r000000TnkoEAC,00E3r000000TngNEAS,00E3r000000TnhZEAS,00E3r000000TndTEAS,00E0Z000001QqihUAC,00E3r000000TnZVEA0,00E3r000000TnelEAC,00E3r000000TnheEAC,00E3r000000TnhJEAS,00E3r000000TnZkEAK,00E3r000000TnfxEAC,00E3r000000Tnh0EAC,00E3r000000TngDEAS,00E3r000000TnfnEAC,00E3r000000TnfHEAS,00E3r000000TnhKEAS,00E3r000000TnerEAC,00E3r000000Tng4EAC,00E3r000000TnktEAC,00E3r000000TnguEAC,00E0Z000001AHQyUAO,00E3r000000TnfcEAC,00E3r000000TngOEAS,00E3r000000TneLEAS,00E3r000000TnegEAC,00E3r000000TngjEAC,00E3r000000TnhfEAC,00E3r000000TndYEAS,00E3r000000Tnf8EAC,00E0Z000001QqiiUAC,00E0Z000000KS1BUAW,00E3r000000TnfXEAS,00E3r000000TnfyEAC,00E3r000000TnZpEAK,00E3r000000TngzEAC,00E3r000000TnhpEAC,00E3r000000TnkiEAC,00E3r000000TnhPEAS,00E3r000000TngTEAS,00E3r000000TnfCEAS,00E3r000000TneWEAS,00E3r000000TnZeEAK,00E3r000000TngoEAC,00E3r000000Tni1EAC,00E3r000000TneGEAS,00E3r000000Tnf3EAC,00E3r000000TndNEAS,00E3r000000TnhkEAC,00E3r000000TnfSEAS,00E3r000000TnebEAC,00E0Z000001IbcrUAC,00E3r000000TnflEAC,00E3r000000TnhoEAC,00E3r000000TngBEAS,00E3r000000TnghEAC,00E3r000000TnfFEAS,00E3r000000TnepEAC,00E3r000000Tng2EAC,00E3r000000TneZEAS,00E3r000000TngsEAC,00E3r000000TnZuEAK,00E3r000000TnknEAC,00E3r000000TnfVEAS,00E3r000000TngMEAS,00E3r000000TneJEAS,00E3r000000TnhzEAC,00E3r000000TnfaEAC,00E3r000000Tnf6EAC,00E3r000000TnhdEAC,00E3r000000TnhIEAS,00E3r000000TneeEAC,00E3r000000TnZjEAK,00E3r000000TnhYEAS,00E3r000000Tnh9EAC,00E3r000000TnfwEAC,00E3r000000TnhNEAS,00E3r000000TneUEAS,00E3r000000TnZZEA0,00E3r000000TnddEAC,00E0Z000000Tn1TUAS,00E3r000000TngREAS,00E3r000000TnksEAC,00E3r000000TngxEAC,00E3r000000TnfAEAS,00E3r000000TngmEAC,00E3r000000TnhiEAC,00E3r000000Tnf1EAC,00E3r000000TndPEAS,00E3r000000TnfQEAS,00E0Z000001QqixUAC,00E3r000000TneEEAS,00E3r000000TnhuEAC,00E3r000000TnevEAC,00E3r000000TngyEAC,00E3r000000Tng8EAC,00E3r000000TnhOEAS,00E3r000000TnePEAS,00E3r000000TnZoEAK,00E3r000000TnfLEAS,00E3r000000TngSEAS,00E3r000000TnZdEAK,00E3r000000TngnEAC,00E3r000000Tni0EAC,00E3r000000TndUEAS,00E3r000000TnekEAC,00E3r000000TnhjEAC,00E0Z000001QqiwUAC,00E0Z000001QqimUAC,00E3r000000TnhtEAC,00E3r000000TngcEAC,00E3r000000TngCEAS,00E3r000000TnfgEAC,00E3r000000TnZtEAK,00E3r000000TnfGEAS,00E3r000000TneqEAC,00E3r000000Tng3EAC,00E3r000000TnkmEAC,00E3r000000TngXEAS,00E3r000000TnfWEAS,00E3r000000TnhDEAS,00E3r000000TnkxEAC,00E3r000000Tnf7EAC,00E3r000000TnfbEAC,00E3r000000TneKEAS,00E3r000000Tnh4EAC,00E3r000000TngHEAS,00E3r000000TnfrEAC,00E3r000000TnhTEAS,00E3r000000TnZiEAK,00E3r000000TnefEAC,00E3r000000TndZEAS,00E0Z000000TmzcUAC,00E3r000000TnetEAC,00E3r000000Tng6EAC,00E3r000000TniIEAS,00E3r000000TngFEAS,00E3r000000TnhMEAS,00E3r000000TnZYEA0,00E3r000000TnfJEAS,00E3r000000TngQEAS,00E3r000000TnkrEAC,00E3r000000TngwEAC,00E3r000000TnhhEAC,00E3r000000TnglEAC,00E3r000000TnfeEAC,00E3r000000TneiEAC,00E3r000000TneNEAS,00E0Z000001QqikUAC,00E3r000000TndWEAS,00E3r000000TnfZEAS,00E3r000000TngAEAS,00E3r000000TngaEAC,00E3r000000TnhnEAC,00E3r000000TnZnEAK,00E3r000000TneoEAC,00E3r000000Tng1EAC,00E3r000000TneYEAS,00E3r000000TnfEEAS,00E3r000000TniNEAS,00E3r000000TngVEAS,00E3r000000TneIEAS,00E3r000000TnfUEAS,00E3r000000TnhBEAS,00E3r000000Tnf5EAC,00E3r000000Tnh2EAC,00E3r000000TnhmEAC,00E3r000000TnfpEAC,00E3r000000TnedEAC,00E3r000000TnhREAS,00E3r000000TnZcEAK,00E3r000000TnhyEAC,00E3r000000TnklEAC,00E3r000000TngbEAC,00E3r000000TneTEAS,00E3r000000TnZsEAK,00E3r000000TndcEAC,00E3r000000TnffEAC,00E0Z000000Tn14UAC,00E3r000000TngWEAS,00E3r000000TnezEAC,00E0Z000001IbcDUAS,00E3r000000TnhCEAS,00E3r000000TnkwEAC,00E3r000000TndQEAS,00E3r000000Tnf0EAC,00E3r000000TneDEAS,00E3r000000TnfPEAS,00E3r000000TngGEAS,00E3r000000TnZhEAK,00E3r000000Tnh3EAC,00E3r000000TnfqEAC,00E3r000000TnhxEAC,00E3r000000TnhSEAS,00E3r000000TneuEAC,00E3r000000Tng7EAC,00E3r000000TniDEAS,00E3r000000TnfkEAC,00E3r000000TnggEAC,00E3r000000TnfKEAS,00E3r000000TnZXEA0,00E3r000000TnkqEAC,00E3r000000TneOEAS,00E3r000000Tni4EAC,00E3r000000TngrEAC,00E3r000000TnhcEAC,00E3r000000TngLEAS,00E3r000000TnejEAC,00E3r000000TnhHEAS,00E3r000000TndVEAS,00E0Z000001QqivUAC,00E3r000000TnhsEAC,00E3r000000Tnh8EAC,00E3r000000TnfvEAC,00E3r000000TnhXEAS,00E3r000000TnhQEAS,00E3r000000TnZmEAK,00E3r000000TnfNEAS,00E3r000000TneREAS,00E3r000000TnexEAC,00E3r000000TndaEAC,00E3r000000TngUEAS,00E0Z000000Tmy5UAC,00E3r000000TndSEAS,00E3r000000TngpEAC,00E3r000000Tni2EAC,00E3r000000TnemEAC,00E0Z000001QqiuUAC,00E3r000000TnhlEAC,00E0Z000001IbcmUAC,00E3r000000TnZbEAK,00E3r000000TneBEAS,00E3r000000TnhrEAC,00E3r000000TnkkEAC,00E0Z000000KS1fUAG,00E3r000000TnesEAC,00E0Z000001ZO7XUAW,00E3r000000Tng5EAC,00E3r000000TngEEAS,00E3r000000TnZrEAK,00E3r000000TnfIEAS,00E3r000000TngeEAC,00E3r000000TnfiEAC,00E3r000000TndlEAC,00E3r000000TnhaEAC,00E3r000000TngZEAS,00E3r000000TnZgEAK,00E0Z000001E7VLUA0,00E3r000000TnkvEAC,00E3r000000TnfdEAC,00E3r000000TnehEAC,00E3r000000TnhFEAS,00E3r000000TngJEAS,00E3r000000TneMEAS,00E3r000000TndXEAS,00E3r000000TnfYEAS,00E3r000000Tnf9EAC,00E3r000000Tnh6EAC,00E3r000000TnftEAC,00E3r000000TnhVEAS,00E3r000000TnhqEAC,00E3r000000TndgEAC,00E3r000000TngfEAC,00E3r000000TnfjEAC,00E3r000000TnZWEA0,00E3r000000TnfDEAS,00E3r000000TngqEAC,00E3r000000Tni3EAC,00E3r000000TneXEAS,00E3r000000TnkpEAC,00E3r000000TneHEAS,00E3r000000Tnf4EAC,00E3r000000TnfTEAS,00E3r000000TnhGEAS,00E3r000000TnhbEAC,00E3r000000TngKEAS,00E3r000000TnecEAC,00E3r000000Tnh7EAC,00E3r000000TnfuEAC,00E3r000000TnhWEAS,00E3r000000TneSEAS,00E3r000000Tnh1EAC,00E3r000000TnfoEAC,00E3r000000TnfOEAS,00E3r000000TnhLEAS,00E3r000000TnZlEAK,00E3r000000TndbEAC,00E3r000000TnhAEAS,00E3r000000TneyEAC,00E3r000000TngvEAC,00E3r000000Tni8EAC,00E3r000000TndREAS,00E3r000000TngPEAS,00E3r000000TngkEAC,00E3r000000TnenEAC,00E3r000000Tng0EAC,00E3r000000TnhgEAC,00E3r000000TneCEAS,00E0Z000001QqijUAC,00E3r000000TnfzEAC,00E3r000000TnZaEAK,00E3r000000TnhwEAC}'::text[])) OR (roleid IS NULL)))
  • Filter: ((start_date <= '2020-08-05 06:59:59.999+00'::timestamp with time zone) AND (NOT (SubPlan 3)))
4. 0.000 0.000 ↓ 0.0

BitmapAnd (cost=151,609.50..151,609.50 rows=183,498 width=0) (actual rows= loops=)

5. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on ix_1596545519961_closedate_00di0000000bkfqeau_opportunity_revis (cost=0.00..13,486.92 rows=643,049 width=0) (actual rows= loops=)

  • Index Cond: ((closedate >= '2020-07-01'::date) AND (closedate <= '2020-09-30'::date))
6. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on ix_1596545519961_end_date_00di0000000bkfqeau_opportunity_revisi (cost=0.00..33,452.04 rows=1,811,148 width=0) (actual rows= loops=)

  • Index Cond: (end_date > '2020-08-05 06:59:59.999+00'::timestamp with time zone)
7. 0.000 0.000 ↓ 0.0

BitmapOr (cost=104,629.67..104,629.67 rows=4,729,869 width=0) (actual rows= loops=)

8. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on ix_1596545519961_roleid_00di0000000bkfqeau_opportunity_revision (cost=0.00..84,009.87 rows=3,939,601 width=0) (actual rows= loops=)

  • Index Cond: (roleid = ANY ('{00E3r000000TngdEAC,00E3r000000TnkjEAC,00E3r000000TneaEAC,00E3r000000TneVEAS,00E3r000000TnZqEAK,00E3r000000TnfhEAC,00E3r000000TngYEAS,00E3r000000TnhEEAS,00E3r000000TnZfEAK,00E3r000000TnfBEAS,00E3r000000TnkuEAC,00E0Z000001QqicUAC,00E3r000000Tnf2EAC,00E3r000000TngIEAS,00E3r000000TndOEAS,00E3r000000TnhvEAC,00E3r000000TnhUEAS,00E3r000000Tnh5EAC,00E3r000000TnfREAS,00E3r000000TnfsEAC,00E3r000000TneFEAS,00E0Z000001QqiXUAS,00E3r000000TnfmEAC,00E3r000000TneQEAS,00E3r000000TnfMEAS,00E0Z000000Tn1xUAC,00E3r000000TngiEAC,00E3r000000TngtEAC,00E3r000000TnewEAC,00E3r000000Tng9EAC,00E3r000000TnkoEAC,00E3r000000TngNEAS,00E3r000000TnhZEAS,00E3r000000TndTEAS,00E0Z000001QqihUAC,00E3r000000TnZVEA0,00E3r000000TnelEAC,00E3r000000TnheEAC,00E3r000000TnhJEAS,00E3r000000TnZkEAK,00E3r000000TnfxEAC,00E3r000000Tnh0EAC,00E3r000000TngDEAS,00E3r000000TnfnEAC,00E3r000000TnfHEAS,00E3r000000TnhKEAS,00E3r000000TnerEAC,00E3r000000Tng4EAC,00E3r000000TnktEAC,00E3r000000TnguEAC,00E0Z000001AHQyUAO,00E3r000000TnfcEAC,00E3r000000TngOEAS,00E3r000000TneLEAS,00E3r000000TnegEAC,00E3r000000TngjEAC,00E3r000000TnhfEAC,00E3r000000TndYEAS,00E3r000000Tnf8EAC,00E0Z000001QqiiUAC,00E0Z000000KS1BUAW,00E3r000000TnfXEAS,00E3r000000TnfyEAC,00E3r000000TnZpEAK,00E3r000000TngzEAC,00E3r000000TnhpEAC,00E3r000000TnkiEAC,00E3r000000TnhPEAS,00E3r000000TngTEAS,00E3r000000TnfCEAS,00E3r000000TneWEAS,00E3r000000TnZeEAK,00E3r000000TngoEAC,00E3r000000Tni1EAC,00E3r000000TneGEAS,00E3r000000Tnf3EAC,00E3r000000TndNEAS,00E3r000000TnhkEAC,00E3r000000TnfSEAS,00E3r000000TnebEAC,00E0Z000001IbcrUAC,00E3r000000TnflEAC,00E3r000000TnhoEAC,00E3r000000TngBEAS,00E3r000000TnghEAC,00E3r000000TnfFEAS,00E3r000000TnepEAC,00E3r000000Tng2EAC,00E3r000000TneZEAS,00E3r000000TngsEAC,00E3r000000TnZuEAK,00E3r000000TnknEAC,00E3r000000TnfVEAS,00E3r000000TngMEAS,00E3r000000TneJEAS,00E3r000000TnhzEAC,00E3r000000TnfaEAC,00E3r000000Tnf6EAC,00E3r000000TnhdEAC,00E3r000000TnhIEAS,00E3r000000TneeEAC,00E3r000000TnZjEAK,00E3r000000TnhYEAS,00E3r000000Tnh9EAC,00E3r000000TnfwEAC,00E3r000000TnhNEAS,00E3r000000TneUEAS,00E3r000000TnZZEA0,00E3r000000TnddEAC,00E0Z000000Tn1TUAS,00E3r000000TngREAS,00E3r000000TnksEAC,00E3r000000TngxEAC,00E3r000000TnfAEAS,00E3r000000TngmEAC,00E3r000000TnhiEAC,00E3r000000Tnf1EAC,00E3r000000TndPEAS,00E3r000000TnfQEAS,00E0Z000001QqixUAC,00E3r000000TneEEAS,00E3r000000TnhuEAC,00E3r000000TnevEAC,00E3r000000TngyEAC,00E3r000000Tng8EAC,00E3r000000TnhOEAS,00E3r000000TnePEAS,00E3r000000TnZoEAK,00E3r000000TnfLEAS,00E3r000000TngSEAS,00E3r000000TnZdEAK,00E3r000000TngnEAC,00E3r000000Tni0EAC,00E3r000000TndUEAS,00E3r000000TnekEAC,00E3r000000TnhjEAC,00E0Z000001QqiwUAC,00E0Z000001QqimUAC,00E3r000000TnhtEAC,00E3r000000TngcEAC,00E3r000000TngCEAS,00E3r000000TnfgEAC,00E3r000000TnZtEAK,00E3r000000TnfGEAS,00E3r000000TneqEAC,00E3r000000Tng3EAC,00E3r000000TnkmEAC,00E3r000000TngXEAS,00E3r000000TnfWEAS,00E3r000000TnhDEAS,00E3r000000TnkxEAC,00E3r000000Tnf7EAC,00E3r000000TnfbEAC,00E3r000000TneKEAS,00E3r000000Tnh4EAC,00E3r000000TngHEAS,00E3r000000TnfrEAC,00E3r000000TnhTEAS,00E3r000000TnZiEAK,00E3r000000TnefEAC,00E3r000000TndZEAS,00E0Z000000TmzcUAC,00E3r000000TnetEAC,00E3r000000Tng6EAC,00E3r000000TniIEAS,00E3r000000TngFEAS,00E3r000000TnhMEAS,00E3r000000TnZYEA0,00E3r000000TnfJEAS,00E3r000000TngQEAS,00E3r000000TnkrEAC,00E3r000000TngwEAC,00E3r000000TnhhEAC,00E3r000000TnglEAC,00E3r000000TnfeEAC,00E3r000000TneiEAC,00E3r000000TneNEAS,00E0Z000001QqikUAC,00E3r000000TndWEAS,00E3r000000TnfZEAS,00E3r000000TngAEAS,00E3r000000TngaEAC,00E3r000000TnhnEAC,00E3r000000TnZnEAK,00E3r000000TneoEAC,00E3r000000Tng1EAC,00E3r000000TneYEAS,00E3r000000TnfEEAS,00E3r000000TniNEAS,00E3r000000TngVEAS,00E3r000000TneIEAS,00E3r000000TnfUEAS,00E3r000000TnhBEAS,00E3r000000Tnf5EAC,00E3r000000Tnh2EAC,00E3r000000TnhmEAC,00E3r000000TnfpEAC,00E3r000000TnedEAC,00E3r000000TnhREAS,00E3r000000TnZcEAK,00E3r000000TnhyEAC,00E3r000000TnklEAC,00E3r000000TngbEAC,00E3r000000TneTEAS,00E3r000000TnZsEAK,00E3r000000TndcEAC,00E3r000000TnffEAC,00E0Z000000Tn14UAC,00E3r000000TngWEAS,00E3r000000TnezEAC,00E0Z000001IbcDUAS,00E3r000000TnhCEAS,00E3r000000TnkwEAC,00E3r000000TndQEAS,00E3r000000Tnf0EAC,00E3r000000TneDEAS,00E3r000000TnfPEAS,00E3r000000TngGEAS,00E3r000000TnZhEAK,00E3r000000Tnh3EAC,00E3r000000TnfqEAC,00E3r000000TnhxEAC,00E3r000000TnhSEAS,00E3r000000TneuEAC,00E3r000000Tng7EAC,00E3r000000TniDEAS,00E3r000000TnfkEAC,00E3r000000TnggEAC,00E3r000000TnfKEAS,00E3r000000TnZXEA0,00E3r000000TnkqEAC,00E3r000000TneOEAS,00E3r000000Tni4EAC,00E3r000000TngrEAC,00E3r000000TnhcEAC,00E3r000000TngLEAS,00E3r000000TnejEAC,00E3r000000TnhHEAS,00E3r000000TndVEAS,00E0Z000001QqivUAC,00E3r000000TnhsEAC,00E3r000000Tnh8EAC,00E3r000000TnfvEAC,00E3r000000TnhXEAS,00E3r000000TnhQEAS,00E3r000000TnZmEAK,00E3r000000TnfNEAS,00E3r000000TneREAS,00E3r000000TnexEAC,00E3r000000TndaEAC,00E3r000000TngUEAS,00E0Z000000Tmy5UAC,00E3r000000TndSEAS,00E3r000000TngpEAC,00E3r000000Tni2EAC,00E3r000000TnemEAC,00E0Z000001QqiuUAC,00E3r000000TnhlEAC,00E0Z000001IbcmUAC,00E3r000000TnZbEAK,00E3r000000TneBEAS,00E3r000000TnhrEAC,00E3r000000TnkkEAC,00E0Z000000KS1fUAG,00E3r000000TnesEAC,00E0Z000001ZO7XUAW,00E3r000000Tng5EAC,00E3r000000TngEEAS,00E3r000000TnZrEAK,00E3r000000TnfIEAS,00E3r000000TngeEAC,00E3r000000TnfiEAC,00E3r000000TndlEAC,00E3r000000TnhaEAC,00E3r000000TngZEAS,00E3r000000TnZgEAK,00E0Z000001E7VLUA0,00E3r000000TnkvEAC,00E3r000000TnfdEAC,00E3r000000TnehEAC,00E3r000000TnhFEAS,00E3r000000TngJEAS,00E3r000000TneMEAS,00E3r000000TndXEAS,00E3r000000TnfYEAS,00E3r000000Tnf9EAC,00E3r000000Tnh6EAC,00E3r000000TnftEAC,00E3r000000TnhVEAS,00E3r000000TnhqEAC,00E3r000000TndgEAC,00E3r000000TngfEAC,00E3r000000TnfjEAC,00E3r000000TnZWEA0,00E3r000000TnfDEAS,00E3r000000TngqEAC,00E3r000000Tni3EAC,00E3r000000TneXEAS,00E3r000000TnkpEAC,00E3r000000TneHEAS,00E3r000000Tnf4EAC,00E3r000000TnfTEAS,00E3r000000TnhGEAS,00E3r000000TnhbEAC,00E3r000000TngKEAS,00E3r000000TnecEAC,00E3r000000Tnh7EAC,00E3r000000TnfuEAC,00E3r000000TnhWEAS,00E3r000000TneSEAS,00E3r000000Tnh1EAC,00E3r000000TnfoEAC,00E3r000000TnfOEAS,00E3r000000TnhLEAS,00E3r000000TnZlEAK,00E3r000000TndbEAC,00E3r000000TnhAEAS,00E3r000000TneyEAC,00E3r000000TngvEAC,00E3r000000Tni8EAC,00E3r000000TndREAS,00E3r000000TngPEAS,00E3r000000TngkEAC,00E3r000000TnenEAC,00E3r000000Tng0EAC,00E3r000000TnhgEAC,00E3r000000TneCEAS,00E0Z000001QqijUAC,00E3r000000TnfzEAC,00E3r000000TnZaEAK,00E3r000000TnhwEAC}'::text[]))
9. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on ix_1596545519961_roleid_00di0000000bkfqeau_opportunity_revision (cost=0.00..20,579.43 rows=790,267 width=0) (actual rows= loops=)

  • Index Cond: (roleid IS NULL)
10.          

SubPlan (for Bitmap Heap Scan)

11. 0.000 0.000 ↓ 0.0

Materialize (cost=48,023.81..309,169.83 rows=160,609 width=19) (actual rows= loops=)

12. 0.000 0.000 ↓ 0.0

Gather (cost=48,023.81..307,424.79 rows=160,609 width=19) (actual rows= loops=)

  • Workers Planned: 2
13. 0.000 0.000 ↓ 0.0

Parallel Bitmap Heap Scan on m_00di0000000bkfqeau_opportunity_revision (cost=47,023.81..290,363.89 rows=66,920 width=19) (actual rows= loops=)

  • Recheck Cond: ((closedate >= '2020-07-01'::date) AND (closedate <= '2020-09-30'::date) AND (end_date > '2020-07-28 07:00:00+00'::timestamp with time zone))
  • Filter: ((start_date <= '2020-07-28 07:00:00+00'::timestamp with time zone) AND ((roleid = ANY ('{00E3r000000TngdEAC,00E3r000000TnkjEAC,00E3r000000TneaEAC,00E3r000000TneVEAS,00E3r000000TnZqEAK,00E3r000000TnfhEAC,00E3r000000TngYEAS,00E3r000000TnhEEAS,00E3r000000TnZfEAK,00E3r000000TnfBEAS,00E3r000000TnkuEAC,00E0Z000001QqicUAC,00E3r000000Tnf2EAC,00E3r000000TngIEAS,00E3r000000TndOEAS,00E3r000000TnhvEAC,00E3r000000TnhUEAS,00E3r000000Tnh5EAC,00E3r000000TnfREAS,00E3r000000TnfsEAC,00E3r000000TneFEAS,00E0Z000001QqiXUAS,00E3r000000TnfmEAC,00E3r000000TneQEAS,00E3r000000TnfMEAS,00E0Z000000Tn1xUAC,00E3r000000TngiEAC,00E3r000000TngtEAC,00E3r000000TnewEAC,00E3r000000Tng9EAC,00E3r000000TnkoEAC,00E3r000000TngNEAS,00E3r000000TnhZEAS,00E3r000000TndTEAS,00E0Z000001QqihUAC,00E3r000000TnZVEA0,00E3r000000TnelEAC,00E3r000000TnheEAC,00E3r000000TnhJEAS,00E3r000000TnZkEAK,00E3r000000TnfxEAC,00E3r000000Tnh0EAC,00E3r000000TngDEAS,00E3r000000TnfnEAC,00E3r000000TnfHEAS,00E3r000000TnhKEAS,00E3r000000TnerEAC,00E3r000000Tng4EAC,00E3r000000TnktEAC,00E3r000000TnguEAC,00E0Z000001AHQyUAO,00E3r000000TnfcEAC,00E3r000000TngOEAS,00E3r000000TneLEAS,00E3r000000TnegEAC,00E3r000000TngjEAC,00E3r000000TnhfEAC,00E3r000000TndYEAS,00E3r000000Tnf8EAC,00E0Z000001QqiiUAC,00E0Z000000KS1BUAW,00E3r000000TnfXEAS,00E3r000000TnfyEAC,00E3r000000TnZpEAK,00E3r000000TngzEAC,00E3r000000TnhpEAC,00E3r000000TnkiEAC,00E3r000000TnhPEAS,00E3r000000TngTEAS,00E3r000000TnfCEAS,00E3r000000TneWEAS,00E3r000000TnZeEAK,00E3r000000TngoEAC,00E3r000000Tni1EAC,00E3r000000TneGEAS,00E3r000000Tnf3EAC,00E3r000000TndNEAS,00E3r000000TnhkEAC,00E3r000000TnfSEAS,00E3r000000TnebEAC,00E0Z000001IbcrUAC,00E3r000000TnflEAC,00E3r000000TnhoEAC,00E3r000000TngBEAS,00E3r000000TnghEAC,00E3r000000TnfFEAS,00E3r000000TnepEAC,00E3r000000Tng2EAC,00E3r000000TneZEAS,00E3r000000TngsEAC,00E3r000000TnZuEAK,00E3r000000TnknEAC,00E3r000000TnfVEAS,00E3r000000TngMEAS,00E3r000000TneJEAS,00E3r000000TnhzEAC,00E3r000000TnfaEAC,00E3r000000Tnf6EAC,00E3r000000TnhdEAC,00E3r000000TnhIEAS,00E3r000000TneeEAC,00E3r000000TnZjEAK,00E3r000000TnhYEAS,00E3r000000Tnh9EAC,00E3r000000TnfwEAC,00E3r000000TnhNEAS,00E3r000000TneUEAS,00E3r000000TnZZEA0,00E3r000000TnddEAC,00E0Z000000Tn1TUAS,00E3r000000TngREAS,00E3r000000TnksEAC,00E3r000000TngxEAC,00E3r000000TnfAEAS,00E3r000000TngmEAC,00E3r000000TnhiEAC,00E3r000000Tnf1EAC,00E3r000000TndPEAS,00E3r000000TnfQEAS,00E0Z000001QqixUAC,00E3r000000TneEEAS,00E3r000000TnhuEAC,00E3r000000TnevEAC,00E3r000000TngyEAC,00E3r000000Tng8EAC,00E3r000000TnhOEAS,00E3r000000TnePEAS,00E3r000000TnZoEAK,00E3r000000TnfLEAS,00E3r000000TngSEAS,00E3r000000TnZdEAK,00E3r000000TngnEAC,00E3r000000Tni0EAC,00E3r000000TndUEAS,00E3r000000TnekEAC,00E3r000000TnhjEAC,00E0Z000001QqiwUAC,00E0Z000001QqimUAC,00E3r000000TnhtEAC,00E3r000000TngcEAC,00E3r000000TngCEAS,00E3r000000TnfgEAC,00E3r000000TnZtEAK,00E3r000000TnfGEAS,00E3r000000TneqEAC,00E3r000000Tng3EAC,00E3r000000TnkmEAC,00E3r000000TngXEAS,00E3r000000TnfWEAS,00E3r000000TnhDEAS,00E3r000000TnkxEAC,00E3r000000Tnf7EAC,00E3r000000TnfbEAC,00E3r000000TneKEAS,00E3r000000Tnh4EAC,00E3r000000TngHEAS,00E3r000000TnfrEAC,00E3r000000TnhTEAS,00E3r000000TnZiEAK,00E3r000000TnefEAC,00E3r000000TndZEAS,00E0Z000000TmzcUAC,00E3r000000TnetEAC,00E3r000000Tng6EAC,00E3r000000TniIEAS,00E3r000000TngFEAS,00E3r000000TnhMEAS,00E3r000000TnZYEA0,00E3r000000TnfJEAS,00E3r000000TngQEAS,00E3r000000TnkrEAC,00E3r000000TngwEAC,00E3r000000TnhhEAC,00E3r000000TnglEAC,00E3r000000TnfeEAC,00E3r000000TneiEAC,00E3r000000TneNEAS,00E0Z000001QqikUAC,00E3r000000TndWEAS,00E3r000000TnfZEAS,00E3r000000TngAEAS,00E3r000000TngaEAC,00E3r000000TnhnEAC,00E3r000000TnZnEAK,00E3r000000TneoEAC,00E3r000000Tng1EAC,00E3r000000TneYEAS,00E3r000000TnfEEAS,00E3r000000TniNEAS,00E3r000000TngVEAS,00E3r000000TneIEAS,00E3r000000TnfUEAS,00E3r000000TnhBEAS,00E3r000000Tnf5EAC,00E3r000000Tnh2EAC,00E3r000000TnhmEAC,00E3r000000TnfpEAC,00E3r000000TnedEAC,00E3r000000TnhREAS,00E3r000000TnZcEAK,00E3r000000TnhyEAC,00E3r000000TnklEAC,00E3r000000TngbEAC,00E3r000000TneTEAS,00E3r000000TnZsEAK,00E3r000000TndcEAC,00E3r000000TnffEAC,00E0Z000000Tn14UAC,00E3r000000TngWEAS,00E3r000000TnezEAC,00E0Z000001IbcDUAS,00E3r000000TnhCEAS,00E3r000000TnkwEAC,00E3r000000TndQEAS,00E3r000000Tnf0EAC,00E3r000000TneDEAS,00E3r000000TnfPEAS,00E3r000000TngGEAS,00E3r000000TnZhEAK,00E3r000000Tnh3EAC,00E3r000000TnfqEAC,00E3r000000TnhxEAC,00E3r000000TnhSEAS,00E3r000000TneuEAC,00E3r000000Tng7EAC,00E3r000000TniDEAS,00E3r000000TnfkEAC,00E3r000000TnggEAC,00E3r000000TnfKEAS,00E3r000000TnZXEA0,00E3r000000TnkqEAC,00E3r000000TneOEAS,00E3r000000Tni4EAC,00E3r000000TngrEAC,00E3r000000TnhcEAC,00E3r000000TngLEAS,00E3r000000TnejEAC,00E3r000000TnhHEAS,00E3r000000TndVEAS,00E0Z000001QqivUAC,00E3r000000TnhsEAC,00E3r000000Tnh8EAC,00E3r000000TnfvEAC,00E3r000000TnhXEAS,00E3r000000TnhQEAS,00E3r000000TnZmEAK,00E3r000000TnfNEAS,00E3r000000TneREAS,00E3r000000TnexEAC,00E3r000000TndaEAC,00E3r000000TngUEAS,00E0Z000000Tmy5UAC,00E3r000000TndSEAS,00E3r000000TngpEAC,00E3r000000Tni2EAC,00E3r000000TnemEAC,00E0Z000001QqiuUAC,00E3r000000TnhlEAC,00E0Z000001IbcmUAC,00E3r000000TnZbEAK,00E3r000000TneBEAS,00E3r000000TnhrEAC,00E3r000000TnkkEAC,00E0Z000000KS1fUAG,00E3r000000TnesEAC,00E0Z000001ZO7XUAW,00E3r000000Tng5EAC,00E3r000000TngEEAS,00E3r000000TnZrEAK,00E3r000000TnfIEAS,00E3r000000TngeEAC,00E3r000000TnfiEAC,00E3r000000TndlEAC,00E3r000000TnhaEAC,00E3r000000TngZEAS,00E3r000000TnZgEAK,00E0Z000001E7VLUA0,00E3r000000TnkvEAC,00E3r000000TnfdEAC,00E3r000000TnehEAC,00E3r000000TnhFEAS,00E3r000000TngJEAS,00E3r000000TneMEAS,00E3r000000TndXEAS,00E3r000000TnfYEAS,00E3r000000Tnf9EAC,00E3r000000Tnh6EAC,00E3r000000TnftEAC,00E3r000000TnhVEAS,00E3r000000TnhqEAC,00E3r000000TndgEAC,00E3r000000TngfEAC,00E3r000000TnfjEAC,00E3r000000TnZWEA0,00E3r000000TnfDEAS,00E3r000000TngqEAC,00E3r000000Tni3EAC,00E3r000000TneXEAS,00E3r000000TnkpEAC,00E3r000000TneHEAS,00E3r000000Tnf4EAC,00E3r000000TnfTEAS,00E3r000000TnhGEAS,00E3r000000TnhbEAC,00E3r000000TngKEAS,00E3r000000TnecEAC,00E3r000000Tnh7EAC,00E3r000000TnfuEAC,00E3r000000TnhWEAS,00E3r000000TneSEAS,00E3r000000Tnh1EAC,00E3r000000TnfoEAC,00E3r000000TnfOEAS,00E3r000000TnhLEAS,00E3r000000TnZlEAK,00E3r000000TndbEAC,00E3r000000TnhAEAS,00E3r000000TneyEAC,00E3r000000TngvEAC,00E3r000000Tni8EAC,00E3r000000TndREAS,00E3r000000TngPEAS,00E3r000000TngkEAC,00E3r000000TnenEAC,00E3r000000Tng0EAC,00E3r000000TnhgEAC,00E3r000000TneCEAS,00E0Z000001QqijUAC,00E3r000000TnfzEAC,00E3r000000TnZaEAK,00E3r000000TnhwEAC}'::text[])) OR (roleid IS NULL)))
14. 0.000 0.000 ↓ 0.0

BitmapAnd (cost=47,023.81..47,023.81 rows=212,569 width=0) (actual rows= loops=)

15. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on ix_1596545519961_closedate_00di0000000bkfqeau_opportunity_revis (cost=0.00..13,486.92 rows=643,049 width=0) (actual rows= loops=)

  • Index Cond: ((closedate >= '2020-07-01'::date) AND (closedate <= '2020-09-30'::date))
16. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on ix_1596545519961_end_date_00di0000000bkfqeau_opportunity_revisi (cost=0.00..33,456.33 rows=1,811,187 width=0) (actual rows= loops=)

  • Index Cond: (end_date > '2020-07-28 07:00:00+00'::timestamp with time zone)
17. 0.000 0.000 ↓ 0.0

Unique (cost=93.15..93.18 rows=7 width=4) (actual rows= loops=)

18. 0.000 0.000 ↓ 0.0

Sort (cost=93.15..93.17 rows=7 width=4) (actual rows= loops=)

  • Sort Key: start_table.closedate
19. 0.000 0.000 ↓ 0.0

Index Scan using ix_1596545519962_id_00di0000000bkfqeau_opportunity_revision on m_00di0000000bkfqeau_opportunity_revision start_table (cost=0.56..93.05 rows=7 width=4) (actual rows= loops=)

  • Index Cond: (id = parent.id)
  • Filter: ((start_date <= '2020-07-28 07:00:00+00'::timestamp with time zone) AND (end_date > '2020-07-28 07:00:00+00'::timestamp with time zone))
20. 0.000 0.000 ↓ 0.0

Unique (cost=93.15..93.18 rows=7 width=4) (actual rows= loops=)

21. 0.000 0.000 ↓ 0.0

Sort (cost=93.15..93.17 rows=7 width=4) (actual rows= loops=)

  • Sort Key: start_table_1.closedate
22. 0.000 0.000 ↓ 0.0

Index Scan using ix_1596545519962_id_00di0000000bkfqeau_opportunity_revision on m_00di0000000bkfqeau_opportunity_revision start_table_1 (cost=0.56..93.05 rows=7 width=4) (actual rows= loops=)

  • Index Cond: (id = parent.id)
  • Filter: ((start_date <= '2020-07-28 07:00:00+00'::timestamp with time zone) AND (end_date > '2020-07-28 07:00:00+00'::timestamp with time zone))