explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 4Vnc

Settings
# exclusive inclusive rows x rows loops node
1. 1.159 100.486 ↑ 1.0 1 1

Aggregate (cost=38,043.75..38,043.78 rows=1 width=28) (actual time=100.486..100.486 rows=1 loops=1)

2. 99.327 99.327 ↓ 5.5 3,702 1

Seq Scan on words_scores (cost=0.00..38,008.10 rows=679 width=7) (actual time=0.572..99.327 rows=3,702 loops=1)

  • Filter: (uid = 5)
  • Rows Removed by Filter: 1785195