explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Up22 : Optimization for: Optimization for: plan #xgHE - adds index on vendor_member.member_id; plan #WjD7

Settings

Optimization path:

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 39.987 1,423.958 ↑ 45.0 1 1

Gather (cost=1,001.27..20,629.53 rows=45 width=4) (actual time=681.787..1,423.958 rows=1 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
2. 0.002 1,383.971 ↓ 0.0 0 3 / 3

Nested Loop Left Join (cost=1.27..19,625.03 rows=19 width=4) (actual time=1,146.113..1,383.971 rows=0 loops=3)

3. 0.002 1,383.896 ↓ 0.0 0 3 / 3

Nested Loop (cost=0.85..19,598.35 rows=19 width=4) (actual time=1,146.039..1,383.896 rows=0 loops=3)

4. 0.004 1,383.890 ↓ 0.0 0 3 / 3

Nested Loop (cost=0.71..19,595.31 rows=19 width=8) (actual time=1,146.033..1,383.890 rows=0 loops=3)

5. 1,383.865 1,383.865 ↓ 0.0 0 3 / 3

Parallel Index Scan using member_employer_id on member (cost=0.42..19,573.09 rows=20 width=8) (actual time=1,146.008..1,383.865 rows=0 loops=3)

  • Filter: ((deleted IS FALSE) AND (archived IS FALSE) AND (((email)::text ~~* '%Elizabeth Aaron%'::text) OR (((first_name)::text ~~* '%Elizabeth%'::text) AND ((last_name)::text ~~* '%Aaron%'::text))))
  • Rows Removed by Filter: 280,909
6. 0.021 0.021 ↑ 1.0 1 1 / 3

Index Scan using employer_pkey on employer (cost=0.29..1.11 rows=1 width=8) (actual time=0.063..0.063 rows=1 loops=1)

  • Index Cond: (employer_id = member.employer_id)
  • Filter: (archived IS FALSE)
7. 0.004 0.004 ↑ 1.0 1 1 / 3

Index Only Scan using uq_tenant_tenant_id_wex_key on tenant (cost=0.14..0.16 rows=1 width=4) (actual time=0.011..0.012 rows=1 loops=1)

  • Index Cond: (tenant_id = employer.tenant_id)
  • Heap Fetches: 1
8. 0.073 0.073 ↓ 0.0 0 1 / 3

Index Only Scan using vendor_member__member_id on vendor_member (cost=0.42..1.39 rows=1 width=4) (actual time=0.219..0.219 rows=0 loops=1)

  • Index Cond: (member_id = member.id)
  • Heap Fetches: 0
Planning time : 2.076 ms
Execution time : 1,424.108 ms