explain.depesz.com

PostgreSQL's explain analyze made readable

Result: D8Ka

Settings

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 40.798 1,615.983 ↓ 1.1 62,193 1

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

  • Workers Planned: 2
  • Workers Launched: 2
2. 184.416 1,575.185 ↑ 1.2 20,731 3

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

  • Hash Cond: (aso.id = band.id)
3. 63.620 63.620 ↑ 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..63.620 rows=510,317 loops=3)

4. 30.014 1,327.149 ↑ 1.0 78,476 3

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

  • Buckets: 262144 Batches: 1 Memory Usage: 11296kB
5. 465.361 1,297.135 ↑ 1.0 78,476 3

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

  • Hash Cond: (band.proceso_transaccion_id = proc.id)
6. 773.282 773.282 ↑ 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.052..773.282 rows=1,685,293 loops=3)

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

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

  • Buckets: 262144 Batches: 1 Memory Usage: 8736kB
8. 27.251 27.251 ↑ 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.149..27.251 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 : 1.706 ms
Execution time : 1,619.749 ms