explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Pr39

Settings
# exclusive inclusive rows x rows loops node
1. 13,200.948 13,381.536 ↑ 1.8 37,376 1

Bitmap Heap Scan on "knowledge-elements" (cost=1,479.48..238,539.24 rows=67,989 width=81) (actual time=189.756..13,381.536 rows=37,376 loops=1)

  • Recheck Cond: ("userId" = 268242)
  • Heap Blocks: exact=28524
2. 180.588 180.588 ↓ 1.1 72,416 1

Bitmap Index Scan on knowledge_elements_userid_index (cost=0.00..1,462.49 rows=67,989 width=0) (actual time=180.588..180.588 rows=72,416 loops=1)

  • Index Cond: ("userId" = 268242)