explain.depesz.com

PostgreSQL's explain analyze made readable

Result: rOKv

Settings

Optimization(s) for this plan:

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

Limit (cost=157,204.88..691,091.27 rows=1 width=72) (actual time=1,588.461..1,588.461 rows=0 loops=1)

2. 10.115 1,592.723 ↓ 0.0 0 1

Gather (cost=157,204.88..691,091.27 rows=1 width=72) (actual time=1,588.459..1,592.723 rows=0 loops=1)

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

Nested Loop Left Join (cost=156,204.88..690,091.17 rows=1 width=72) (actual time=1,582.608..1,582.608 rows=0 loops=5)

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

Parallel Bitmap Heap Scan on listings li (cost=156,204.44..642,817.79 rows=12,524 width=72) (actual time=1,582.607..1,582.607 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,862
5. 1.900 277.552 ↓ 0.0 0 1 / 5

BitmapAnd (cost=156,204.44..156,204.44 rows=222,606 width=0) (actual time=1,387.758..1,387.759 rows=0 loops=1)

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

Bitmap Index Scan on listings_account_id_idx (cost=0.00..44,213.94 rows=2,392,183 width=0) (actual time=390.259..390.259 rows=2,313,242 loops=1)

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

Bitmap Index Scan on listings_site_idx (cost=0.00..111,965.21 rows=6,058,219 width=0) (actual time=988.001..988.002 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 : 6.650 ms
Execution time : 1,592.786 ms