explain.depesz.com

PostgreSQL's explain analyze made readable

Result: qVYU

Settings
# exclusive inclusive rows x rows loops node
1. 66.852 80.823 ↓ 1.0 3,863 1

GroupAggregate (cost=552.19..651.88 rows=3,860 width=40) (actual time=22.608..80.823 rows=3,863 loops=1)

  • Group Key: ac.id_pers_physique
2. 3.451 13.971 ↑ 1.0 5,144 1

Sort (cost=552.19..565.05 rows=5,144 width=145) (actual time=13.717..13.971 rows=5,144 loops=1)

  • Sort Key: ac.id_pers_physique
  • Sort Method: quicksort Memory: 937kB
3. 1.591 10.520 ↑ 1.0 5,144 1

Hash Left Join (cost=77.78..235.10 rows=5,144 width=145) (actual time=0.849..10.520 rows=5,144 loops=1)

  • Hash Cond: (ac.id_portefeuille = po.id_portefeuille)
4. 2.290 8.914 ↑ 1.0 5,144 1

Hash Left Join (cost=76.49..220.23 rows=5,144 width=133) (actual time=0.827..8.914 rows=5,144 loops=1)

  • Hash Cond: (ac.id_societe = so.id_societe)
5. 2.116 5.859 ↑ 1.0 5,144 1

Hash Join (cost=2.43..132.62 rows=5,144 width=112) (actual time=0.056..5.859 rows=5,144 loops=1)

  • Hash Cond: (pr.id_type_profil = tp.id_type_profil)
6. 2.689 3.728 ↑ 1.0 5,144 1

Hash Join (cost=1.38..114.70 rows=5,144 width=80) (actual time=0.033..3.728 rows=5,144 loops=1)

  • Hash Cond: (ac.id_profil = pr.id_profil)
7. 1.022 1.022 ↑ 1.0 5,144 1

Seq Scan on acces ac (cost=0.00..96.44 rows=5,144 width=40) (actual time=0.008..1.022 rows=5,144 loops=1)

8. 0.008 0.017 ↑ 1.0 17 1

Hash (cost=1.17..1.17 rows=17 width=48) (actual time=0.017..0.017 rows=17 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 10kB
9. 0.009 0.009 ↑ 1.0 17 1

Seq Scan on profil pr (cost=0.00..1.17 rows=17 width=48) (actual time=0.005..0.009 rows=17 loops=1)

10. 0.004 0.015 ↑ 1.0 2 1

Hash (cost=1.02..1.02 rows=2 width=40) (actual time=0.015..0.015 rows=2 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 9kB
11. 0.011 0.011 ↑ 1.0 2 1

Seq Scan on type_profil tp (cost=0.00..1.02 rows=2 width=40) (actual time=0.009..0.011 rows=2 loops=1)

12. 0.337 0.765 ↓ 1.0 941 1

Hash (cost=62.36..62.36 rows=936 width=29) (actual time=0.765..0.765 rows=941 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 59kB
13. 0.428 0.428 ↓ 1.0 941 1

Seq Scan on societe so (cost=0.00..62.36 rows=936 width=29) (actual time=0.006..0.428 rows=941 loops=1)

14. 0.007 0.015 ↓ 1.2 16 1

Hash (cost=1.13..1.13 rows=13 width=20) (actual time=0.015..0.015 rows=16 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 9kB
15. 0.008 0.008 ↓ 1.2 16 1

Seq Scan on portefeuille po (cost=0.00..1.13 rows=13 width=20) (actual time=0.004..0.008 rows=16 loops=1)