explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Ryur

Settings
# exclusive inclusive rows x rows loops node
1. 0.003 0.252 ↑ 1.0 1 1

Aggregate (cost=176.97..176.98 rows=1 width=8) (actual time=0.252..0.252 rows=1 loops=1)

  • Buffers: shared hit=155
2. 0.018 0.249 ↑ 2.4 36 1

Nested Loop (cost=0.86..176.75 rows=87 width=0) (actual time=0.035..0.249 rows=36 loops=1)

  • Buffers: shared hit=155
3. 0.123 0.123 ↑ 2.4 36 1

Index Only Scan using users_pkey on users users_1 (cost=0.43..4.95 rows=87 width=4) (actual time=0.029..0.123 rows=36 loops=1)

  • Index Cond: (id < 100)
  • Heap Fetches: 0
4. 0.108 0.108 ↑ 1.0 1 36

Index Only Scan using users_pkey on users (cost=0.43..1.96 rows=1 width=4) (actual time=0.003..0.003 rows=1 loops=36)

  • Index Cond: (id = users_1.id)
  • Heap Fetches: 0