explain.depesz.com

PostgreSQL's explain analyze made readable

Result: V6Tc

Settings
# exclusive inclusive rows x rows loops node
1. 34.195 93.244 ↓ 15,070.0 15,070 1

Nested Loop (cost=0.85..6.73 rows=1 width=405) (actual time=0.047..93.244 rows=15,070 loops=1)

  • Buffers: shared hit=52431 read=34
2. 13.839 13.839 ↓ 15,070.0 15,070 1

Index Scan using fact_accrual_client_sk_idx on fact_accrual fa (cost=0.43..3.26 rows=1 width=97) (actual time=0.028..13.839 rows=15,070 loops=1)

  • Index Cond: (fa.client_sk = 27)
  • Buffers: shared hit=715
3. 45.210 45.210 ↓ 0.0 0 15,070

Index Scan using product_uom_conversion_pkey on fact_product_uom_conversion fpuc (cost=0.42..3.44 rows=1 width=60) (actual time=0.003..0.003 rows=0 loops=15,070)

  • Index Cond: ((fa.product_sk = fpuc.product_sk) AND (fa.uom_sk = fpuc.uom_sk))
  • Buffers: shared hit=51716 read=34