explain.depesz.com

PostgreSQL's explain analyze made readable

Result: ZUYL

Settings
# exclusive inclusive rows x rows loops node
1. 27.945 110.845 ↑ 1.0 30,448 1

Hash Join (cost=1,349.17..3,238.99 rows=30,448 width=21) (actual time=37.696..110.845 rows=30,448 loops=1)

  • Hash Cond: ((cliente_avl_equipo.rut_cliente)::text = (cliente.rut)::text)
  • Planning time: 0.660 ms
  • Execution time: 121.708 ms
2. 29.688 81.380 ↑ 1.0 30,448 1

Hash Join (cost=1,280.41..2,937.82 rows=30,448 width=36) (actual time=36.166..81.380 rows=30,448 loops=1)

  • Hash Cond: (cliente_avl_equipo.imei_equipo = avl_equipo.imei)
3. 15.600 15.600 ↑ 1.0 30,448 1

Seq Scan on cliente_avl_equipo (cost=0.00..1,577.48 rows=30,448 width=20) (actual time=0.021..15.600 rows=30,448 loops=1)

4. 15.877 36.092 ↑ 1.0 30,487 1

Hash (cost=899.07..899.07 rows=30,507 width=24) (actual time=36.092..36.092 rows=30,487 loops=1)

  • Buckets: 32768 Batches: 1 Memory Usage: 1992kB
5. 20.215 20.215 ↑ 1.0 30,487 1

Seq Scan on avl_equipo (cost=0.00..899.07 rows=30,507 width=24) (actual time=0.005..20.215 rows=30,487 loops=1)

6. 0.698 1.520 ↓ 1.0 1,368 1

Hash (cost=51.67..51.67 rows=1,367 width=16) (actual time=1.520..1.520 rows=1,368 loops=1)

  • Buckets: 2048 Batches: 1 Memory Usage: 82kB
7. 0.822 0.822 ↓ 1.0 1,368 1

Seq Scan on cliente (cost=0.00..51.67 rows=1,367 width=16) (actual time=0.011..0.822 rows=1,368 loops=1)