explain.depesz.com

PostgreSQL's explain analyze made readable

Result: tygK

Settings
# exclusive inclusive rows x rows loops node
1. 0.243 13.116 ↓ 0.0 0 1

ModifyTable (cost=20.91..366.72 rows=100 width=34) (actual time=13.116..13.116 rows=0 loops=1)

  • Buffers: shared hit=574 read=306 dirtied=67 written=89
2. 0.116 12.873 ↑ 1.0 100 1

Nested Loop (cost=20.91..366.72 rows=100 width=34) (actual time=11.233..12.873 rows=100 loops=1)

  • Buffers: shared hit=374 read=306 dirtied=37 written=89
3. 0.145 11.257 ↑ 1.0 100 1

Aggregate (cost=20.47..21.47 rows=100 width=32) (actual time=11.206..11.257 rows=100 loops=1)

  • Buffers: shared hit=4 read=275 dirtied=37 written=61
4. 0.100 11.112 ↑ 1.0 100 1

Subquery Scan on ANY_subquery (cost=0..20.22 rows=100 width=32) (actual time=0.034..11.112 rows=100 loops=1)

  • Buffers: shared hit=4 read=275 dirtied=37 written=61
5. 0.039 11.012 ↑ 1.0 100 1

Limit (cost=0..19.22 rows=100 width=4) (actual time=0.019..11.012 rows=100 loops=1)

  • Buffers: shared hit=4 read=275 dirtied=37 written=61
6. 10.973 10.973 ↑ 23,980.8 100 1

Seq Scan on fact_sale fact_sale_1 (cost=0..460,927.84 rows=2,398,084 width=4) (actual time=0.017..10.973 rows=100 loops=1)

  • Filter: (fact_sale_1.client_sk = 8)
  • Buffers: shared hit=4 read=275 dirtied=37 written=61
7. 1.500 1.500 ↑ 1.0 1 100

Index Scan using fact_sale_pkey on fact_sale fact_sale (cost=0.43..3.45 rows=1 width=10) (actual time=0.015..0.015 rows=1 loops=100)

  • Index Cond: (fact_sale.sale_sk = "ANY_subquery".sale_sk)
  • Buffers: shared hit=370 read=31 written=28