explain.depesz.com

PostgreSQL's explain analyze made readable

Result: jXKu

Settings
# exclusive inclusive rows x rows loops node
1. 0.098 204.281 ↓ 0.0 0 1

ModifyTable (cost=0..45,176.15 rows=149 width=12) (actual time=204.281..204.281 rows=0 loops=1)

  • Buffers: shared hit=29673, local hit=4
2. 1.648 204.183 ↑ 6.8 22 1

Nested Loop (cost=0..45,176.15 rows=149 width=12) (actual time=78.718..204.183 rows=22 loops=1)

  • Buffers: shared hit=29629, local hit=4
3. 201.849 201.849 ↑ 1.5 98 1

Seq Scan on dim_invoice dim_invoice (cost=0..44,826.04 rows=149 width=43) (actual time=11.432..201.849 rows=98 loops=1)

  • Filter: (dim_invoice.client_sk = 27)
  • Buffers: shared hit=29629
4. 0.652 0.686 ↑ 3.2 48 98

Materialize (cost=0..6.31 rows=154 width=43) (actual time=0..0.007 rows=48 loops=98)

  • Buffers: local hit=4
5. 0.034 0.034 ↑ 2.0 77 1

Seq Scan on tmp_dim_invoice tmp_dim_invoice (cost=0..5.54 rows=154 width=43) (actual time=0.011..0.034 rows=77 loops=1)

  • Buffers: local hit=4