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

0 vote292 views2 answers
Avg() sql
SQL
0 vote313 views1 answer
Write a PL/SQL to print even numbers upto 100.
SQL
2 votes324 views1 answer
Mysql last 7 days including today
SQL
0 vote282 views2 answers
SQLSTATE[HY000] [2054] The server requested authenticatio n method unknown to the client (SQL: select * from information_schema.tables where table_schema = todos_app and table_name = migrations and table_type = 'BASE TABLE')
SQL
1 vote323 views1 answer
Tsql get beginning of year
SQL
3 votes306 views2 answers
WhereIn SQL
SQL
0 vote310 views2 answers
Insert into
SQL
7 votes329 views4 answers
Lowest salary in sql
SQL
38 votes410 views6 answers
Ubuntu install mysql client
SQL
0 vote306 views1 answer
Sql grant select only
SQL