explain.depesz.com

PostgreSQL's explain analyze made readable

Result: f2kr

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

Limit (cost=20.12..20.13 rows=3 width=1,131) (actual rows= loops=)

2. 0.000 0.000 ↓ 0.0

Sort (cost=20.12..20.13 rows=3 width=1,131) (actual rows= loops=)

  • Sort Key: bid_create_time DESC
3. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on bid_bids (cost=8.59..20.10 rows=3 width=1,131) (actual rows= loops=)

  • Recheck Cond: (bid_sav_available_service_pk = ANY ('{289093721419669545,289094140380487721}'::bigint[]))
  • Filter: ((COALESCE(bid_flags, 0) & 0) <> 0)
4. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on bid_sav_pk_create_time_index (cost=0.00..8.59 rows=3 width=0) (actual rows= loops=)

  • Index Cond: (bid_sav_available_service_pk = ANY ('{289093721419669545,289094140380487721}'::bigint[]))