explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Lqxh

Settings
# exclusive inclusive rows x rows loops node
1. 5,904.473 212,772.593 ↓ 1.4 3,101 1

HashAggregate (cost=1,873,440.99..1,873,468.61 rows=2,210 width=36) (actual time=212,771.265..212,772.593 rows=3,101 loops=1)

  • Group Key: si.contrato_id
2. 26,046.162 206,868.120 ↓ 1.1 17,877,892 1

Hash Join (cost=622,666.45..1,794,350.30 rows=15,818,137 width=10) (actual time=76,265.101..206,868.120 rows=17,877,892 loops=1)

  • Hash Cond: (si.autorizacion_id = a.id)
3. 104,798.839 104,798.839 ↓ 1.0 21,401,114 1

Seq Scan on solicitud_item si (cost=0.00..612,417.82 rows=21,391,182 width=14) (actual time=150.599..104,798.839 rows=21,401,114 loops=1)

4. 5,426.293 76,023.119 ↓ 1.0 13,348,554 1

Hash (cost=455,982.30..455,982.30 rows=13,334,732 width=4) (actual time=76,023.119..76,023.119 rows=13,348,554 loops=1)

  • Buckets: 16777216 Batches: 1 Memory Usage: 600358kB
5. 70,596.826 70,596.826 ↓ 1.0 13,348,554 1

Seq Scan on autorizacion a (cost=0.00..455,982.30 rows=13,334,732 width=4) (actual time=65.458..70,596.826 rows=13,348,554 loops=1)

  • Filter: (estado_autorizacion_id = 4)
  • Rows Removed by Filter: 4684275