explain.depesz.com

PostgreSQL's explain analyze made readable

Result: gsxz : Optimization for: plan #3kwP

Settings

Optimization path:

# exclusive inclusive rows x rows loops node
1. 0.027 0.090 ↓ 2.8 11 1

Seq Scan on offices (cost=17.97..19.09 rows=4 width=334) (actual time=0.085..0.090 rows=11 loops=1)

  • Filter: (NOT (hashed SubPlan 1))
2.          

SubPlan (for Seq Scan)

3. 0.002 0.063 ↓ 0.0 0 1

Nested Loop Semi Join (cost=0.71..17.97 rows=1 width=4) (actual time=0.063..0.063 rows=0 loops=1)

  • Join Filter: (offices_1.id = consultants.office_id)
4. 0.006 0.006 ↓ 1.2 11 1

Seq Scan on offices offices_1 (cost=0.00..1.09 rows=9 width=4) (actual time=0.003..0.006 rows=11 loops=1)

5. 0.007 0.055 ↓ 0.0 0 11

Materialize (cost=0.71..16.75 rows=1 width=4) (actual time=0.005..0.005 rows=0 loops=11)

6. 0.000 0.048 ↓ 0.0 0 1

Nested Loop (cost=0.71..16.74 rows=1 width=4) (actual time=0.048..0.048 rows=0 loops=1)

7. 0.048 0.048 ↓ 0.0 0 1

Index Scan using index_consultants_on_grade on consultants (cost=0.29..8.30 rows=1 width=8) (actual time=0.048..0.048 rows=0 loops=1)

  • Index Cond: ((grade)::text = 'FT'::text)
8. 0.000 0.000 ↓ 0.0 0

Index Scan using people_pkey on people (cost=0.42..8.44 rows=1 width=4) (never executed)

  • Index Cond: (id = consultants.person_id)
  • Filter: (active AND (NOT partially_deactivated))
Planning time : 1.156 ms
Execution time : 0.173 ms