explain.depesz.com

PostgreSQL's explain analyze made readable

Result: AA1f

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

Nested Loop (cost=0.55..16.60 rows=1 width=4) (actual time=0.006..0.006 rows=0 loops=1)

2. 0.005 0.005 ↓ 0.0 0 1

Index Scan using objects_pkey on objects (cost=0.28..8.30 rows=1 width=8) (actual time=0.005..0.005 rows=0 loops=1)

  • Index Cond: ((object_id)::integer = 713)
3. 0.000 0.000 ↓ 0.0 0

Index Only Scan using usr_pkey on usr (cost=0.27..8.29 rows=1 width=4) (never executed)

  • Index Cond: (object_id = 713)
  • Heap Fetches: 0