explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 70jY

Settings

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 68.942 2,374.911 ↑ 1.1 276,770 1

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

  • Workers Planned: 2
  • Workers Launched: 2
  • Functions: 36
  • Options: Inlining false, Optimization false, Expressions true, Deforming true
  • Timing: Generation 3.789 ms, Inlining 0.000 ms, Optimization 2.552 ms, Emission 44.927 ms, Total 51.268 ms
2. 693.137 2,305.969 ↑ 1.4 92,257 3 / 3

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

  • Hash Cond: (guia.pagamento_id = pagamento.id)
3. 1,182.790 1,182.790 ↑ 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.440..1,182.790 rows=4,970,420 loops=3)

4. 18.520 430.042 ↑ 1.4 5,135 3 / 3

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

  • Buckets: 32,768 Batches: 1 Memory Usage: 1,632kB
5. 406.625 411.522 ↑ 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=5.180..411.522 rows=5,135 loops=3)

  • Recheck Cond: ((data_pagamento >= '2018-11-10'::date) AND (data_pagamento <= '2018-11-20'::date))
  • Heap Blocks: exact=853
6. 4.897 4.897 ↑ 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=14.692..14.692 rows=15,405 loops=1)

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