explain.depesz.com

PostgreSQL's explain analyze made readable

Result: TY6e

Settings
# exclusive inclusive rows x rows loops node
1. 16.102 1,109.150 ↑ 1.0 1 1

Aggregate (cost=188,196.41..188,196.42 rows=1 width=0) (actual time=1,109.149..1,109.150 rows=1 loops=1)

2. 864.015 1,093.048 ↑ 1.0 332,813 1

Bitmap Heap Scan on purchase (cost=62,066.98..187,350.98 rows=338,173 width=0) (actual time=235.196..1,093.048 rows=332,813 loops=1)

  • Recheck Cond: (account_id = 1)
  • Rows Removed by Index Recheck: 4219293
  • Filter: favorite
  • Rows Removed by Filter: 3001198
  • Heap Blocks: exact=30596 lossy=52738
3. 229.033 229.033 ↑ 1.0 3,334,011 1

Bitmap Index Scan on ix_purchase_account (cost=0.00..61,982.43 rows=3,356,000 width=0) (actual time=229.033..229.033 rows=3,334,011 loops=1)

  • Index Cond: (account_id = 1)