explain.depesz.com

A tool for finding a real cause for slow queries.

Result: 5ZL

options
Did it help? Consider supporting us - Bitcoin address: 12v2hUztAk2LgzQ9H9LMwuU32urHMjZQnq
# exclusive inclusive rows x rows loops node
1. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=8,096.55..41,190.96 rows=254,422 width=13) (actual time=.. rows= loops=)

  • Hash Cond: (rp.protocolo = p.codigo)
2. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=8,094.50..37,690.60 rows=254,422 width=8) (actual time=.. rows= loops=)

  • Hash Cond: (r.codigo = rp.reconocimiento)
3. 0.000 0.000 ↓ 0.0

Seq Scan on reconocimientos r (cost=0.00..18,246.26 rows=71,621 width=4) (actual time=.. rows= loops=)

  • Filter: (id_vencimiento = 0)
4. 0.000 0.000 ↓ 0.0

Hash (cost=3,920.22..3,920.22 rows=254,422 width=8) (actual time=.. rows= loops=)

5. 0.000 0.000 ↓ 0.0

Seq Scan on reconocimientos_protocolos rp (cost=0.00..3,920.22 rows=254,422 width=8) (actual time=.. rows= loops=)

6. 0.000 0.000 ↓ 0.0

Hash (cost=1.47..1.47 rows=47 width=13) (actual time=.. rows= loops=)

7. 0.000 0.000 ↓ 0.0

Seq Scan on protocolos p (cost=0.00..1.47 rows=47 width=13) (actual time=.. rows= loops=)