explain.depesz.com

PostgreSQL's explain analyze made readable

Result: LZX9

Settings
# exclusive inclusive rows x rows loops node
1. 49.571 62.111 ↓ 1.1 36,540 1

Bitmap Heap Scan on sensor_informe_x_1 (cost=873.02..85,589.70 rows=32,045 width=62) (actual time=13.133..62.111 rows=36,540 loops=1)

  • Recheck Cond: (((s_cod)::text = 'PLMTRHR'::text) AND (si_fecha_gmt4 > '2010-01-01 00:00:00'::timestamp without time zone))
  • Heap Blocks: exact=1851
2. 12.540 12.540 ↓ 1.1 36,540 1

Bitmap Index Scan on si1_pk (cost=0.00..865.01 rows=32,045 width=0) (actual time=12.540..12.540 rows=36,540 loops=1)