explain.depesz.com

PostgreSQL's explain analyze made readable

Result: ZRmO

Settings
# exclusive inclusive rows x rows loops node
1. 8.209 61.560 ↓ 0.0 0 1

Hash Left Join (cost=95,683.79..115,439.55 rows=1 width=46) (actual time=61.560..61.560 rows=0 loops=1)

  • Hash Cond: ((a.cnpj)::text = (b.cpf_cnpj)::text)
  • Filter: (b.id_empresa IS NULL)
  • Rows Removed by Filter: 4
2. 0.011 0.011 ↑ 550.0 2 1

Seq Scan on tmp_part_cte a (cost=0.00..21.00 rows=1,100 width=46) (actual time=0.007..0.011 rows=2 loops=1)

3. 15.254 53.340 ↑ 158.1 15,029 1

Hash (cost=52,063.26..52,063.26 rows=2,375,882 width=22) (actual time=53.340..53.340 rows=15,029 loops=1)

  • Buckets: 1,048,576 Batches: 4 Memory Usage: 8,400kB
4. 23.368 38.086 ↑ 158.1 15,029 1

Nested Loop (cost=42.31..52,063.26 rows=2,375,882 width=22) (actual time=0.097..38.086 rows=15,029 loops=1)

5. 0.013 0.026 ↑ 100.0 2 1

HashAggregate (cost=41.88..43.88 rows=200 width=4) (actual time=0.022..0.026 rows=2 loops=1)

  • Group Key: tmp_nossos_clientes.id_empresa
6. 0.013 0.013 ↑ 1,275.0 2 1

Seq Scan on tmp_nossos_clientes (cost=0.00..35.50 rows=2,550 width=4) (actual time=0.010..0.013 rows=2 loops=1)

7. 14.692 14.692 ↓ 1.3 7,514 2

Index Only Scan using participante_pkey on participante b (cost=0.43..203.26 rows=5,684 width=22) (actual time=0.043..7.346 rows=7,514 loops=2)

  • Index Cond: (id_empresa = tmp_nossos_clientes.id_empresa)
  • Heap Fetches: 0