explain.depesz.com

PostgreSQL's explain analyze made readable

Result: HtT4

Settings
# exclusive inclusive rows x rows loops node
1. 205.311 11,951.030 ↑ 1.0 1 1

Aggregate (cost=891,679.33..891,679.34 rows=1 width=40) (actual time=11,951.030..11,951.030 rows=1 loops=1)

2. 156.577 11,745.719 ↓ 883,867.0 883,867 1

Nested Loop (cost=386,097.40..891,679.33 rows=1 width=14) (actual time=8,462.350..11,745.719 rows=883,867 loops=1)

3. 77.342 10,705.275 ↓ 883,867.0 883,867 1

Gather (cost=386,097.25..891,679.16 rows=1 width=18) (actual time=8,462.322..10,705.275 rows=883,867 loops=1)

  • Workers Planned: 4
  • Workers Launched: 4
4. 2,131.548 10,627.933 ↓ 176,773.0 176,773 5

Hash Left Join (cost=385,097.25..890,679.06 rows=1 width=18) (actual time=8,589.620..10,627.933 rows=176,773 loops=5)

  • Hash Cond: ((fat.empresa_id = cv.empresa_id) AND ((fat.chavefato)::text = (cv.chavefato)::text))
  • Filter: (cv.id IS NULL)
  • Rows Removed by Filter: 682639
  • -> Parallel Seq Scan on vm_venda_nao_conciliada_fato_1615 fat (cost=0.00..475345.02 rows=711454 width=70) (actual time=0.030..1166.821 rows=85941
  • Filter: ((parcela = 1) AND (status <> ALL ('{4,6,7}'::integer[])) AND (data_venda <= CURRENT_DATE) AND (data_venda >= (CURRENT_DATE - 30)) AN
  • Rows Removed by Filter: 161157
5. 8,496.385 8,496.385 ↑ 1.0 10,407,777 5

Hash (cost=226,865.10..226,865.10 rows=10,548,810 width=60) (actual time=8,496.385..8,496.385 rows=10,407,777 loops=5)

  • Buckets: 16777216 Batches: 1 Memory Usage: 1108100kB
  • -> Seq Scan on vm_venda_nao_conciliada_conciliacao_vendas_1615 cv (cost=0.00..226865.10 rows=10548810 width=60) (actual time=0.047..2552.81
6. 883.867 883.867 ↑ 1.0 1 883,867

Index Scan using pk_dim_rede on rede red (cost=0.14..0.16 rows=1 width=4) (actual time=0.001..0.001 rows=1 loops=883,867)

  • Index Cond: (id = fat.rede_id)
  • Filter: (pbm IS FALSE)
Planning time : 1.078 ms
Execution time : 12,194.955 ms