explain.depesz.com

PostgreSQL's explain analyze made readable

Result: VhVA

Settings
# exclusive inclusive rows x rows loops node
1. 61.751 772.031 ↓ 2.0 2 1

Gather (cost=1,354.20..7,674.17 rows=1 width=1,274) (actual time=391.659..772.031 rows=2 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
2. 682.542 710.280 ↑ 1.0 1 3

Hash Join (cost=354.20..6,674.07 rows=1 width=1,274) (actual time=583.490..710.280 rows=1 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: 546463
3. 12.966 12.966 ↑ 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.966 rows=56,831 loops=3)

4. 6.227 14.772 ↑ 1.0 1,000 3

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

  • Buckets: 1024 Batches: 1 Memory Usage: 996kB
5. 3.392 8.545 ↑ 1.0 1,000 3

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

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

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

7. 3.709 3.709 ↑ 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.256..3.709 rows=1,000 loops=3)

8. 0.800 1.315 ↑ 1.0 1,918 3

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

  • Buckets: 2048 Batches: 1 Memory Usage: 118kB
9. 0.515 0.515 ↑ 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.060..0.515 rows=1,918 loops=3)

Planning time : 20.210 ms