explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Y8Gd

Settings
# exclusive inclusive rows x rows loops node
1. 0.396 1.056 ↑ 1.0 5,000 1

Limit (cost=0.00..113.45 rows=5,000 width=8) (actual time=0.009..1.056 rows=5,000 loops=1)

2. 0.660 0.660 ↑ 571.2 5,000 1

Seq Scan on associations ass (cost=0.00..64,799.05 rows=2,855,845 width=8) (actual time=0.008..0.660 rows=5,000 loops=1)

  • Filter: (relation_id = 4)