explain.depesz.com

PostgreSQL's explain analyze made readable

Result: tGHT

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=6,128.97..9,020.22 rows=9,077 width=52) (actual rows= loops=)

  • Hash Cond: ((date(calendario_hora.ch_fechahora) = date(qhora2.si_fecha_gmt4)) AND (date_part('hour'::text, calendario_hora.ch_fechahora) = date_part('hour'::text, qhora2.si_fecha_gmt4)))
2. 0.000 0.000 ↓ 0.0

Index Only Scan using __pk__12 on calendario_hora (cost=0.42..281.96 rows=9,077 width=8) (actual rows= loops=)

  • Index Cond: ((ch_fechahora >= '2018-01-01 00:00:00'::timestamp without time zone) AND (ch_fechahora <= '2018-12-31 23:59:59'::timestamp without time zone))
3. 0.000 0.000 ↓ 0.0

Hash (cost=6,128.08..6,128.08 rows=31 width=40) (actual rows= loops=)

4. 0.000 0.000 ↓ 0.0

Subquery Scan on qhora2 (cost=6,127.70..6,128.08 rows=31 width=40) (actual rows= loops=)

5. 0.000 0.000 ↓ 0.0

Sort (cost=6,127.70..6,127.77 rows=31 width=36) (actual rows= loops=)

  • Sort Key: (min(si.si_fecha_gmt4))
6. 0.000 0.000 ↓ 0.0

HashAggregate (cost=6,126.46..6,126.93 rows=31 width=36) (actual rows= loops=)

  • Group Key: date(si.si_fecha_gmt4), date_part('hour'::text, si.si_fecha_gmt4)
7. 0.000 0.000 ↓ 0.0

Subquery Scan on si (cost=6,124.99..6,125.92 rows=31 width=36) (actual rows= loops=)

8. 0.000 0.000 ↓ 0.0

HashAggregate (cost=6,124.99..6,125.46 rows=31 width=32) (actual rows= loops=)

  • Group Key: date(sensor_informe_x_1.si_fecha_gmt4), date_part('hour'::text, sensor_informe_x_1.si_fecha_gmt4)
9. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on sensor_informe_x_1 (cost=65.12..6,101.65 rows=1,556 width=32) (actual rows= loops=)

  • Recheck Cond: (((s_cod)::text = 'LAGHUsufu'::text) AND (si_fecha_gmt4 >= '2018-01-01 00:00:00'::timestamp without time zone) AND (si_fecha_gmt4 <= '2018-12-31 23:59:59'::timestamp without time zone))
  • Filter: ((si_min <> 'NaN'::double precision) AND (si_prom <> 'NaN'::double precision) AND (si_max <> 'NaN'::double precision) AND (si_estado < 2))
10. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on si1_pk (cost=0.00..64.73 rows=1,614 width=0) (actual rows= loops=)

  • Index Cond: (((s_cod)::text = 'LAGHUsufu'::text) AND (si_fecha_gmt4 >= '2018-01-01 00:00:00'::timestamp without time zone) AND (si_fecha_gmt4 <= '2018-12-31 23:59:59'::timestamp without time zone))