explain.depesz.com

PostgreSQL's explain analyze made readable

Result: YM5R

Settings

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 347.425 2,056.945 ↑ 1.1 12,258 1

Bitmap Heap Scan on listings (cost=205,302.45..394,458.99 rows=13,215 width=72) (actual time=1,711.180..2,056.945 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.451 1,709.520 ↓ 0.0 0 1

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

3. 57.343 57.343 ↑ 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=57.343..57.343 rows=355,014 loops=1)

  • Index Cond: (account_id = 37,508)
4. 1,643.726 1,643.726 ↑ 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=1,643.726..1,643.726 rows=10,712,382 loops=1)

  • Index Cond: (site = 'IT'::ebaysite)
Planning time : 4.007 ms
Execution time : 2,057.647 ms