explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 9azm

Settings
# exclusive inclusive rows x rows loops node
1. 4.115 448.497 ↓ 149.3 2,240 1

Sort (cost=1,130.09..1,130.13 rows=15 width=78) (actual time=448.022..448.497 rows=2,240 loops=1)

  • Sort Key: p.pk_rel, d.date_heure
  • Sort Method: quicksort Memory: 272kB
2.          

CTE postes

3. 0.509 0.509 ↓ 1.1 35 1

Seq Scan on ref_poste (cost=0.00..8.04 rows=32 width=26) (actual time=0.049..0.509 rows=35 loops=1)

  • Filter: ((id_chaussee = 2) AND (((pk >= '0'::double precision) AND (pk <= '10'::real)) OR ((pk >= '28'::real) AND (pk <= '35.04'::double precision))))
  • Rows Removed by Filter: 171
4. 2.620 444.382 ↓ 149.3 2,240 1

Hash Join (cost=1.04..1,121.76 rows=15 width=78) (actual time=91.837..444.382 rows=2,240 loops=1)

  • Hash Cond: (d.id_poste = p.id)
5. 441.208 441.208 ↓ 133.2 13,184 1

Seq Scan on donnees_1h_poste d (cost=0.00..1,120.20 rows=99 width=16) (actual time=91.266..441.208 rows=13,184 loops=1)

  • Filter: ((date_heure >= '2016-02-18'::date) AND (date_heure <= '2016-02-22'::date) AND ((date_heure)::time without time zone >= '06:00:00'::time without time zone) AND ((date_heure)::time withou
  • Rows Removed by Filter: 21424
6. 0.027 0.554 ↓ 1.1 35 1

Hash (cost=0.64..0.64 rows=32 width=70) (actual time=0.554..0.554 rows=35 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 11kB
7. 0.527 0.527 ↓ 1.1 35 1

CTE Scan on postes p (cost=0.00..0.64 rows=32 width=70) (actual time=0.053..0.527 rows=35 loops=1)