explain.depesz.com

A tool for finding a real cause for slow queries.

Result: mny

options
Did it help? Consider supporting us - Bitcoin address: 12v2hUztAk2LgzQ9H9LMwuU32urHMjZQnq
# exclusive inclusive rows x rows loops node
1. 3.498 13.205 ↓ 1.3 4,934 1

Result (cost=0.00..13,220.78 rows=3,699 width=242) (actual time=1.716..13.205 rows=4,934 loops=1)

2. 1.714 9.707 ↓ 1.3 4,934 1

Append (cost=0.00..13,220.78 rows=3,699 width=242) (actual time=1.712..9.707 rows=4,934 loops=1)

3. 0.001 0.001 ↓ 0.0 0 1

Seq Scan on historial_posicion_1 (cost=0.00..15.78 rows=1 width=213) (actual time=0.001..0.001 rows=0 loops=1)

  • Filter: ((updatetime >= '2012-04-01 00:00:00'::timestamp without time zone) AND (updatetime <= '2012-04-01 23:59:59'::timestamp without time zone) AND (vehiculo = 101))
4. 6.840 7.992 ↓ 1.3 4,934 1

Bitmap Heap Scan on historial_posicion_14_2012 historial_posicion_1 (cost=156.36..13,205.01 rows=3,698 width=242) (actual time=1.710..7.992 rows=4,934 loops=1)

  • Recheck Cond: ((vehiculo = 101) AND (updatetime >= '2012-04-01 00:00:00'::timestamp without time zone) AND (updatetime <= '2012-04-01 23:59:59'::timestamp without time zone))
5. 1.152 1.152 ↓ 1.3 4,934 1

Bitmap Index Scan on idx_historial_posicion_14_2012_vh_uptm (cost=0.00..155.43 rows=3,698 width=0) (actual time=1.152..1.152 rows=4,934 loops=1)

  • Index Cond: ((vehiculo = 101) AND (updatetime >= '2012-04-01 00:00:00'::timestamp without time zone) AND (updatetime <= '2012-04-01 23:59:59'::timestamp without time zone))