explain.depesz.com

PostgreSQL's explain analyze made readable

Result: WihM

Settings
# exclusive inclusive rows x rows loops node
1. 0.008 0.451 ↑ 1.0 1 1

Aggregate (cost=2,222.56..2,222.57 rows=1 width=4) (actual time=0.451..0.451 rows=1 loops=1)

2. 0.362 0.443 ↑ 14.0 1 1

Bitmap Heap Scan on cp_version cv (cost=13.06..2,222.52 rows=14 width=4) (actual time=0.443..0.443 rows=1 loops=1)

  • Recheck Cond: (mgmt_id = 2145)
  • Filter: (ready AND ((archive_status)::text <> 'ARCHIVE'::text))
  • Rows Removed by Filter: 88
  • Heap Blocks: exact=46
3. 0.081 0.081 ↑ 6.9 89 1

Bitmap Index Scan on cp_version_mgmt_id_index_tal_shahar (cost=0.00..13.06 rows=618 width=0) (actual time=0.081..0.081 rows=89 loops=1)

  • Index Cond: (mgmt_id = 2145)