explain.depesz.com

PostgreSQL's explain analyze made readable

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

Settings

Optimization path:

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 0.002 2.225 ↑ 1.0 1 1

Nested Loop Left Join (cost=42.91..45.49 rows=1 width=4) (actual time=2.223..2.225 rows=1 loops=1)

2. 0.004 2.213 ↑ 1.0 1 1

Nested Loop (cost=42.49..44.04 rows=1 width=4) (actual time=2.212..2.213 rows=1 loops=1)

3. 0.006 2.202 ↑ 1.0 1 1

Nested Loop (cost=42.35..43.88 rows=1 width=8) (actual time=2.202..2.202 rows=1 loops=1)

4. 0.018 2.182 ↑ 1.0 1 1

Bitmap Heap Scan on member (cost=42.06..42.58 rows=1 width=8) (actual time=2.182..2.182 rows=1 loops=1)

  • Recheck Cond: (((last_name)::text ~~* '%Aaron%'::text) AND ((first_name)::text ~~* '%Elizabeth%'::text))
  • Heap Blocks: exact=1
5. 0.008 2.164 ↓ 0.0 0 1

BitmapAnd (cost=42.06..42.06 rows=1 width=0) (actual time=2.164..2.164 rows=0 loops=1)

6. 0.191 0.191 ↑ 1.2 59 1

Bitmap Index Scan on member__last_name_gin (cost=0.00..5.55 rows=73 width=0) (actual time=0.191..0.191 rows=59 loops=1)

  • Index Cond: ((last_name)::text ~~* '%Aaron%'::text)
7. 1.965 1.965 ↓ 1.1 4,302 1

Bitmap Index Scan on member__first_name_gin (cost=0.00..36.26 rows=3,768 width=0) (actual time=1.965..1.965 rows=4,302 loops=1)

  • Index Cond: ((first_name)::text ~~* '%Elizabeth%'::text)
8. 0.014 0.014 ↑ 1.0 1 1

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

  • Index Cond: (employer_id = member.employer_id)
9. 0.007 0.007 ↑ 1.0 1 1

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

  • Index Cond: (tenant_id = employer.tenant_id)
  • Heap Fetches: 1
10. 0.010 0.010 ↓ 0.0 0 1

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

  • Index Cond: (member_id = member.id)
  • Heap Fetches: 0
Planning time : 1.704 ms
Execution time : 2.358 ms