explain.depesz.com

PostgreSQL's explain analyze made readable

Result: wrKt

Settings
# exclusive inclusive rows x rows loops node
1. 1.746 19.264 ↓ 0.0 0 1

Delete on fact_sale (cost=191.10..3,632.16 rows=1,000 width=34) (actual time=19.264..19.264 rows=0 loops=1)

  • Buffers: shared hit=6042 read=36 dirtied=34
2. 0.392 17.518 ↑ 1.0 1,000 1

Nested Loop (cost=191.10..3,632.16 rows=1,000 width=34) (actual time=13.775..17.518 rows=1,000 loops=1)

  • Buffers: shared hit=4042 read=36 dirtied=34
3. 0.904 14.126 ↑ 1.0 1,000 1

HashAggregate (cost=190.66..200.66 rows=1,000 width=32) (actual time=13.742..14.126 rows=1,000 loops=1)

  • Group Key: "ANY_subquery".sale_sk
  • Buffers: shared hit=39 read=36 dirtied=34
4. 0.337 13.222 ↑ 1.0 1,000 1

Subquery Scan on ANY_subquery (cost=0.00..188.16 rows=1,000 width=32) (actual time=0.063..13.222 rows=1,000 loops=1)

  • Buffers: shared hit=39 read=36 dirtied=34
5. 0.141 12.885 ↑ 1.0 1,000 1

Limit (cost=0.00..178.16 rows=1,000 width=4) (actual time=0.058..12.885 rows=1,000 loops=1)

  • Buffers: shared hit=39 read=36 dirtied=34
6. 12.744 12.744 ↑ 2,030.8 1,000 1

Seq Scan on fact_sale fact_sale_1 (cost=0.00..361,811.90 rows=2,030,817 width=4) (actual time=0.057..12.744 rows=1,000 loops=1)

  • Filter: (client_sk = 8)
  • Rows Removed by Filter: 2070
  • Buffers: shared hit=39 read=36 dirtied=34
7. 3.000 3.000 ↑ 1.0 1 1,000

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

  • Index Cond: (sale_sk = "ANY_subquery".sale_sk)
  • Buffers: shared hit=4003
Planning time : 0.325 ms
Execution time : 19.442 ms