explain.depesz.com

PostgreSQL's explain analyze made readable

Result: xqbW

Settings
# exclusive inclusive rows x rows loops node
1. 2.031 45.411 ↓ 1.0 12,585 1

Bitmap Heap Scan on universe_assets ua (cost=20,228.04..31,854.29 rows=12,243 width=34) (actual time=43.422..45.411 rows=12,585 loops=1)

  • Recheck Cond: (universe_id = 169)
  • Heap Blocks: exact=453
2. 43.380 43.380 ↓ 1.0 12,585 1

Bitmap Index Scan on idx_universe_assets_inputid_organization_universeid (cost=0.00..20,224.98 rows=12,243 width=0) (actual time=43.380..43.380 rows=12,585 loops=1)

  • Index Cond: (universe_id = 169)