explain.depesz.com

PostgreSQL's explain analyze made readable

Result: qJfJ

Settings
# exclusive inclusive rows x rows loops node
1. 98.023 299.959 ↓ 0.0 0 1

Hash Join (cost=14,423.85..3,826,038.79 rows=102,476 width=4) (actual time=299.958..299.959 rows=0 loops=1)

  • Buffers: shared hit=890, local read=3279
2. 56.799 56.799 ↑ 1.0 136,498 1

Seq Scan on dim_contract_family_contractee dim_contract_family_contractee (cost=0..2,946.24 rows=136,635 width=8) (actual time=6.258..56.799 rows=136,498 loops=1)

  • Filter: (dim_contract_family_contractee.client_sk = 8)
  • Buffers: shared hit=890
3. 58.093 145.137 ↑ 3.3 136,498 1

Hash (cost=7,736.94..7,736.94 rows=445,794 width=8) (actual time=145.136..145.137 rows=136,498 loops=1)

  • Buffers: local read=3279
4. 87.044 87.044 ↑ 3.3 136,498 1

Seq Scan on tmp_dim_contract_family_contractee t (cost=0..7,736.94 rows=445,794 width=8) (actual time=34.139..87.044 rows=136,498 loops=1)

  • Buffers: local read=3279