explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Eex6 : Optimization for: Optimization for: Optimization for: Optimization for: plan #D8Ka; plan #YWYk; plan #ob6Z; plan #cFktt

Settings

Optimization path:

# exclusive inclusive rows x rows loops node
1. 42.394 1,626.622 ↓ 1.1 62,193 1

Gather (cost=108,533.57..137,619.04 rows=58,813 width=8) (actual time=1,491.348..1,626.622 rows=62,193 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
2. 206.649 1,584.228 ↑ 1.2 20,731 3

Parallel Hash Join (cost=107,533.57..130,737.74 rows=24,505 width=8) (actual time=1,447.205..1,584.228 rows=20,731 loops=3)

  • Hash Cond: (aso.id = band.id)
3. 70.294 70.294 ↑ 1.2 510,317 3

Parallel Seq Scan on ambulatorio_solicitud aso (cost=0.00..20,709.96 rows=637,896 width=8) (actual time=0.011..70.294 rows=510,317 loops=3)

4. 42.671 1,307.285 ↑ 1.0 78,476 3

Parallel Hash (cost=106,509.27..106,509.27 rows=81,944 width=4) (actual time=1,307.285..1,307.285 rows=78,476 loops=3)

  • Buckets: 262144 Batches: 1 Memory Usage: 11328kB
5. 459.763 1,264.614 ↑ 1.0 78,476 3

Parallel Hash Join (cost=3,633.45..106,509.27 rows=81,944 width=4) (actual time=552.910..1,264.614 rows=78,476 loops=3)

  • Hash Cond: (band.proceso_transaccion_id = proc.id)
6. 725.782 725.782 ↑ 1.3 1,685,293 3

Parallel Seq Scan on evento_transaccion band (cost=0.00..97,344.67 rows=2,107,099 width=8) (actual time=0.042..725.782 rows=1,685,293 loops=3)

  • Filter: ((deleted IS FALSE) AND (es_anulado IS FALSE))
  • Rows Removed by Filter: 21160
7. 44.935 79.069 ↑ 1.2 56,486 3

Parallel Hash (cost=2,814.30..2,814.30 rows=65,532 width=4) (actual time=79.069..79.069 rows=56,486 loops=3)

  • Buckets: 262144 Batches: 1 Memory Usage: 8736kB
8. 34.134 34.134 ↑ 1.2 56,486 3

Parallel Index Only Scan using idx_proceso_transaccion_fecha_bene on proceso_transaccion proc (cost=0.43..2,814.30 rows=65,532 width=4) (actual time=0.361..34.134 rows=56,486 loops=3)

  • Index Cond: ((fecha_proceso_transaccion >= '2019-01-01 00:00:00'::timestamp without time zone) AND (fecha_proceso_transaccion <= '2019-01-31 00:00:00'::timestamp without time zone))
  • Heap Fetches: 0
Planning time : 5.445 ms
Execution time : 1,634.436 ms