explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Q3Nf

Settings
# exclusive inclusive rows x rows loops node
1. 0.118 2,413.591 ↑ 9,468.9 73 1

Sort (cost=1,506,192.37..1,507,920.45 rows=691,231 width=882) (actual time=2,413.587..2,413.591 rows=73 loops=1)

  • Sort Key: res.analyz, (to_char(tub.dh_resultat, 'YYYYMMDDHH24MI'::text))
  • Sort Method: quicksort Memory: 22kB
2.          

CTE tub

3. 0.005 0.024 ↑ 576.0 4 1

Bitmap Heap Scan on tubejour_tout (cost=54.18..6,289.71 rows=2,304 width=362) (actual time=0.022..0.024 rows=4 loops=1)

  • Recheck Cond: ((numpermanent)::text = '362682-16'::text)
4. 0.019 0.019 ↑ 576.0 4 1

Bitmap Index Scan on idx_tubejour_tout5 (cost=0.00..53.60 rows=2,304 width=0) (actual time=0.019..0.019 rows=4 loops=1)

  • Index Cond: ((numpermanent)::text = '362682-16'::text)
5. 0.080 2,413.473 ↑ 9,468.9 73 1

Hash Left Join (cost=118.50..355,501.38 rows=691,231 width=882) (actual time=1,495.697..2,413.473 rows=73 loops=1)

  • Hash Cond: ((res.analyz)::text = (a.analyz)::text)
6. 983.627 2,412.867 ↑ 9,468.9 73 1

Hash Join (cost=51.99..343,338.33 rows=691,231 width=878) (actual time=1,495.149..2,412.867 rows=73 loops=1)

  • Hash Cond: ((res.numtube)::text = (tub.numtube)::text)
7. 1,429.210 1,429.210 ↑ 1.0 11,520,511 1

Seq Scan on resjour_tout res (cost=0.00..293,172.11 rows=11,520,511 width=870) (actual time=0.006..1,429.210 rows=11,520,511 loops=1)

8. 0.001 0.030 ↑ 3.0 4 1

Hash (cost=51.84..51.84 rows=12 width=244) (actual time=0.030..0.030 rows=4 loops=1)

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

CTE Scan on tub (cost=0.00..51.84 rows=12 width=244) (actual time=0.025..0.029 rows=4 loops=1)

  • Filter: ((numpermanent)::text = '362682-16'::text)
10. 0.526 0.526 ↑ 1.0 1,667 1

Hash (cost=45.67..45.67 rows=1,667 width=72) (actual time=0.526..0.526 rows=1,667 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 66kB
  • -> Seq Scan on analyses a (cost=0.00..45.67 rows=1667 width=72) (actual time=0.004..0.256 rows=1667 loops=1)"Total runtime: 2413.684 ms