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 vote238 views3 answers
Remove folders from remote git
SQL
0 vote261 views1 answer
Mengatasi error mysqldump: [ERROR] unknown option '--no-beep'
SQL
0 vote243 views1 answer
Postgresql linux password
SQL
0 vote241 views1 answer
Sql shell psql cannot enter password
SQL
0 vote246 views2 answers
Call to undefined function mysqli_fetch_all()
SQL
0 vote234 views1 answer
Enable full text search mysql
SQL
0 vote209 views1 answer
Mysql find non alphanumeric characters
SQL
0 vote234 views1 answer
Oracle sql alter view add column
SQL
0 vote250 views1 answer
T-sql delete view if exists
SQL
9 votes235 views4 answers
How to create new user and database postgresql in ubuntu
SQL