explain.depesz.com

PostgreSQL's explain analyze made readable

Result: z9De

Settings
# exclusive inclusive rows x rows loops node
1. 0.001 0.640 ↓ 0.0 0 1

ModifyTable (cost=7.89..140.54 rows=97 width=12) (actual time=0.64..0.64 rows=0 loops=1)

  • Buffers: shared hit=3 read=3, local hit=4
2. 0.044 0.639 ↓ 0.0 0 1

Hash Join (cost=7.89..140.54 rows=97 width=12) (actual time=0.639..0.639 rows=0 loops=1)

  • Buffers: shared hit=3 read=3, local hit=4
3. 0.522 0.522 ↑ 1.3 76 1

Index Scan using dim_invoice_client_sk_idx on dim_invoice dim_invoice (cost=0.42..131.85 rows=97 width=43) (actual time=0.489..0.522 rows=76 loops=1)

  • Index Cond: (dim_invoice.client_sk = 27)
  • Buffers: shared hit=3 read=3
4. 0.034 0.073 ↑ 2.0 77 1

Hash (cost=5.54..5.54 rows=154 width=43) (actual time=0.073..0.073 rows=77 loops=1)

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

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

  • Buffers: local hit=4