explain.depesz.com

PostgreSQL's explain analyze made readable

Result: v85h

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

Aggregate (cost=843.20..843.21 rows=1 width=32) (actual rows= loops=)

  • -> Nested Loop (cost=0.85..842.96*_ rows_**_=_**_99_* width=33)
  • -> Index Scan using t1_clus on t1 (cost=0.42..10.16 *_rows_**_=_**_99_* width=37)
  • Index Cond: (clus = 1)
2. 0.000 0.000 ↓ 0.0

Index Only Scan using t2_id on t2 (cost=0.42..8.40 rows=1 width=4) (actual rows= loops=)

  • Index Cond: (id = t1.id)