explain.depesz.com

PostgreSQL's explain analyze made readable

Result: bArg

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

Aggregate (cost=189,622.93..189,622.94 rows=1 width=32) (actual rows= loops=)

2. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on sensor_informe_x_0 (cost=7,946.47..187,522.61 rows=210,032 width=32) (actual rows= loops=)

  • Recheck Cond: (((s_cod)::text = 'COMBRS2'::text) AND (si_fecha_gmt4 >= '2015-01-01 00:00:00'::timestamp without time zone) AND (si_fecha_gmt4 <= '2018-12-31 23:59:59'::timestamp without time zone))
3. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on si0_pk (cost=0.00..7,893.96 rows=210,032 width=0) (actual rows= loops=)

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