explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Fh4Y : Optimization for: plan #YM5R

Settings

Optimization path:

# exclusive inclusive rows x rows loops node
1. 24.698 677.011 ↑ 1.1 12,258 1

Bitmap Heap Scan on listings (cost=205,302.45..394,458.99 rows=13,215 width=72) (actual time=654.109..677.011 rows=12,258 loops=1)

  • Recheck Cond: ((account_id = 37,508) AND (site = 'IT'::ebaysite))
  • Filter: ((id >= '293769240977'::bigint) AND (id <= '353180243124'::bigint))
  • Rows Removed by Filter: 72,994
  • Heap Blocks: exact=7,973
2. 8.286 652.313 ↓ 0.0 0 1

BitmapAnd (cost=205,302.45..205,302.45 rows=61,661 width=0) (actual time=652.313..652.313 rows=0 loops=1)

3. 21.847 21.847 ↑ 1.1 355,014 1

Bitmap Index Scan on listings_account_id_idx (cost=0.00..6,913.43 rows=373,982 width=0) (actual time=21.847..21.847 rows=355,014 loops=1)

  • Index Cond: (account_id = 37,508)
4. 622.180 622.180 ↑ 1.0 10,712,382 1

Bitmap Index Scan on listings_site_idx (cost=0.00..198,382.16 rows=10,734,079 width=0) (actual time=622.180..622.180 rows=10,712,382 loops=1)

  • Index Cond: (site = 'IT'::ebaysite)
Planning time : 0.122 ms
Execution time : 677.754 ms