gistfile1.txt

cotest=# show enable_seqscan;
 enable_seqscan 
----------------
 off
(1 row)

Time: 0.326 ms
cotest=# SELECT * FROM test WHERE coordinates && '0101000020E6100000DE205A2BDA5856C0685C381092894540';
 id |                    coordinates                     |     created_at      |         updated_at         
----+----------------------------------------------------+---------------------+----------------------------
  1 | 0101000020E6100000DE205A2BDA5856C0685C381092894540 | 2008-02-02 00:00:00 | 2008-10-21 21:40:17.071026
(1 row)

cotest=# UPDATE test SET created_at = '2/1/2008' WHERE id = 1;
UPDATE 1
Time: 1.977 ms
cotest=# SELECT * FROM test WHERE coordinates && '0101000020E6100000DE205A2BDA5856C0685C381092894540';
 id |                    coordinates                     |     created_at      |         updated_at         
----+----------------------------------------------------+---------------------+----------------------------
  1 | 0101000020E6100000DE205A2BDA5856C0685C381092894540 | 2008-02-01 00:00:00 | 2008-10-21 21:40:17.071026
(1 row)

Time: 1.013 ms
cotest=# SELECT * FROM test WHERE coordinates && '0101000020E6100000DE205A2BDA5856C0685C381092894540';
 id |                    coordinates                     |     created_at      |         updated_at         
----+----------------------------------------------------+---------------------+----------------------------
  1 | 0101000020E6100000DE205A2BDA5856C0685C381092894540 | 2008-02-01 00:00:00 | 2008-10-21 21:40:17.071026
(1 row)

cotest=# explain analyze SELECT * FROM test WHERE coordinates && '0101000020E6100000DE205A2BDA5856C0685C381092894540';
                                                         QUERY PLAN                                                         
----------------------------------------------------------------------------------------------------------------------------
 Index Scan using test_coordinates_ix on test  (cost=0.00..8.27 rows=1 width=120) (actual time=0.142..0.144 rows=1 loops=1)
   Index Cond: (coordinates && '0101000020E6100000DE205A2BDA5856C0685C381092894540'::geometry)
   Filter: (coordinates && '0101000020E6100000DE205A2BDA5856C0685C381092894540'::geometry)
 Total runtime: 0.227 ms
(4 rows)

Time: 0.902 ms