explain.depesz.com

PostgreSQL's explain analyze made readable

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

Settings

Optimization path:

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

Limit (cost=290,292.23..495,419.55 rows=1 width=72) (actual time=1,117.189..1,117.189 rows=0 loops=1)

2. 8.370 1,120.876 ↓ 0.0 0 1

Gather (cost=290,292.23..495,419.55 rows=1 width=72) (actual time=1,117.187..1,120.876 rows=0 loops=1)

  • Workers Planned: 4
  • Workers Launched: 4
3. 0.001 1,112.506 ↓ 0.0 0 5 / 5

Nested Loop Left Join (cost=289,292.23..494,419.45 rows=1 width=72) (actual time=1,112.506..1,112.506 rows=0 loops=5)

  • Filter: (issue.id IS NULL)
4. 889.565 1,112.505 ↓ 0.0 0 5 / 5

Parallel Bitmap Heap Scan on listings li (cost=289,291.80..447,149.33 rows=12,522 width=72) (actual time=1,112.505..1,112.505 rows=0 loops=5)

  • Recheck Cond: ((account_id = 61,751) AND (site = 'AU'::ebaysite) AND (""group"" = 'test'::listinggroup) AND (status = 'active'::listingstatus) AND (ebay_recommended_rate IS NOT NULL) AND (campaign_id IS NULL))
5. 4.870 222.940 ↓ 0.0 0 1 / 5

BitmapAnd (cost=289,291.80..289,291.80 rows=50,088 width=0) (actual time=1,114.702..1,114.702 rows=0 loops=1)

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

  • Index Cond: (account_id = 61,751)
7. 87.794 87.794 ↓ 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=438.972..438.972 rows=6,143,378 loops=1)

  • Index Cond: (site = 'AU'::ebaysite)
8. 96.855 96.855 ↑ 2.7 5,353,249 1 / 5

Bitmap Index Scan on listings_to_promote_query_2_idx (cost=0.00..133,086.80 rows=14,648,713 width=0) (actual time=484.277..484.277 rows=5,353,249 loops=1)

9. 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.460 ms
Execution time : 1,120.926 ms