Postgresql datetrunc too slow

CREATE INDEX ON test (date_trunc('day', updated_at));

/*If updated_at is a timestamp without time zone, that will work fine. 
For a timestamp with time zone, you'll have to specify a time zone, 
because otherwise the result will depend on the session time zone, 
which makes it unusable for an index:*/

CREATE INDEX ON test (date_trunc('day', updated_at AT TIME ZONE 'UTC'));

Source: stackoverflow.com

Similar codes

8 votes291 views6 answers
Sql insert
SQL
0 vote255 views1 answer
Postgres call view
SQL
0 vote263 views1 answer
Org.apache.spark.sql.avro.IncompatibleSchemaException: Unexpected type org.apache.spark.ml.linalg.VectorUDT
SQL
2 votes223 views1 answer
Sql select in list
SQL
-1 vote281 views1 answer
Search all sql tables for a value
SQL
5 votes275 views1 answer
Commentaire table oracle
SQL
32 votes270 views6 answers
Insert into values select
SQL
0 vote255 views2 answers
Azure sql-datenbank
SQL
21 votes270 views5 answers
Oracle all tables
SQL
2 votes248 views1 answer
Sql select min value from multiple columns
SQL