explain.depesz.com

PostgreSQL's explain analyze made readable

Result: obXq

Settings
# exclusive inclusive rows x rows loops node
1. 0.002 0.051 ↑ 1.0 10 1

Limit (cost=0.29..23.34 rows=10 width=43) (actual time=0.032..0.051 rows=10 loops=1)

2. 0.010 0.049 ↑ 1,003.4 10 1

Nested Loop (cost=0.29..23,122.22 rows=10,034 width=43) (actual time=0.032..0.049 rows=10 loops=1)

3. 0.019 0.019 ↑ 1,003.4 10 1

Seq Scan on users u (cost=0.00..475.34 rows=10,034 width=22) (actual time=0.018..0.019 rows=10 loops=1)

4. 0.020 0.020 ↑ 1.0 1 10

Index Scan using "PK_clients" on clients c (cost=0.29..2.25 rows=1 width=29) (actual time=0.002..0.002 rows=1 loops=10)

  • Index Cond: (id = (u.id + 1648547))