explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 6VSX

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.85..16.90 rows=1 width=18) (actual rows= loops=)

2. 0.000 0.000 ↓ 0.0

Index Scan using idx_test_id2 on test t (cost=0.43..8.45 rows=1 width=9) (actual rows= loops=)

  • Index Cond: (id = 23456)
  • Filter: (name = 'Karl'::text)
3. 0.000 0.000 ↓ 0.0

Index Scan using idx_rand_id on rand r (cost=0.43..8.45 rows=1 width=9) (actual rows= loops=)

  • Index Cond: (id = 23456)