explain.depesz.com

PostgreSQL's explain analyze made readable

Result: eq3d

Settings
# exclusive inclusive rows x rows loops node
1. 0.115 5,628.880 ↑ 1,818,031.3 73 1

Sort (cost=385,367,067.51..385,698,858.23 rows=132,716,287 width=882) (actual time=5,628.877..5,628.880 rows=73 loops=1)

  • Sort Key: res.analyz, (to_char(tub.dh_resultat, 'YYYYMMDDHH24MI'::text))
  • Sort Method: quicksort Memory: 22kB
2. 937.510 5,628.765 ↑ 1,818,031.3 73 1

Hash Join (cost=6,385.01..5,472,266.57 rows=132,716,287 width=882) (actual time=4,487.376..5,628.765 rows=73 loops=1)

  • Hash Cond: ((res.numtube)::text = (tub.numtube)::text)
3. 3,202.599 4,691.232 ↑ 1.0 11,520,511 1

Hash Left Join (cost=66.51..466,046.28 rows=11,520,511 width=874) (actual time=0.512..4,691.232 rows=11,520,511 loops=1)

  • Hash Cond: ((res.analyz)::text = (a.analyz)::text)
4. 1,488.131 1,488.131 ↑ 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.005..1,488.131 rows=11,520,511 loops=1)

5. 0.252 0.502 ↑ 1.0 1,667 1

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

  • Buckets: 1024 Batches: 1 Memory Usage: 66kB
6. 0.250 0.250 ↑ 1.0 1,667 1

Seq Scan on analyses a (cost=0.00..45.67 rows=1,667 width=72) (actual time=0.003..0.250 rows=1,667 loops=1)

7. 0.003 0.023 ↑ 576.0 4 1

Hash (cost=6,289.71..6,289.71 rows=2,304 width=244) (actual time=0.023..0.023 rows=4 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 1kB
8. 0.004 0.020 ↑ 576.0 4 1

Bitmap Heap Scan on tubejour_tout tub (cost=54.18..6,289.71 rows=2,304 width=244) (actual time=0.019..0.020 rows=4 loops=1)

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

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

  • Index Cond: ((numpermanent)::text = '362682-16'::text)"Total runtime: 5628.968 ms