explain.depesz.com

PostgreSQL's explain analyze made readable

Result: zoA

Settings
# exclusive inclusive rows x rows loops node
1. 20.591 26.401 ↓ 1.1 21,773 1

Bitmap Heap Scan on sensor_informe_x_1 (cost=557.00..60,128.39 rows=20,335 width=62) (actual time=6.259..26.401 rows=21,773 loops=1)

  • Recheck Cond: (((s_cod)::text = 'PLMTRHR'::text) AND (si_fecha_gmt4 > '2015-01-01 00:00:00'::timestamp without time zone))
  • Heap Blocks: exact=1668
2. 5.810 5.810 ↓ 1.1 21,773 1

Bitmap Index Scan on si1_pk (cost=0.00..551.91 rows=20,335 width=0) (actual time=5.810..5.810 rows=21,773 loops=1)