explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 8FhG

Settings
# exclusive inclusive rows x rows loops node
1. 77.797 6,174.108 ↑ 1.0 10,240 1

Sort (cost=95,160.82..95,186.47 rows=10,259 width=630) (actual time=6,159.106..6,174.108 rows=10,240 loops=1)

  • Sort Key: multas.nropatronal
  • Sort Method: quicksort Memory: 9977kB
2. 49.550 6,096.311 ↑ 1.0 10,240 1

Hash Left Join (cost=140.71..94,477.33 rows=10,259 width=630) (actual time=5.194..6,096.311 rows=10,240 loops=1)

  • Hash Cond: (multas.idtipo_multa = tipo_multa.idtipo_multa)
3. 72.655 6,046.740 ↑ 1.0 10,240 1

Nested Loop Left Join (cost=139.52..94,309.44 rows=10,259 width=619) (actual time=5.150..6,046.740 rows=10,240 loops=1)

4. 52.641 4,878.405 ↑ 1.0 10,240 1

Nested Loop Left Join (cost=139.09..79,072.16 rows=10,259 width=620) (actual time=5.127..4,878.405 rows=10,240 loops=1)

5. 67.750 2,910.884 ↑ 1.0 10,240 1

Nested Loop Left Join (cost=138.65..53,614.08 rows=10,259 width=595) (actual time=4.772..2,910.884 rows=10,240 loops=1)

6. 91.196 1,860.094 ↑ 1.0 10,240 1

Nested Loop Left Join (cost=138.23..39,087.53 rows=10,259 width=595) (actual time=4.736..1,860.094 rows=10,240 loops=1)

7. 127.657 130.498 ↑ 1.0 10,240 1

Bitmap Heap Scan on multas (cost=137.80..2,518.03 rows=10,259 width=358) (actual time=3.179..130.498 rows=10,240 loops=1)

  • Recheck Cond: (idtipo_multa = 11)
8. 2.841 2.841 ↑ 1.0 10,240 1

Bitmap Index Scan on multas_idtipo_multa_idx (cost=0.00..135.23 rows=10,259 width=0) (actual time=2.841..2.841 rows=10,240 loops=1)

  • Index Cond: (idtipo_multa = 11)
9. 1,638.400 1,638.400 ↑ 1.0 1 10,240

Index Scan using empleados_movimientos_pk on empleados_movimientos (cost=0.43..3.55 rows=1 width=245) (actual time=0.158..0.160 rows=1 loops=10,240)

  • Index Cond: (multas.id_registro_multado = id)
10. 983.040 983.040 ↑ 1.0 1 10,240

Index Only Scan using empleados_id_persona_id_idx on empleados (cost=0.43..1.41 rows=1 width=16) (actual time=0.095..0.096 rows=1 loops=10,240)

  • Index Cond: (id = empleados_movimientos.empleado_id)
  • Heap Fetches: 26
11. 1,914.880 1,914.880 ↑ 1.0 1 10,240

Index Scan using persons_pk on persons (cost=0.43..2.47 rows=1 width=33) (actual time=0.185..0.187 rows=1 loops=10,240)

  • Index Cond: (empleados.persona_id = id)
12. 1,095.680 1,095.680 ↑ 1.0 1 10,240

Index Only Scan using persons_docs_person_id_valor_idx on persons_docs (cost=0.43..1.48 rows=1 width=15) (actual time=0.105..0.107 rows=1 loops=10,240)

  • Index Cond: (person_id = persons.id)
  • Heap Fetches: 1
13. 0.005 0.021 ↑ 1.0 1 1

Hash (cost=1.18..1.18 rows=1 width=15) (actual time=0.021..0.021 rows=1 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 1kB
14. 0.016 0.016 ↑ 1.0 1 1

Seq Scan on tipo_multa (cost=0.00..1.18 rows=1 width=15) (actual time=0.011..0.016 rows=1 loops=1)

  • Filter: (idtipo_multa = 11)
  • Rows Removed by Filter: 13