explain.depesz.com

PostgreSQL's explain analyze made readable

Result: khDq

Settings
# exclusive inclusive rows x rows loops node
1. 6.048 8.101 ↓ 0.0 0 1

ModifyTable (cost=0..7.76 rows=148 width=166) (actual time=8.101..8.101 rows=0 loops=1)

  • Buffers: shared hit=1647 read=5 dirtied=6, local hit=4
2. 2.053 2.053 ↑ 2.0 74 1

Seq Scan on tmp_dim_invoice tmp_dim_invoice (cost=0..7.76 rows=148 width=166) (actual time=1.184..2.053 rows=74 loops=1)

  • Filter: (tmp_dim_invoice.min_record_timestamp IS NOT NULL)
  • Buffers: shared hit=85 read=1, local hit=4