explain.depesz.com

PostgreSQL's explain analyze made readable

Result: f17Q

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

Aggregate (cost=2,280.41..2,280.42 rows=1 width=4) (actual time=0.447..0.448 rows=1 loops=1)

2. 0.372 0.440 ↑ 14.0 1 1

Bitmap Heap Scan on cp_version cv (cost=13.20..2,280.38 rows=14 width=4) (actual time=0.439..0.440 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.068 0.068 ↑ 7.1 89 1

Bitmap Index Scan on unique_version_on_server (cost=0.00..13.20 rows=636 width=0) (actual time=0.068..0.068 rows=89 loops=1)

  • Index Cond: (mgmt_id = 2145)
Planning time : 1.076 ms
Execution time : 0.598 ms