explain.depesz.com

PostgreSQL's explain analyze made readable

Result: RvpD

Settings
# exclusive inclusive rows x rows loops node
1. 5.571 6.949 ↓ 1.0 11,248 1

Bitmap Heap Scan on bs_positions (cost=362.85..2,220.46 rows=11,169 width=402) (actual time=1.553..6.949 rows=11,248 loops=1)

  • Recheck Cond: (contragents_registry_id = 92,190)
  • Heap Blocks: exact=519
2. 1.378 1.378 ↓ 1.0 11,248 1

Bitmap Index Scan on bs_positions_contragents_registry_id_has_bs_idx (cost=0.00..360.06 rows=11,169 width=0) (actual time=1.378..1.378 rows=11,248 loops=1)

  • Index Cond: (contragents_registry_id = 92,190)