explain.depesz.com

PostgreSQL's explain analyze made readable

Result: SfdG : Optimization for: plan #YM5R

Settings

Optimization path:

# exclusive inclusive rows x rows loops node
1. 22.935 655.243 ↑ 1.1 12,258 1

Bitmap Heap Scan on listings (cost=205,286.38..394,412.39 rows=13,212 width=72) (actual time=633.791..655.243 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. 7.334 632.308 ↓ 0.0 0 1

BitmapAnd (cost=205,286.38..205,286.38 rows=61,649 width=0) (actual time=632.308..632.308 rows=0 loops=1)

3. 19.709 19.709 ↑ 1.1 355,014 1

Bitmap Index Scan on listings_account_id_idx (cost=0.00..6,912.89 rows=373,910 width=0) (actual time=19.709..19.709 rows=355,014 loops=1)

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

Bitmap Index Scan on listings_site_idx (cost=0.00..198,366.63 rows=10,732,009 width=0) (actual time=605.265..605.265 rows=10,712,382 loops=1)

  • Index Cond: (site = 'IT'::ebaysite)
Planning time : 0.131 ms
Execution time : 655.899 ms