explain.depesz.com

PostgreSQL's explain analyze made readable

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

Settings

Optimization path:

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 35.603 1,728.376 ↓ 1.1 62,193 1

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

  • Workers Planned: 2
  • Workers Launched: 2
2. 179.482 1,692.773 ↑ 1.2 20,731 3

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

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

4. 29.507 1,450.208 ↑ 1.0 78,476 3

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

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

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

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

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

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

  • Buckets: 262144 Batches: 1 Memory Usage: 8736kB
8. 123.683 123.683 ↑ 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=31.480..123.683 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.804 ms
Execution time : 1,732.154 ms