explain.depesz.com

PostgreSQL's explain analyze made readable

Result: iV5l

Settings
# exclusive inclusive rows x rows loops node
1. 0.040 10.139 ↑ 1.0 1 1

Aggregate (cost=1,938.79..1,938.80 rows=1 width=32) (actual time=10.139..10.139 rows=1 loops=1)

2.          

CTE view_saisie_temp

3. 0.021 10.077 ↓ 1.6 8 1

Hash Right Join (cost=1,938.30..1,938.53 rows=5 width=40) (actual time=10.065..10.077 rows=8 loops=1)

  • Hash Cond: (ec.id_entry_origin = eo.id_entry_origin)
4. 0.012 10.035 ↑ 1.6 5 1

Sort (cost=1,937.11..1,937.13 rows=8 width=16) (actual time=10.034..10.035 rows=5 loops=1)

  • Sort Key: ec.id_entry_origin
  • Sort Method: quicksort Memory: 25kB
5. 0.589 10.023 ↑ 1.6 5 1

HashAggregate (cost=1,936.91..1,936.99 rows=8 width=16) (actual time=10.021..10.023 rows=5 loops=1)

  • Group Key: ec.id_entry_origin
6. 1.299 9.434 ↓ 1.1 1,373 1

Nested Loop (cost=0.87..1,930.65 rows=1,253 width=16) (actual time=0.048..9.434 rows=1,373 loops=1)

7. 0.372 5.389 ↓ 1.1 1,373 1

Nested Loop (cost=0.58..1,545.31 rows=1,253 width=24) (actual time=0.038..5.389 rows=1,373 loops=1)

8. 0.898 0.898 ↓ 1.1 1,373 1

Index Scan using ndx_sch1_sch_ecriture_temp_1 on ecriture_temp ec (cost=0.29..252.88 rows=1,253 width=24) (actual time=0.025..0.898 rows=1,373 loops=1)

  • Index Cond: (id_etablissement = 2)
  • Filter: (id_entry_origin = ANY ('{1,2,3,4,5,6,7,8}'::bigint[]))
9. 4.119 4.119 ↑ 1.0 1 1,373

Index Scan using sch_jaltps_pkey on jaltps j (cost=0.29..1.03 rows=1 width=16) (actual time=0.003..0.003 rows=1 loops=1,373)

  • Index Cond: (jaltps_id = ec.jaltps_id)
10. 2.746 2.746 ↑ 1.0 1 1,373

Index Only Scan using sch_journal_pkey on journal jal (cost=0.29..0.31 rows=1 width=8) (actual time=0.002..0.002 rows=1 loops=1,373)

  • Index Cond: (id_journal = j.diary_id)
  • Heap Fetches: 1,342
11. 0.005 0.021 ↓ 1.6 8 1

Hash (cost=1.12..1.12 rows=5 width=8) (actual time=0.021..0.021 rows=8 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 9kB
12. 0.016 0.016 ↓ 1.6 8 1

Seq Scan on entry_origin eo (cost=0.00..1.12 rows=5 width=8) (actual time=0.011..0.016 rows=8 loops=1)

  • Filter: (id_entry_origin = ANY ('{1,2,3,4,5,6,7,8}'::bigint[]))
  • Rows Removed by Filter: 1
13. 0.015 10.099 ↑ 1.0 5 1

HashAggregate (cost=0.12..0.19 rows=5 width=64) (actual time=10.096..10.099 rows=5 loops=1)

  • Group Key: vst.code
14. 10.084 10.084 ↓ 1.6 8 1

CTE Scan on view_saisie_temp vst (cost=0.00..0.10 rows=5 width=40) (actual time=10.068..10.084 rows=8 loops=1)

Planning time : 1.123 ms