explain.depesz.com

PostgreSQL's explain analyze made readable

Result: jmdL : Optimization for: plan #AWDU

Settings

Optimization path:

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 35.581 194.741 ↓ 204.4 49,270 1

Gather (cost=17,367.58..40,544.47 rows=241 width=160) (actual time=136.861..194.741 rows=49,270 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
2. 53.530 159.160 ↓ 164.2 16,423 3 / 3

Parallel Hash Join (cost=16,367.58..39,520.37 rows=100 width=160) (actual time=125.444..159.160 rows=16,423 loops=3)

  • Hash Cond: ((guia_2019_05.pagamento_id = pagamento.id) AND (guia_2019_05.data_pagamento = pagamento.data_pagamento))
3. 49.175 49.175 ↑ 1.3 77,068 3 / 3

Parallel Seq Scan on guia_2019_05 (cost=0.00..17,940.41 rows=97,217 width=109) (actual time=0.022..49.175 rows=77,068 loops=3)

  • Filter: ((data_pagamento >= '2019-05-10'::date) AND (data_pagamento <= '2019-05-20'::date))
  • Rows Removed by Filter: 165,620
4. 25.634 56.455 ↑ 1.2 121,333 3 / 3

Parallel Hash (cost=12,630.35..12,630.35 rows=150,882 width=51) (actual time=56.455..56.455 rows=121,333 loops=3)

  • Buckets: 65,536 Batches: 16 Memory Usage: 2,432kB
5. 30.821 30.821 ↑ 1.2 121,333 3 / 3

Parallel Seq Scan on pagamento (cost=0.00..12,630.35 rows=150,882 width=51) (actual time=0.015..30.821 rows=121,333 loops=3)

  • Filter: (convenio_id = 72)
  • Rows Removed by Filter: 156,065
Planning time : 0.439 ms
Execution time : 196.602 ms