explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Q9Cc

Settings
# exclusive inclusive rows x rows loops node
1. 1.148 14.569 ↓ 0.0 0 1

Delete on fact_sale (cost=205.14..3,647.71 rows=1,000 width=34) (actual time=14.569..14.569 rows=0 loops=1)

  • Buffers: shared hit=6086 read=220 dirtied=80
2. 0.262 13.421 ↑ 1.0 1,000 1

Nested Loop (cost=205.14..3,647.71 rows=1,000 width=34) (actual time=10.979..13.421 rows=1,000 loops=1)

  • Buffers: shared hit=4086 read=220 dirtied=80
3. 0.614 11.159 ↑ 1.0 1,000 1

HashAggregate (cost=204.71..214.71 rows=1,000 width=32) (actual time=10.927..11.159 rows=1,000 loops=1)

  • Group Key: "ANY_subquery".sale_sk
  • Buffers: shared hit=83 read=220 dirtied=80
4. 0.228 10.545 ↑ 1.0 1,000 1

Subquery Scan on ANY_subquery (cost=0.00..202.21 rows=1,000 width=32) (actual time=1.118..10.545 rows=1,000 loops=1)

  • Buffers: shared hit=83 read=220 dirtied=80
5. 0.096 10.317 ↑ 1.0 1,000 1

Limit (cost=0.00..192.21 rows=1,000 width=4) (actual time=1.112..10.317 rows=1,000 loops=1)

  • Buffers: shared hit=83 read=220 dirtied=80
6. 10.221 10.221 ↑ 2,398.1 1,000 1

Seq Scan on fact_sale fact_sale_1 (cost=0.00..460,927.84 rows=2,398,084 width=4) (actual time=1.110..10.221 rows=1,000 loops=1)

  • Filter: (client_sk = 8)
  • Rows Removed by Filter: 11542
  • Buffers: shared hit=83 read=220 dirtied=80
7. 2.000 2.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.002..0.002 rows=1 loops=1,000)

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