explain.depesz.com

PostgreSQL's explain analyze made readable

Result: pKIZ

Settings
# exclusive inclusive rows x rows loops node
1. 2.699 3.910 ↓ 1.0 651 1

Sort (cost=153.78..155.38 rows=640 width=150) (actual time=3.898..3.910 rows=651 loops=1)

  • Sort Key: l.descripcion, mp.descripcion
  • Sort Method: quicksort Memory: 78kB
2. 0.265 1.211 ↓ 1.0 651 1

Hash Join (cost=66.33..123.95 rows=640 width=150) (actual time=0.521..1.211 rows=651 loops=1)

  • Hash Cond: (mp.linea = l.id)
3. 0.370 0.928 ↓ 1.0 651 1

Hash Join (cost=54.52..98.55 rows=640 width=36) (actual time=0.497..0.928 rows=651 loops=1)

  • Hash Cond: (p.producto = mp.id)
4. 0.070 0.070 ↓ 1.0 785 1

Seq Scan on precios p (cost=0.00..34.73 rows=773 width=16) (actual time=0.002..0.070 rows=785 loops=1)

5. 0.094 0.488 ↓ 1.0 647 1

Hash (cost=46.56..46.56 rows=637 width=28) (actual time=0.488..0.488 rows=647 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 40kB
6. 0.394 0.394 ↓ 1.0 647 1

Seq Scan on materiasprimas mp (cost=0.00..46.56 rows=637 width=28) (actual time=0.006..0.394 rows=647 loops=1)

  • Filter: (estatus ~~* 'A'::text)
  • Rows Removed by Filter: 134
7. 0.013 0.018 ↑ 2.7 30 1

Hash (cost=10.80..10.80 rows=80 width=122) (actual time=0.018..0.018 rows=30 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 2kB
8. 0.005 0.005 ↑ 2.7 30 1

Seq Scan on lineas l (cost=0.00..10.80 rows=80 width=122) (actual time=0.004..0.005 rows=30 loops=1)

Planning time : 0.245 ms
Execution time : 4.006 ms