explain.depesz.com

PostgreSQL's explain analyze made readable

Result: CkAM : Optimization for: plan #70jY

Settings

Optimization path:

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 65.726 1,268.812 ↑ 1.1 276,770 1

Gather (cost=10,047.73..379,571.15 rows=306,469 width=149) (actual time=30.552..1,268.812 rows=276,770 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
  • Functions: 36
  • Options: Inlining false, Optimization false, Expressions true, Deforming true
  • Timing: Generation 4.812 ms, Inlining 0.000 ms, Optimization 2.299 ms, Emission 35.819 ms, Total 42.930 ms
2. 549.292 1,203.086 ↑ 1.4 92,257 3 / 3

Parallel Hash Join (cost=9,047.73..347,924.25 rows=127,695 width=149) (actual time=18.101..1,203.086 rows=92,257 loops=3)

  • Hash Cond: (guia.pagamento_id = pagamento.id)
3. 635.974 635.974 ↑ 1.2 4,970,420 3 / 3

Parallel Seq Scan on guia (cost=0.00..322,567.25 rows=6,213,025 width=102) (actual time=0.013..635.974 rows=4,970,420 loops=3)

4. 15.495 17.820 ↑ 1.4 5,135 3 / 3

Parallel Hash (cost=8,958.64..8,958.64 rows=7,127 width=47) (actual time=17.820..17.820 rows=5,135 loops=3)

  • Buckets: 32768 Batches: 1 Memory Usage: 1632kB
5. 1.837 2.325 ↑ 1.4 5,135 3 / 3

Parallel Bitmap Heap Scan on pagamento (cost=555.74..8,958.64 rows=7,127 width=47) (actual time=0.649..2.325 rows=5,135 loops=3)

  • Recheck Cond: ((data_pagamento >= '2018-11-10'::date) AND (data_pagamento <= '2018-11-20'::date))
  • Heap Blocks: exact=2843
6. 0.488 0.488 ↑ 1.1 15,405 1 / 3

Bitmap Index Scan on pagamento_data_pagamento (cost=0.00..551.46 rows=17,104 width=0) (actual time=1.464..1.464 rows=15,405 loops=1)

  • Index Cond: ((data_pagamento >= '2018-11-10'::date) AND (data_pagamento <= '2018-11-20'::date))
Execution time : 1,279.158 ms