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

-1 vote229 views1 answer
Mysql coalesce
SQL
1 vote182 views1 answer
Tsql update datetime
SQL
2 votes184 views3 answers
Mysql list tables by size
SQL
0 vote174 views2 answers
SQLSTATE[42S22]: Column not found: 1054 Unknown column 'created at' in 'field list' (SQL: insert into `categories` (`category_name`, `user_id`, `created at`) values (sea fish, 1, 2021-09-24 04:17:31))
SQL
31 votes189 views3 answers
Sql count
SQL
24 votes187 views5 answers
Import dump mysql
SQL
0 vote188 views1 answer
Postgres grep entire database
SQL
5 votes206 views2 answers
Oracle show procedures
SQL
1 vote187 views2 answers
How to install sql server management studio in ubuntu 18.04
SQL
0 vote166 views1 answer
Ms sql unique
SQL