explain.depesz.com

PostgreSQL's explain analyze made readable

Result: tUoi : Optimization for: Optimization for: plan #rOKv; plan #9WfZ

Settings

Optimization path:

Optimization(s) for this plan:

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

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

2. 16.414 738.445 ↓ 0.0 0 1

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

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

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

  • Filter: (issue.id IS NULL)
4. 605.096 722.030 ↓ 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=722.030..722.030 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=4,812
5. 2.370 116.934 ↓ 0.0 0 1 / 5

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

6. 34.555 34.555 ↑ 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=172.774..172.774 rows=2,313,242 loops=1)

  • Index Cond: (account_id = 61,751)
7. 80.009 80.009 ↓ 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=400.047..400.047 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.356 ms
Execution time : 738.499 ms