explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 3kwP

Settings

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 0.019 2.228 ↓ 2.8 11 1

Seq Scan on offices (cost=356.66..357.77 rows=4 width=334) (actual time=2.224..2.228 rows=11 loops=1)

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

SubPlan (for Seq Scan)

3. 0.004 2.209 ↓ 0.0 0 1

Nested Loop Semi Join (cost=0.42..356.66 rows=1 width=4) (actual time=2.209..2.209 rows=0 loops=1)

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

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

5. 0.006 2.200 ↓ 0.0 0 11

Materialize (cost=0.42..355.43 rows=1 width=4) (actual time=0.200..0.200 rows=0 loops=11)

6. 0.000 2.194 ↓ 0.0 0 1

Nested Loop (cost=0.42..355.43 rows=1 width=4) (actual time=2.194..2.194 rows=0 loops=1)

7. 2.194 2.194 ↓ 0.0 0 1

Seq Scan on consultants (cost=0.00..346.99 rows=1 width=8) (actual time=2.194..2.194 rows=0 loops=1)

  • Filter: ((grade)::text = 'FT'::text)
  • Rows Removed by Filter: 11599
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 : 0.733 ms
Execution time : 2.319 ms