explain.depesz.com

PostgreSQL's explain analyze made readable

Result: a4xQ

Settings
# exclusive inclusive rows x rows loops node
1. 11.203 288.328 ↓ 1.6 1,985 1

Nested Loop (cost=15,613.60..103,172.92 rows=1,219 width=8) (actual time=148.681..288.328 rows=1,985 loops=1)

2. 54.019 200.930 ↓ 1.7 15,239 1

Bitmap Heap Scan on listings_shopgoodwill (cost=15,613.17..47,301.84 rows=9,008 width=16) (actual time=148.557..200.930 rows=15,239 loops=1)

  • Recheck Cond: ((payment_deadline > now()) AND (bid_count > 0) AND ((state)::text = ANY ('{EXPIRED,SOLD}'::text[])))
  • Rows Removed by Index Recheck: 2973
  • Heap Blocks: exact=12352
3. 3.192 146.911 ↓ 0.0 0 1

BitmapAnd (cost=15,613.17..15,613.17 rows=9,008 width=0) (actual time=146.911..146.911 rows=0 loops=1)

4. 5.646 5.646 ↓ 1.2 26,257 1

Bitmap Index Scan on index_listings_shopgoodwill_on_payment_deadline (cost=0.00..422.23 rows=22,640 width=0) (actual time=5.646..5.646 rows=26,257 loops=1)

  • Index Cond: (payment_deadline > now())
5. 138.073 138.073 ↓ 1.0 913,520 1

Bitmap Index Scan on index_listings_shopgoodwill_on_state (cost=0.00..15,186.19 rows=906,844 width=0) (actual time=138.073..138.073 rows=913,520 loops=1)

  • Index Cond: ((state)::text = ANY ('{EXPIRED,SOLD}'::text[]))
6. 76.195 76.195 ↓ 0.0 0 15,239

Index Scan using products_pkey on products (cost=0.43..6.20 rows=1 width=8) (actual time=0.005..0.005 rows=0 loops=15,239)

  • Index Cond: (id = listings_shopgoodwill.product_id)
  • Filter: (organization_id = 3)
  • Rows Removed by Filter: 1
Planning time : 0.480 ms
Execution time : 288.520 ms