explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Uf2T : 3.1

Settings
# exclusive inclusive rows x rows loops node
1. 0.189 3.454 ↑ 2.0 99 1

Hash Join (cost=326.64..391.86 rows=200 width=69) (actual time=2.343..3.454 rows=99 loops=1)

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

CTE mrc

3. 0.022 0.728 ↓ 6.6 99 1

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

4. 0.052 0.706 ↓ 6.7 100 1

Sort (cost=81.13..81.17 rows=15 width=69) (actual time=0.702..0.706 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.040 0.654 ↓ 6.7 100 1

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

6. 0.271 0.514 ↓ 6.7 100 1

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

  • Hash Cond: (oto.id_type_organisme = t.id)
7. 0.231 0.231 ↓ 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.006..0.231 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.351 2.005 ↑ 1.0 2,662 1

Unique (cost=231.38..244.69 rows=2,662 width=24) (actual time=1.534..2.005 rows=2,662 loops=1)

13. 0.925 1.654 ↓ 1.0 2,671 1

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

  • Sort Key: ijo_1.id_organisme, ijo_1.date_debut DESC
  • Sort Method: quicksort Memory: 288kB
14. 0.729 0.729 ↓ 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.009..0.729 rows=2,671 loops=1)

  • Filter: (date_debut <= now())
15. 2.495 2.495 ↑ 1.0 2,662 1

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

16. 0.020 0.770 ↓ 6.6 99 1

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

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

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

Planning time : 0.389 ms
Execution time : 3.534 ms