explain.depesz.com

PostgreSQL's explain analyze made readable

Result: uBhb

Settings

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 19.708 52.080 ↑ 1.0 617 1

Hash Join (cost=20.75..2,690.14 rows=617 width=589) (actual time=0.732..52.080 rows=617 loops=1)

  • Hash Cond: (p.id = rp.fk_id_produto)
2. 31.999 31.999 ↑ 1.0 79,434 1

Seq Scan on t_produto p (cost=0.00..2,258.34 rows=79,434 width=81) (actual time=0.008..31.999 rows=79,434 loops=1)

  • Filter: (NOT excluido)
3. 0.167 0.373 ↑ 1.0 617 1

Hash (cost=13.04..13.04 rows=617 width=8) (actual time=0.373..0.373 rows=617 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 33kB
4. 0.206 0.206 ↑ 1.0 617 1

Seq Scan on t_representante_t_produto_new rp (cost=0.00..13.04 rows=617 width=8) (actual time=0.010..0.206 rows=617 loops=1)

  • Filter: (fk_id_representante = 178)
  • Rows Removed by Filter: 106