explain.depesz.com

PostgreSQL's explain analyze made readable

Result: O10y : hey

Settings
# exclusive inclusive rows x rows loops node
1. 4,638.945 7,658.198 ↑ 1.0 1 1

Aggregate (cost=953,233.06..953,233.07 rows=1 width=4) (actual time=7,658.198..7,658.198 rows=1 loops=1)

2. 853.112 3,019.253 ↓ 4.2 6,110,334 1

Nested Loop (cost=0.84..949,618.69 rows=1,445,745 width=4) (actual time=0.024..3,019.253 rows=6,110,334 loops=1)

3. 0.069 0.069 ↑ 1.0 136 1

Index Scan using link_user_idx on links l (cost=0.28..235.93 rows=136 width=4) (actual time=0.013..0.069 rows=136 loops=1)

  • Index Cond: (user_id = 1125)
4. 2,166.072 2,166.072 ↓ 1.8 44,929 136

Index Scan using click_link_idx on clicks c (cost=0.56..6,732.74 rows=24,802 width=12) (actual time=0.002..15.927 rows=44,929 loops=136)

  • Index Cond: (link_id = l.id)