explain.depesz.com

PostgreSQL's explain analyze made readable

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

Settings

Optimization path:

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 30.022 1,637.698 ↓ 1.1 62,193 1

Gather (cost=109,868.00..138,953.48 rows=58,813 width=8) (actual time=1,481.923..1,637.698 rows=62,193 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
2. 205.317 1,607.676 ↑ 1.2 20,731 3

Parallel Hash Join (cost=108,868.00..132,072.18 rows=24,505 width=8) (actual time=1,485.389..1,607.676 rows=20,731 loops=3)

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

4. 31.890 1,337.892 ↑ 1.0 78,476 3

Parallel Hash (cost=107,843.70..107,843.70 rows=81,944 width=4) (actual time=1,337.892..1,337.892 rows=78,476 loops=3)

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

Parallel Hash Join (cost=4,967.89..107,843.70 rows=81,944 width=4) (actual time=563.600..1,306.002 rows=78,476 loops=3)

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

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

Parallel Hash (cost=4,148.74..4,148.74 rows=65,532 width=4) (actual time=63.022..63.023 rows=56,486 loops=3)

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

Parallel Index Scan using ix_proceso_transaccion_fecha_proceso_transaccion on proceso_transaccion proc (cost=0.43..4,148.74 rows=65,532 width=4) (actual time=0.085..42.510 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))
Planning time : 1.634 ms
Execution time : 1,642.601 ms