explain.depesz.com

PostgreSQL's explain analyze made readable

Result: tfiD

Settings
# exclusive inclusive rows x rows loops node
1. 1.222 3.455 ↑ 1.0 1 1

Aggregate (cost=2,306.56..2,306.58 rows=1 width=28) (actual time=3.455..3.455 rows=1 loops=1)

2. 2.063 2.233 ↓ 5.5 3,702 1

Bitmap Heap Scan on words_scores (cost=13.69..2,270.91 rows=679 width=7) (actual time=0.203..2.233 rows=3,702 loops=1)

  • Recheck Cond: (uid = 5)
  • Heap Blocks: exact=419
3. 0.170 0.170 ↓ 5.5 3,702 1

Bitmap Index Scan on words_scores_uid_idx (cost=0.00..13.52 rows=679 width=0) (actual time=0.170..0.170 rows=3,702 loops=1)

  • Index Cond: (uid = 5)