explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 9oPg

Settings

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 1,778.430 6,027.602 ↑ 1.0 65,499 1

Sort (cost=44,449.64..44,613.38 rows=65,499 width=153) (actual time=5,865.959..6,027.602 rows=65,499 loops=1)

  • Sort Key: e.numede
  • Sort Method: external merge Disk: 8,416kB
2. 844.322 4,249.172 ↑ 1.0 65,499 1

GroupAggregate (cost=32,690.90..34,057.98 rows=65,499 width=153) (actual time=3,188.860..4,249.172 rows=65,499 loops=1)

  • Group Key: e.idelevage
3. 680.884 3,404.850 ↓ 1.0 73,294 1

Sort (cost=32,690.90..32,873.68 rows=73,113 width=117) (actual time=3,188.793..3,404.850 rows=73,294 loops=1)

  • Sort Key: e.idelevage
  • Sort Method: external merge Disk: 8,816kB
4. 378.902 2,723.966 ↓ 1.0 73,294 1

Hash Left Join (cost=11,664.06..22,283.16 rows=73,113 width=117) (actual time=1,900.129..2,723.966 rows=73,294 loops=1)

  • Hash Cond: (e.idelevage = ri.idelevage)
5. 530.805 530.805 ↑ 1.0 65,499 1

Seq Scan on elevage e (cost=0.00..8,741.74 rows=65,499 width=113) (actual time=84.631..530.805 rows=65,499 loops=1)

  • Filter: ((cosu)::text = '0'::text)
6. 181.173 1,814.259 ↓ 1.0 73,120 1

Hash (cost=10,750.15..10,750.15 rows=73,113 width=8) (actual time=1,814.259..1,814.259 rows=73,120 loops=1)

  • Buckets: 131,072 Batches: 1 Memory Usage: 3,881kB
7. 322.575 1,633.086 ↓ 1.0 73,120 1

Hash Right Join (cost=5,317.85..10,750.15 rows=73,113 width=8) (actual time=739.482..1,633.086 rows=73,120 loops=1)

  • Hash Cond: (i.idrefinstall = ri.idrefinstall)
8. 311.522 911.104 ↑ 1.0 73,109 1

Hash Right Join (cost=2,581.57..7,090.83 rows=73,113 width=4) (actual time=339.273..911.104 rows=73,109 loops=1)

  • Hash Cond: (di.idinstall = i.idinstall)
9. 261.319 261.319 ↑ 1.0 73,104 1

Seq Scan on details_install di (cost=0.00..3,585.92 rows=73,136 width=4) (actual time=0.043..261.319 rows=73,104 loops=1)

  • Filter: (((cosu)::text = '0'::text) AND (debut <= now()) AND ((now() < fin) OR (fin IS NULL)))
  • Rows Removed by Filter: 31
10. 168.055 338.263 ↓ 1.0 73,109 1

Hash (cost=1,667.79..1,667.79 rows=73,103 width=8) (actual time=338.263..338.263 rows=73,109 loops=1)

  • Buckets: 131,072 Batches: 1 Memory Usage: 3,880kB
11. 170.208 170.208 ↓ 1.0 73,109 1

Seq Scan on installation i (cost=0.00..1,667.79 rows=73,103 width=8) (actual time=0.050..170.208 rows=73,109 loops=1)

  • Filter: ((cosu)::text = '0'::text)
  • Rows Removed by Filter: 2
12. 190.672 399.407 ↓ 1.0 71,372 1

Hash (cost=1,844.14..1,844.14 rows=71,371 width=8) (actual time=399.407..399.407 rows=71,372 loops=1)

  • Buckets: 131,072 Batches: 1 Memory Usage: 3,812kB
13. 208.735 208.735 ↓ 1.0 71,372 1

Seq Scan on ref_install ri (cost=0.00..1,844.14 rows=71,371 width=8) (actual time=0.047..208.735 rows=71,372 loops=1)

  • Filter: ((cosu)::text = '0'::text)