explain.depesz.com

PostgreSQL's explain analyze made readable

Result: z58L

Settings
# exclusive inclusive rows x rows loops node
1. 0.044 12.035 ↑ 1.0 1 1

Nested Loop (cost=0.86..8.91 rows=1 width=2,649) (actual time=12.033..12.035 rows=1 loops=1)

  • Buffers: shared hit=1 read=7
2. 6.690 6.690 ↑ 1.0 1 1

Index Scan using keys_pkey on public.keys (cost=0.43..4.45 rows=1 width=4) (actual time=6.689..6.690 rows=1 loops=1)

  • Index Cond: (keys.id = 1755060)
  • Buffers: shared read=4
3. 5.301 5.301 ↑ 1.0 1 1

Index Scan using users_pkey on public.users (cost=0.43..4.45 rows=1 width=2,649) (actual time=5.300..5.301 rows=1 loops=1)

  • Index Cond: (users.id = keys.user_id)
  • Buffers: shared hit=1 read=3