explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 9WfZ : Optimization for: plan #rOKv

Settings

Optimization path:

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 0.000 754.700 ↓ 0.0 0 1

Limit (cost=157,192.65..691,018.07 rows=1 width=72) (actual time=754.700..754.700 rows=0 loops=1)

2. 13.917 761.526 ↓ 0.0 0 1

Gather (cost=157,192.65..691,018.07 rows=1 width=72) (actual time=754.699..761.526 rows=0 loops=1)

  • Workers Planned: 4
  • Workers Launched: 4
3. 0.001 747.609 ↓ 0.0 0 5 / 5

Nested Loop Left Join (cost=156,192.65..690,017.97 rows=1 width=72) (actual time=747.609..747.609 rows=0 loops=5)

  • Filter: (issue.id IS NULL)
4. 620.413 747.608 ↓ 0.0 0 5 / 5

Parallel Bitmap Heap Scan on listings li (cost=156,192.22..642,747.85 rows=12,522 width=72) (actual time=747.608..747.608 rows=0 loops=5)

  • Recheck Cond: ((account_id = 61,751) AND (site = 'AU'::ebaysite))
  • Filter: ((ebay_recommended_rate IS NOT NULL) AND (campaign_id IS NULL) AND (status = 'active'::listingstatus) AND (""group"" = 'test'::listinggroup))
  • Rows Removed by Filter: 66,674
  • Heap Blocks: exact=2,504
5. 3.142 127.195 ↓ 0.0 0 1 / 5

BitmapAnd (cost=156,192.22..156,192.22 rows=222,563 width=0) (actual time=635.973..635.973 rows=0 loops=1)

6. 37.563 37.563 ↑ 1.0 2,313,242 1 / 5

Bitmap Index Scan on listings_account_id_idx (cost=0.00..44,210.48 rows=2,391,722 width=0) (actual time=187.815..187.815 rows=2,313,242 loops=1)

  • Index Cond: (account_id = 61,751)
7. 86.490 86.490 ↓ 1.0 6,143,378 1 / 5

Bitmap Index Scan on listings_site_idx (cost=0.00..111,956.45 rows=6,057,051 width=0) (actual time=432.450..432.450 rows=6,143,378 loops=1)

  • Index Cond: (site = 'AU'::ebaysite)
8. 0.000 0.000 ↓ 0.0 0 / 5

Index Scan using listing_issues_listing_id_idx on listing_issues issue (cost=0.43..3.76 rows=1 width=16) (never executed)

  • Index Cond: (listing_id = li.id)
Planning time : 0.315 ms
Execution time : 761.577 ms