explain.depesz.com

PostgreSQL's explain analyze made readable

Result: iAtB

Settings
# exclusive inclusive rows x rows loops node
1. 2,403.323 4,227.412 ↓ 1.2 569,837 1

Hash Join (cost=32,932.77..304,762.56 rows=471,381 width=650) (actual time=482.109..4,227.412 rows=569,837 loops=1)

  • Buffers: shared hit=50669
2. 745.835 1,660.529 ↓ 1.2 569,837 1

Hash Join (cost=19,839.91..271,577.05 rows=471,381 width=257) (actual time=318.17..1,660.529 rows=569,837 loops=1)

  • Buffers: shared hit=41199
3. 607.883 728.175 ↓ 1.2 569,837 1

Bitmap Heap Scan on fact_sale fs (cost=13,246.28..262,508.68 rows=471,381 width=205) (actual time=131.313..728.175 rows=569,837 loops=1)

  • Buffers: shared hit=38716
4. 120.292 120.292 ↓ 1.2 569,837 1

Bitmap Index Scan on fact_sale_experiment_idx (cost=0..13,128.43 rows=471,381 width=0) (actual time=120.292..120.292 rows=569,837 loops=1)

  • Index Cond: ((fs.client_sk = 11) AND (fs.sale_reporting_date >= '2017-01-01'::date))
  • Buffers: shared hit=6199
5. 95.864 186.519 ↑ 1.0 164,425 1

Hash (cost=4,127.25..4,127.25 rows=164,425 width=60) (actual time=186.519..186.519 rows=164,425 loops=1)

  • Buffers: shared hit=2483
6. 90.655 90.655 ↑ 1.0 164,425 1

Seq Scan on fact_product_uom_conversion fpuc (cost=0..4,127.25 rows=164,425 width=60) (actual time=0.016..90.655 rows=164,425 loops=1)

  • Buffers: shared hit=2483
7. 55.274 163.560 ↑ 1.1 148,321 1

Hash (cost=11,080.16..11,080.16 rows=161,016 width=5) (actual time=163.56..163.56 rows=148,321 loops=1)

  • Buffers: shared hit=9470
8. 108.286 108.286 ↑ 1.1 148,321 1

Seq Scan on dim_company cmp (cost=0..11,080.16 rows=161,016 width=5) (actual time=0.012..108.286 rows=148,321 loops=1)

  • Buffers: shared hit=9470