explain.depesz.com

PostgreSQL's explain analyze made readable

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

Settings

Optimization path:

# exclusive inclusive rows x rows loops node
1. 40.461 201.148 ↑ 2.0 49,270 1

Gather (cost=16,990.37..49,759.09 rows=99,424 width=160) (actual time=135.745..201.148 rows=49,270 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
2. 56.077 160.687 ↑ 2.5 16,423 3 / 3

Parallel Hash Join (cost=15,990.37..38,816.69 rows=41,427 width=160) (actual time=124.202..160.687 rows=16,423 loops=3)

  • Hash Cond: (guia_2019_05.pagamento_id = pagamento.id)
3. 49.535 49.535 ↑ 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.025..49.535 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. 22.106 55.075 ↑ 1.2 121,333 3 / 3

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

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

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