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 vote156 views1 answer
Automated psql csv export script on windows
SQL
0 vote146 views1 answer
Populate db from command line postgres
SQL
9 votes136 views4 answers
How to remove duplicate in sql
SQL
0 vote162 views1 answer
Postgresql port 5432 not open
SQL
0 vote133 views1 answer
What is logical database schema
SQL
0 vote148 views1 answer
Connect to nginx server mysql remotly
SQL
0 vote191 views1 answer
Oracle show running job
SQL
1 vote130 views1 answer
Error code 1175 mysql fix
SQL
0 vote163 views1 answer
Postgres change the name of schema
SQL
0 vote160 views1 answer
Tablas bootstrap responsive sql server para datos vivos
SQL