explain.depesz.com

PostgreSQL's explain analyze made readable

Result: QW4p

Settings
# exclusive inclusive rows x rows loops node
1. 28.741 311.972 ↓ 2.3 16,529 1

Hash Left Join (cost=3,167.30..60,798.37 rows=7,266 width=150) (actual time=7.594..311.972 rows=16,529 loops=1)

  • Hash Cond: ((ld.venture_id = pj.venture_id) AND (ld.project_id = pj.id) AND (ld.client_id = pj.client_id))
2. 23.971 276.259 ↓ 2.3 16,529 1

Nested Loop Left Join (cost=141.03..57,517.78 rows=7,266 width=650) (actual time=0.595..276.259 rows=16,529 loops=1)

3. 3.805 4.353 ↓ 2.3 16,529 1

Bitmap Heap Scan on tmp_net_wld_ld3 ld (cost=140.60..435.42 rows=7,266 width=104) (actual time=0.570..4.353 rows=16,529 loops=1)

  • Recheck Cond: (rk <= 5)
  • Heap Blocks: exact=199
4. 0.548 0.548 ↓ 2.3 16,529 1

Bitmap Index Scan on tmp_net_wld_ld3_rk_idx (cost=0.00..138.78 rows=7,266 width=0) (actual time=0.548..0.548 rows=16,529 loops=1)

  • Index Cond: (rk <= 5)
5. 247.935 247.935 ↑ 1.0 1 16,529

Index Scan using listings_bi_venture_id_sku_idx on listings_bi ls (cost=0.43..7.85 rows=1 width=566) (actual time=0.015..0.015 rows=1 loops=16,529)

  • Index Cond: ((venture_id = ld.venture_id) AND ((sku)::text = (ld.listing_sku)::text))
6. 2.118 6.972 ↑ 1.0 8,228 1

Hash (cost=2,882.28..2,882.28 rows=8,228 width=123) (actual time=6.972..6.972 rows=8,228 loops=1)

  • Buckets: 16384 Batches: 1 Memory Usage: 1306kB
7. 4.854 4.854 ↑ 1.0 8,228 1

Seq Scan on projects pj (cost=0.00..2,882.28 rows=8,228 width=123) (actual time=0.004..4.854 rows=8,228 loops=1)