explain.depesz.com

PostgreSQL's explain analyze made readable

Result: D0x4

Settings
# exclusive inclusive rows x rows loops node
1. 0.005 0.141 ↓ 0.0 0 1

Update on common_entities_driver (cost=9.43..13.49 rows=1 width=198) (actual time=0.141..0.141 rows=0 loops=1)

  • Buffers: shared hit=3 read=2
2. 0.001 0.136 ↓ 0.0 0 1

Nested Loop (cost=9.43..13.49 rows=1 width=198) (actual time=0.136..0.136 rows=0 loops=1)

  • Buffers: shared hit=3 read=2
3. 0.001 0.135 ↓ 0.0 0 1

Unique (cost=9.15..9.16 rows=1 width=28) (actual time=0.135..0.135 rows=0 loops=1)

  • Buffers: shared hit=3 read=2
4. 0.067 0.134 ↓ 0.0 0 1

Sort (cost=9.15..9.16 rows=1 width=28) (actual time=0.134..0.134 rows=0 loops=1)

  • Sort Key: driver.sid
  • Sort Method: quicksort Memory: 25kB
  • Buffers: shared hit=3 read=2
5. 0.001 0.067 ↓ 0.0 0 1

Nested Loop (cost=0.56..9.14 rows=1 width=28) (actual time=0.067..0.067 rows=0 loops=1)

  • Buffers: shared read=2
6. 0.066 0.066 ↓ 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=14) (actual time=0.066..0.066 rows=0 loops=1)

  • Index Cond: (upper((driver_id)::text) = 'ALV01'::text)
  • Filter: (NOT mark_for_delete)
  • Buffers: shared read=2
7. 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)
8. 0.000 0.000 ↓ 0.0 0

Index Scan using pk_common_entities_driver on common_entities_driver (cost=0.28..4.32 rows=1 width=166) (never executed)

  • Index Cond: (sid = driver.sid)
Planning time : 4.068 ms