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

12 votes256 views4 answers
Mysql version
SQL
0 vote270 views1 answer
Insert or update sql firebird
SQL
6 votes263 views2 answers
Difference between join vs union
SQL
0 vote320 views1 answer
Postgres extract number from string
SQL
11 votes280 views6 answers
Mysql else if
SQL
0 vote262 views1 answer
Subquery aggregation
SQL
5 votes261 views1 answer
Mysql created at yesterdau
SQL
0 vote244 views1 answer
Sqlite referential integrity
SQL
5 votes246 views1 answer
Ascending order and where in sql
SQL
0 vote247 views1 answer
Generate random & unique mysql string
SQL