explain.depesz.com

PostgreSQL's explain analyze made readable

Result: RtJB

Settings

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 153.329 438.903 ↓ 4.1 37,344 1

Hash Join (cost=1,621.55..2,094.63 rows=9,020 width=110) (actual time=268.967..438.903 rows=37,344 loops=1)

  • Hash Cond: ((b.fkempresa = a.fkempresa) AND ((b.codigocatalogoservicoagregado)::text = (a.codigocatalogoservicoagregado)::text))
2. 17.383 17.383 ↑ 1.0 4,935 1

Seq Scan on servicosagregadosxveiculosversoesxrevisoes b (cost=0.00..111.45 rows=4,935 width=31) (actual time=0.084..17.383 rows=4,935 loops=1)

  • Filter: (NOT excluido)
  • Rows Removed by Filter: 10
3. 131.938 268.191 ↑ 1.0 37,622 1

Hash (cost=1,057.22..1,057.22 rows=37,622 width=28) (actual time=268.188..268.191 rows=37,622 loops=1)

  • Buckets: 65536 Batches: 1 Memory Usage: 2767kB
4. 136.253 136.253 ↑ 1.0 37,622 1

Seq Scan on servicosagregadosxservicos a (cost=0.00..1,057.22 rows=37,622 width=28) (actual time=0.029..136.253 rows=37,622 loops=1)

Planning time : 2.423 ms
Execution time : 546.271 ms