explain.depesz.com

PostgreSQL's explain analyze made readable

Result: JZ4s : Optimization for: Optimization for: plan #AWDU; plan #jmdL

Settings

Optimization path:

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 41.857 220.805 ↓ 208.8 49,270 1

Gather (cost=17,367.58..40,467.41 rows=236 width=160) (actual time=158.909..220.805 rows=49,270 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
2. 54.674 178.948 ↓ 167.6 16,423 3 / 3

Parallel Hash Join (cost=16,367.58..39,443.81 rows=98 width=160) (actual time=145.311..178.948 rows=16,423 loops=3)

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

Parallel Seq Scan on guia_2019_05 (cost=0.00..17,940.41 rows=95,205 width=109) (actual time=0.023..50.644 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. 32.754 73.630 ↑ 1.2 121,333 3 / 3

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

  • Buckets: 65,536 Batches: 16 Memory Usage: 2,464kB
5. 40.876 40.876 ↑ 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..40.876 rows=121,333 loops=3)

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