explain.depesz.com

PostgreSQL's explain analyze made readable

Result: hhST : Optimization for: plan #8mgT

Settings

Optimization path:

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 0.001 0.054 ↓ 0.0 0 1

Update on common_entities_driver driver (cost=0.56..9.15 rows=1 width=192) (actual time=0.054..0.054 rows=0 loops=1)

  • Buffers: shared read=2
2. 0.002 0.053 ↓ 0.0 0 1

Nested Loop (cost=0.56..9.15 rows=1 width=192) (actual time=0.052..0.053 rows=0 loops=1)

  • Buffers: shared read=2
3. 0.051 0.051 ↓ 0.0 0 1

Index Scan using ix_common_entities_driver_03 on common_entities_driver driver (cost=0.28..4.32 rows=1 width=166) (actual time=0.051..0.051 rows=0 loops=1)

  • Index Cond: (upper((driver_id)::text) = 'ALV01'::text)
  • Filter: (NOT mark_for_delete)
  • Buffers: shared read=2
4. 0.000 0.000 ↓ 0.0 0

Index Scan using pk_security_base_account on security_base_account base_account (cost=0.28..4.32 rows=1 width=14) (never executed)

  • Index Cond: (sid = driver.sid)
  • Filter: ((company_identity)::text = '7cf93766-82ef-445e-b175-24c3e43c29e4'::text)
Planning time : 1.013 ms
Execution time : 0.473 ms