explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Zyn5

Settings
# exclusive inclusive rows x rows loops node
1. 26.597 678.538 ↑ 1.0 1 1

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

  • Workers Planned: 2
  • Workers Launched: 2
2. 628.352 651.941 ↓ 0.0 0 3

Hash Join (cost=354.20..6,674.07 rows=1 width=1,274) (actual time=511.957..651.941 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: 545393
3. 12.702 12.702 ↑ 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.020..12.702 rows=56,831 loops=3)

4. 4.657 10.887 ↑ 1.0 1,000 3

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

  • Buckets: 1024 Batches: 1 Memory Usage: 994kB
5. 2.666 6.230 ↑ 1.0 1,000 3

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

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

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

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

8. 0.609 1.021 ↑ 1.0 1,918 3

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

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

Planning time : 5.564 ms