explain.depesz.com

PostgreSQL's explain analyze made readable

Result: jFrM

Settings
# exclusive inclusive rows x rows loops node
1. 0.216 3,012.118 ↑ 1.0 1 1

Aggregate (cost=82,307.58..82,307.59 rows=1 width=8) (actual time=3,012.118..3,012.118 rows=1 loops=1)

2. 0.227 3,011.902 ↑ 183,571.7 70 1

Nested Loop (cost=1,340.96..50,182.54 rows=12,850,019 width=16) (actual time=1,316.426..3,011.902 rows=70 loops=1)

  • Join Filter: (m.event_uuid = e.event_uuid)
3. 0.248 2,738.675 ↑ 1,003.9 70 1

Hash Join (cost=1,340.54..4,683.26 rows=70,271 width=32) (actual time=1,316.344..2,738.675 rows=70 loops=1)

  • Hash Cond: (ns.event_uuid = m.event_uuid)
4. 0.488 2,675.262 ↑ 312.2 70 1

Nested Loop (cost=1.11..837.92 rows=21,857 width=16) (actual time=1,253.152..2,675.262 rows=70 loops=1)

5. 50.537 50.537 ↓ 173.0 173 1

Index Scan using groups_org_part_default_pkey on groups_org_part_default gr (cost=0.55..226.17 rows=1 width=16) (actual time=6.398..50.537 rows=173 loops=1)

  • Index Cond: (organization_uuid = 'd528beb8-98bf-4d4a-b93a-5333bc759185'::uuid)
  • Filter: ((target_name)::text ~~ '%OnCall%'::text)
  • Rows Removed by Filter: 530
6. 2,624.237 2,624.237 ↓ 0.0 0 173

Index Scan using notifications_summary_partitioned_recipient_only_idx on notifications_summary_weekly_partitioned_2019_w40 ns (cost=0.56..611.01 rows=74 width=32) (actual time=13.380..15.169 rows=0 loops=173)

  • Index Cond: (recipient_uuid = gr.group_uuid)
  • Filter: ((created_date >= '2019-10-01 00:00:00-07'::timestamp with time zone) AND (created_date <= '2019-10-02 00:00:00-07'::timestamp with time zone))
  • Rows Removed by Filter: 6
7. 0.222 63.165 ↑ 1.2 537 1

Hash (cost=1,331.39..1,331.39 rows=643 width=16) (actual time=63.164..63.165 rows=537 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 34kB
8. 62.943 62.943 ↑ 1.2 537 1

Index Scan using messages_org_part_25_event_created_idx on messages_org_part_25 m (cost=0.42..1,331.39 rows=643 width=16) (actual time=30.188..62.943 rows=537 loops=1)

  • Index Cond: ((event_created >= '2019-10-01 00:00:00-07'::timestamp with time zone) AND (event_created <= '2019-10-02 00:00:00-07'::timestamp with time zone))
  • Filter: (((subject)::text ~~ '%ACT%'::text) AND (organization_uuid = 'd528beb8-98bf-4d4a-b93a-5333bc759185'::uuid))
  • Rows Removed by Filter: 1086
9. 273.000 273.000 ↑ 1.0 1 70

Index Scan using events_org_part_25_event_uuid_idx1 on events_org_part_25 e (cost=0.42..0.63 rows=1 width=16) (actual time=3.821..3.900 rows=1 loops=70)

  • Index Cond: (event_uuid = ns.event_uuid)
  • Filter: ((created >= '2019-10-01 00:00:00-07'::timestamp with time zone) AND (created <= '2019-10-31 00:00:00-07'::timestamp with time zone) AND (organization_uuid = 'd528beb8-98bf-4d4a-b93a-5333bc759185'::uuid) AND ((status)::text = 'ACTIVE'::text))
  • Rows Removed by Filter: 1
Planning time : 2.258 ms
Execution time : 3,012.327 ms