explain.depesz.com

PostgreSQL's explain analyze made readable

Result: LjM5e

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 0.000 ↓ 0.0

Aggregate (cost=194,230.01..194,230.02 rows=1 width=8) (actual rows= loops=)

2. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on items (cost=1,735.80..194,104.34 rows=50,266 width=0) (actual rows= loops=)

  • Recheck Cond: ((tenant_id)::text = '578f8652fab5432140d33ccc'::text)
  • Filter: (NOT recommended)
3. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on index_tenant_recommended (cost=0.00..1,723.23 rows=50,266 width=0) (actual rows= loops=)

  • Index Cond: (((tenant_id)::text = '578f8652fab5432140d33ccc'::text) AND (recommended = false))