explain.depesz.com

PostgreSQL's explain analyze made readable

Result: symE

Settings
# exclusive inclusive rows x rows loops node
1. 178.220 110,706.016 ↑ 1.0 1 1

Aggregate (cost=1,610,931.76..1,610,931.77 rows=1 width=8) (actual time=110,706.016..110,706.016 rows=1 loops=1)

2. 1,463.514 110,527.796 ↓ 3.0 2,734,747 1

Unique (cost=1,535,386.26..1,599,485.47 rows=915,703 width=973) (actual time=108,024.879..110,527.796 rows=2,734,747 loops=1)

3. 7,112.692 109,064.282 ↓ 3.0 2,734,747 1

Sort (cost=1,535,386.26..1,537,675.52 rows=915,703 width=973) (actual time=108,024.875..109,064.282 rows=2,734,747 loops=1)

  • Sort Key: e.event_uuid, e.event_id, e.submitter_uuid, e.priority, e.incident_id, e.override_device_restrictions, e.escalation_override, e.bypass_phone_intro, e.require_phone_password, e.conference_properties, e.created, e.status, e.terminated, e.request_uuid, e.sequence, e.revision_uuid, e.event_type, e.system_event_type, e.form_uuid, e.plan_uuid, e.choices, (lower(e.valid_range)), (upper(e.valid_range)), e.recipients, pl.name, pl.integration_config_type, pl.icon_override
  • Sort Method: external merge Disk: 1,071,408kB
4. 8,703.049 101,951.590 ↓ 3.0 2,734,747 1

Gather (cost=718,042.27..941,696.47 rows=915,703 width=973) (actual time=2,834.124..101,951.590 rows=2,734,747 loops=1)

  • Workers Planned: 4
  • Workers Launched: 4
5. 69,815.007 93,248.541 ↓ 2.4 546,949 5 / 5

Merge Left Join (cost=717,042.27..849,126.17 rows=228,926 width=973) (actual time=2,825.040..93,248.541 rows=546,949 loops=5)

  • Merge Cond: (e.plan_uuid = pl.plan_uuid)
  • Join Filter: (pl.valid_range @> e.created)
  • Rows Removed by Join Filter: 367,499,299
6. 1,664.866 2,533.916 ↓ 2.4 546,949 5 / 5

Sort (cost=624,036.96..624,609.27 rows=228,925 width=940) (actual time=2,151.469..2,533.916 rows=546,949 loops=5)

  • Sort Key: e.plan_uuid
  • Sort Method: external merge Disk: 216,296kB
  • Worker 0: Sort Method: external merge Disk: 193,488kB
  • Worker 1: Sort Method: external merge Disk: 227,200kB
  • Worker 2: Sort Method: external merge Disk: 222,232kB
  • Worker 3: Sort Method: external merge Disk: 176,576kB
7. 64.222 869.050 ↓ 2.4 546,949 5 / 5

Parallel Append (cost=0.00..542,792.71 rows=228,925 width=940) (actual time=0.042..869.050 rows=546,949 loops=5)

  • Subplans Removed: 2
8. 216.535 216.535 ↓ 6.0 215,990 2 / 5

Parallel Index Scan using events_org_part_199_l3_t_202007_created_idx on events_org_part_199_l3_t_202007 e (cost=0.43..107,947.12 rows=36,234 width=937) (actual time=0.050..541.337 rows=215,990 loops=2)

  • Index Cond: ((created >= '2020-07-17 16:49:36+00'::timestamp with time zone) AND (created <= now()))
  • Filter: (upper_inf(valid_range) AND (organization_uuid = 'fcb0b139-ed68-4220-a7a6-7e56e8214519'::uuid))
9. 241.544 241.544 ↓ 2.4 192,341 5 / 5

Parallel Seq Scan on events_org_part_199_l3_t_202009 e_2 (cost=0.00..184,098.92 rows=80,088 width=941) (actual time=0.062..241.544 rows=192,341 loops=5)

  • Filter: (upper_inf(valid_range) AND (created >= '2020-07-17 16:49:36+00'::timestamp with time zone) AND (organization_uuid = 'fcb0b139-ed68-4220-a7a6-7e56e8214519'::uuid) AND (created <= now()))
10. 208.985 208.985 ↓ 4.0 297,070 3 / 5

Parallel Seq Scan on events_org_part_199_l3_t_202008 e_1 (cost=0.00..162,715.22 rows=74,181 width=942) (actual time=0.061..348.308 rows=297,070 loops=3)

  • Filter: (upper_inf(valid_range) AND (created >= '2020-07-17 16:49:36+00'::timestamp with time zone) AND (organization_uuid = 'fcb0b139-ed68-4220-a7a6-7e56e8214519'::uuid) AND (created <= now()))
11. 137.765 137.765 ↓ 5.9 224,926 2 / 5

Parallel Seq Scan on events_org_part_199_l3_t_202010 e_3 (cost=0.00..86,880.50 rows=38,422 width=935) (actual time=0.019..344.412 rows=224,926 loops=2)

  • Filter: (upper_inf(valid_range) AND (created >= '2020-07-17 16:49:36+00'::timestamp with time zone) AND (organization_uuid = 'fcb0b139-ed68-4220-a7a6-7e56e8214519'::uuid) AND (created <= now()))
12. 20,176.371 20,899.618 ↓ 1,406.5 368,252,243 5 / 5

Materialize (cost=93,005.31..94,314.38 rows=261,814 width=69) (actual time=672.480..20,899.618 rows=368,252,243 loops=5)

13. 300.410 723.247 ↓ 1.0 266,988 5 / 5

Sort (cost=93,005.31..93,659.85 rows=261,814 width=69) (actual time=672.472..723.247 rows=266,988 loops=5)

  • Sort Key: pl.plan_uuid
  • Sort Method: external merge Disk: 19,352kB
  • Worker 0: Sort Method: external merge Disk: 19,352kB
  • Worker 1: Sort Method: external merge Disk: 19,352kB
  • Worker 2: Sort Method: external merge Disk: 19,352kB
  • Worker 3: Sort Method: external merge Disk: 19,352kB
14. 396.029 422.837 ↓ 1.0 268,752 5 / 5

Bitmap Heap Scan on plans pl (cost=4,436.43..62,539.18 rows=261,814 width=69) (actual time=32.108..422.837 rows=268,752 loops=5)

  • Recheck Cond: (organization_uuid = 'fcb0b139-ed68-4220-a7a6-7e56e8214519'::uuid)
  • Filter: (is_visible IS TRUE)
  • Rows Removed by Filter: 656
  • Heap Blocks: exact=32,909
15. 26.808 26.808 ↓ 1.0 269,754 5 / 5

Bitmap Index Scan on plans_organization_uuid_idx (cost=0.00..4,370.98 rows=263,740 width=0) (actual time=26.808..26.808 rows=269,754 loops=5)

  • Index Cond: (organization_uuid = 'fcb0b139-ed68-4220-a7a6-7e56e8214519'::uuid)
Planning time : 10.397 ms
Execution time : 111,017.525 ms