explain.depesz.com

A tool for finding a real cause for slow queries.

Result: mny

options
# exclusive inclusive rows x rows loops node
1. 3.498 13.205 ↓ 1.3 4934 1
→

Result (cost=0.00..13220.78 rows=3699 width=242) (actual time=1.716..13.205 rows=4934 loops=1)

2. 1.714 9.707 ↓ 1.3 4934 1
→

Append (cost=0.00..13220.78 rows=3699 width=242) (actual time=1.712..9.707 rows=4934 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 4934 1
→

Bitmap Heap Scan on historial_posicion_14_2012 historial_posicion_1 (cost=156.36..13205.01 rows=3698 width=242) (actual time=1.710..7.992 rows=4934 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 4934 1
→

Bitmap Index Scan on idx_historial_posicion_14_2012_vh_uptm (cost=0.00..155.43 rows=3698 width=0) (actual time=1.152..1.152 rows=4934 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))