explain.depesz.com

PostgreSQL's explain analyze made readable

Result: mjlG

Settings
# exclusive inclusive rows x rows loops node
1. 1,577.531 4,199.479 ↓ 1.2 2,610,316 1

Hash Join (cost=138,466.42..380,106.45 rows=2,162,637 width=276) (actual time=2,093.309..4,199.479 rows=2,610,316 loops=1)

  • Hash Cond: (evt.profesional_especialidad_medica_id = prof_espe.id)
2. 0.000 2,589.642 ↑ 1.0 1,749,811 1

Gather (cost=137,897.52..361,847.43 rows=1,750,418 width=4) (actual time=2,060.970..2,589.642 rows=1,749,811 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
3. 734.457 3,026.927 ↑ 1.3 583,270 3

Parallel Hash Join (cost=136,897.52..185,805.63 rows=729,341 width=4) (actual time=2,049.288..3,026.927 rows=583,270 loops=3)

  • Hash Cond: (proceso.id = evt.proceso_transaccion_id)
4. 253.092 253.092 ↑ 1.2 1,251,752 3

Parallel Index Only Scan using pk_proceso_transaccion on proceso_transaccion proceso (cost=0.43..40,002.16 rows=1,564,656 width=4) (actual time=0.091..253.092 rows=1,251,752 loops=3)

  • Heap Fetches: 0
5. 293.034 2,039.378 ↑ 1.3 583,270 3

Parallel Hash (cost=127,780.32..127,780.32 rows=729,341 width=8) (actual time=2,039.378..2,039.378 rows=583,270 loops=3)

  • Buckets: 2097152 Batches: 1 Memory Usage: 84864kB
6. 1,102.756 1,746.344 ↑ 1.3 583,270 3

Parallel Hash Join (cost=27,761.02..127,780.32 rows=729,341 width=8) (actual time=388.577..1,746.344 rows=583,270 loops=3)

  • Hash Cond: (evt.id = item.evento_transaccion_id)
7. 263.746 263.746 ↑ 1.2 1,570,994 3

Parallel Seq Scan on evento_transaccion evt (cost=0.00..89,618.01 rows=1,963,301 width=12) (actual time=0.026..263.746 rows=1,570,994 loops=3)

8. 257.765 379.842 ↑ 1.3 583,270 3

Parallel Hash (cost=18,644.25..18,644.25 rows=729,341 width=4) (actual time=379.842..379.842 rows=583,270 loops=3)

  • Buckets: 2097152 Batches: 1 Memory Usage: 84864kB
9. 122.077 122.077 ↑ 1.3 583,270 3

Parallel Index Only Scan using ix_evento_transaccion_item_evento_transaccion_id on evento_transaccion_item item (cost=0.43..18,644.25 rows=729,341 width=4) (actual time=0.246..122.077 rows=583,270 loops=3)

  • Heap Fetches: 0
10. 5.955 32.306 ↓ 1.0 5,061 1

Hash (cost=506.34..506.34 rows=5,005 width=280) (actual time=32.306..32.306 rows=5,061 loops=1)

  • Buckets: 8192 Batches: 1 Memory Usage: 854kB
11. 6.766 26.351 ↓ 1.0 5,061 1

Hash Join (cost=347.18..506.34 rows=5,005 width=280) (actual time=15.480..26.351 rows=5,061 loops=1)

  • Hash Cond: (fp.profesional_id = p.id)
12. 2.281 4.681 ↑ 1.0 4,549 1

Hash Join (cost=29.55..121.59 rows=4,549 width=4) (actual time=0.555..4.681 rows=4,549 loops=1)

  • Hash Cond: (fp.facturador_id = f.id)
13. 1.894 1.894 ↑ 1.0 4,549 1

Index Only Scan using uq_facturador_profesional_facturador_profesional on facturador_profesional fp (cost=0.28..80.32 rows=4,549 width=8) (actual time=0.035..1.894 rows=4,549 loops=1)

  • Heap Fetches: 0
14. 0.266 0.506 ↑ 1.0 808 1

Hash (cost=19.16..19.16 rows=808 width=4) (actual time=0.505..0.506 rows=808 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 37kB
15. 0.240 0.240 ↑ 1.0 808 1

Index Only Scan using pk_facturador on facturador f (cost=0.28..19.16 rows=808 width=4) (actual time=0.025..0.240 rows=808 loops=1)

  • Heap Fetches: 0
16. 4.665 14.904 ↑ 1.0 4,051 1

Hash (cost=267.00..267.00 rows=4,051 width=284) (actual time=14.904..14.904 rows=4,051 loops=1)

  • Buckets: 4096 Batches: 1 Memory Usage: 680kB
17. 5.919 10.239 ↑ 1.0 4,051 1

Hash Join (cost=153.84..267.00 rows=4,051 width=284) (actual time=2.985..10.239 rows=4,051 loops=1)

  • Hash Cond: (prof_espe.profesional_id = p.id)
18. 1.370 1.370 ↑ 1.0 4,051 1

Seq Scan on profesional_especialidad_medica prof_espe (cost=0.00..102.51 rows=4,051 width=8) (actual time=0.015..1.370 rows=4,051 loops=1)

19. 1.857 2.950 ↑ 1.0 3,682 1

Hash (cost=107.82..107.82 rows=3,682 width=276) (actual time=2.950..2.950 rows=3,682 loops=1)

  • Buckets: 4096 Batches: 1 Memory Usage: 581kB
20. 1.093 1.093 ↑ 1.0 3,682 1

Seq Scan on profesional p (cost=0.00..107.82 rows=3,682 width=276) (actual time=0.006..1.093 rows=3,682 loops=1)