explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Zwiz

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 0.000 ↓ 0.0

Hash Semi Join (cost=12,500.29..23,076.04 rows=86,025 width=76) (actual rows= loops=)

  • Hash Cond: (tb_servico_telefonia.id = tb_servico_telefonia_1.id)
2. 0.000 0.000 ↓ 0.0

Seq Scan on tb_servico_telefonia (cost=0.00..8,646.13 rows=370,513 width=76) (actual rows= loops=)

3. 0.000 0.000 ↓ 0.0

Hash (cost=11,424.98..11,424.98 rows=86,025 width=4) (actual rows= loops=)

4. 0.000 0.000 ↓ 0.0

Seq Scan on tb_servico_telefonia tb_servico_telefonia_1 (cost=0.00..11,424.98 rows=86,025 width=4) (actual rows= loops=)

  • Filter: ((id <> 65) AND ((cod_febrabam)::text = 'LOC'::text) AND ((nm_servico_telefonia)::text = 'CHAM.LOC.DDR MI '::text))