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 vote312 views1 answer
How to Remove milliseconds from Date time
SQL
0 vote281 views10 answers
John the ripper mysql
SQL
1 vote303 views1 answer
Oracle finding duplicate records
SQL
27 votes312 views6 answers
Set password mysql
SQL
1 vote312 views1 answer
Job for mariadb.service failed because the control process exited with error code. see "systemctl status mariadb.service" and "journalctl -xe" for details.
SQL
22 votes318 views3 answers
Remove all records from table mysql
SQL
3 votes393 views1 answer
Oracle nextval insert
SQL
0 vote284 views1 answer
Strat with in sql
SQL
0 vote337 views1 answer
Postgresql inheritance
SQL
50 votes368 views4 answers
Sql alter type of column
SQL