explain.depesz.com

PostgreSQL's explain analyze made readable

Result: YWYk : Optimization for: plan #D8Ka

Settings

Optimization path:

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 40.633 1,825.062 ↓ 1.1 62,193 1

Gather (cost=108,533.99..136,615.42 rows=58,813 width=8) (actual time=1,691.874..1,825.062 rows=62,193 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
2. 250.494 1,784.429 ↑ 1.2 20,731 3

Parallel Hash Join (cost=107,533.99..129,734.12 rows=24,505 width=8) (actual time=1,683.425..1,784.429 rows=20,731 loops=3)

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

Parallel Index Only Scan using idx_ambulatorio_solicitud_numero on ambulatorio_solicitud aso (cost=0.43..19,706.34 rows=637,896 width=8) (actual time=0.467..190.803 rows=510,317 loops=3)

  • Heap Fetches: 82
4. 31.509 1,343.132 ↑ 1.0 78,476 3

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

  • Buckets: 262144 Batches: 1 Memory Usage: 11264kB
5. 509.123 1,311.623 ↑ 1.0 78,476 3

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

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

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

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

  • Buckets: 262144 Batches: 1 Memory Usage: 8704kB
8. 25.150 25.150 ↑ 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.116..25.150 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 : 8.147 ms
Execution time : 1,832.169 ms