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

4 votes229 views1 answer
Mysql set max connections
SQL
1 vote204 views2 answers
Postgres copy table from one schema to another
SQL
0 vote254 views1 answer
Mql5 datetime get hour
SQL
2 votes203 views1 answer
Add default sql server
SQL
6 votes191 views4 answers
Eloquent to sql with bindings
SQL
0 vote207 views1 answer
Sql server separar numeros por comas miles
SQL
2 votes233 views1 answer
Sqlite insert if not exists
SQL
3 votes196 views1 answer
Oracle wait
SQL
2 votes186 views1 answer
Ssh mysql port forwarding
SQL
1 vote192 views1 answer
Mysql select utc time in eastern time
SQL