explain.depesz.com

PostgreSQL's explain analyze made readable

Result: soBD

Settings
# exclusive inclusive rows x rows loops node
1. 1.666 7.700 ↓ 0.0 0 1

ModifyTable (cost=191.1..3,632.16 rows=1,000 width=34) (actual time=7.699..7.7 rows=0 loops=1)

  • Buffers: shared hit=6031 read=1
2. 0.305 6.034 ↑ 1.0 1,000 1

Nested Loop (cost=191.1..3,632.16 rows=1,000 width=34) (actual time=1.339..6.034 rows=1,000 loops=1)

  • Buffers: shared hit=4031 read=1
3. 0.751 1.729 ↑ 1.0 1,000 1

Aggregate (cost=190.66..200.66 rows=1,000 width=32) (actual time=1.324..1.729 rows=1,000 loops=1)

  • Buffers: shared hit=29
4. 0.399 0.978 ↑ 1.0 1,000 1

Subquery Scan on ANY_subquery (cost=0..188.16 rows=1,000 width=32) (actual time=0.073..0.978 rows=1,000 loops=1)

  • Buffers: shared hit=29
5. 0.180 0.579 ↑ 1.0 1,000 1

Limit (cost=0..178.16 rows=1,000 width=4) (actual time=0.069..0.579 rows=1,000 loops=1)

  • Buffers: shared hit=29
6. 0.399 0.399 ↑ 2,030.8 1,000 1

Seq Scan on fact_sale fact_sale_1 (cost=0..361,811.9 rows=2,030,817 width=4) (actual time=0.068..0.399 rows=1,000 loops=1)

  • Filter: (fact_sale_1.client_sk = 8)
  • Buffers: shared hit=29
7. 4.000 4.000 ↑ 1.0 1 1,000

Index Scan using fact_sale_pkey on fact_sale fact_sale (cost=0.43..3.43 rows=1 width=10) (actual time=0.004..0.004 rows=1 loops=1,000)

  • Index Cond: (fact_sale.sale_sk = "ANY_subquery".sale_sk)
  • Buffers: shared hit=4002 read=1