explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 7xGL

Settings
# exclusive inclusive rows x rows loops node
1. 33.321 754.568 ↓ 0.0 0 1

Gather (cost=1,354.20..7,674.17 rows=1 width=1,274) (actual time=754.568..754.568 rows=0 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
2. 696.154 721.247 ↓ 0.0 0 3

Hash Join (cost=354.20..6,674.07 rows=1 width=1,274) (actual time=721.247..721.247 rows=0 loops=3)

  • Hash Cond: (fromprop.municipio = smun.municipio_s)
  • Join Filter: ((("mt_transactions_SICAR_b_table".sellercar IS NOT NULL) AND (("mt_transactions_SICAR_b_table".sellercar)::text = (fromprop.car)::text) AND ("mt_transactions_SICAR_b_table".cpf_cnpj_origem = fromprop.cpfcnpj)) OR (("mt_transactions_SICAR_b_table".sellercar IS NULL) AND (smun.municipio_s = fromprop.municipio) AND ("mt_transactions_SICAR_b_table".cpf_cnpj_origem = ANY (fromprop.cpfcnpjs)) AND ("mt_transactions_SICAR_b_table".fazenda_origem_s = ANY (fromprop.fazendas)) AND ("mt_transactions_SICAR_b_table".proprietario_origem_s = ANY (fromprop.proprietarios))))
  • Rows Removed by Join Filter: 586401
3. 12.487 12.487 ↑ 1.3 56,831 3

Parallel Seq Scan on a_propriedades_unicas fromprop (cost=0.00..4,016.39 rows=71,039 width=264) (actual time=0.024..12.487 rows=56,831 loops=3)

4. 5.180 12.606 ↑ 1.0 1,000 3

Hash (cost=341.70..341.70 rows=1,000 width=1,010) (actual time=12.606..12.606 rows=1,000 loops=3)

  • Buckets: 1024 Batches: 1 Memory Usage: 1001kB
5. 3.008 7.426 ↑ 1.0 1,000 3

Hash Join (cost=56.16..341.70 rows=1,000 width=1,010) (actual time=1.566..7.426 rows=1,000 loops=3)

  • Hash Cond: ("mt_transactions_SICAR_b_table".municipio_de_origem = smun.municipio)
6. 0.116 3.270 ↑ 1.0 1,000 3

Limit (cost=0.00..262.93 rows=1,000 width=988) (actual time=0.392..3.270 rows=1,000 loops=3)

7. 3.154 3.154 ↑ 3,462.4 1,000 3

Seq Scan on "mt_transactions_SICAR_b_table" (cost=0.00..910,366.27 rows=3,462,427 width=988) (actual time=0.388..3.154 rows=1,000 loops=3)

8. 0.701 1.148 ↑ 1.0 1,918 3

Hash (cost=32.18..32.18 rows=1,918 width=22) (actual time=1.148..1.148 rows=1,918 loops=3)

  • Buckets: 2048 Batches: 1 Memory Usage: 118kB
9. 0.447 0.447 ↑ 1.0 1,918 3

Seq Scan on tmp_a_municipio_unificado smun (cost=0.00..32.18 rows=1,918 width=22) (actual time=0.051..0.447 rows=1,918 loops=3)

Planning time : 6.869 ms