explain.depesz.com

PostgreSQL's explain analyze made readable

Result: gYLp : 3.0

Settings
# exclusive inclusive rows x rows loops node
1. 0.221 3.539 ↑ 2.0 100 1

Hash Join (cost=333.30..398.52 rows=200 width=69) (actual time=2.442..3.539 rows=100 loops=1)

  • Hash Cond: (ijo.id_organisme = mrc.id)
2.          

CTE mrc

3. 0.024 0.731 ↓ 6.6 99 1

Unique (cost=81.13..81.47 rows=15 width=69) (actual time=0.703..0.731 rows=99 loops=1)

4. 0.051 0.707 ↓ 6.7 100 1

Sort (cost=81.13..81.17 rows=15 width=69) (actual time=0.703..0.707 rows=100 loops=1)

  • Sort Key: o.id, o.identifiant, o.identifiant_alternatif, o.uuid, o.commentaire_population, o.actif, o.date_debut, o.date_fin
  • Sort Method: quicksort Memory: 32kB
5. 0.042 0.656 ↓ 6.7 100 1

Nested Loop (cost=17.94..80.84 rows=15 width=69) (actual time=0.052..0.656 rows=100 loops=1)

6. 0.255 0.514 ↓ 6.7 100 1

Hash Join (cost=17.66..75.26 rows=15 width=4) (actual time=0.040..0.514 rows=100 loops=1)

  • Hash Cond: (oto.id_type_organisme = t.id)
7. 0.247 0.247 ↓ 1.0 3,026 1

Seq Scan on organisme_type_organisme oto (cost=0.00..49.74 rows=2,974 width=8) (actual time=0.011..0.247 rows=3,026 loops=1)

8. 0.003 0.012 ↑ 3.0 1 1

Hash (cost=17.62..17.62 rows=3 width=4) (actual time=0.012..0.012 rows=1 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
9. 0.009 0.009 ↑ 3.0 1 1

Seq Scan on type_organisme t (cost=0.00..17.62 rows=3 width=4) (actual time=0.007..0.009 rows=1 loops=1)

  • Filter: (code = '35'::text)
  • Rows Removed by Filter: 47
10. 0.100 0.100 ↑ 1.0 1 100

Index Scan using organisme_pkey on organisme o (cost=0.28..0.37 rows=1 width=69) (actual time=0.001..0.001 rows=1 loops=100)

  • Index Cond: (id = oto.id_organisme)
11.          

CTE ijo

12. 0.402 2.133 ↓ 1.0 2,666 1

Unique (cost=231.38..251.34 rows=2,662 width=24) (actual time=1.628..2.133 rows=2,666 loops=1)

13. 0.939 1.731 ↓ 1.0 2,671 1

Sort (cost=231.38..238.03 rows=2,662 width=24) (actual time=1.625..1.731 rows=2,671 loops=1)

  • Sort Key: ijo_1.id_organisme, ijo_1.nom_officiel, ijo_1.date_debut DESC
  • Sort Method: quicksort Memory: 288kB
14. 0.792 0.792 ↓ 1.0 2,671 1

Seq Scan on information_juridique_organisme ijo_1 (cost=0.00..79.93 rows=2,662 width=24) (actual time=0.012..0.792 rows=2,671 loops=1)

  • Filter: (date_debut <= now())
15. 2.547 2.547 ↓ 1.0 2,666 1

CTE Scan on ijo (cost=0.00..53.24 rows=2,662 width=36) (actual time=1.630..2.547 rows=2,666 loops=1)

16. 0.019 0.771 ↓ 6.6 99 1

Hash (cost=0.30..0.30 rows=15 width=37) (actual time=0.771..0.771 rows=99 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 13kB
17. 0.752 0.752 ↓ 6.6 99 1

CTE Scan on mrc (cost=0.00..0.30 rows=15 width=37) (actual time=0.704..0.752 rows=99 loops=1)

Planning time : 0.514 ms
Execution time : 3.643 ms