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 vote284 views1 answer
Jooq replace
SQL
7 votes278 views4 answers
How to reset the identity column in sql server
SQL
0 vote330 views1 answer
Disable database droping sql
SQL
0 vote312 views1 answer
Example database query
SQL
0 vote290 views1 answer
Retornar apenas o ano mysql date
SQL
3 votes293 views1 answer
Ssh check mysql version
SQL
0 vote327 views1 answer
Sql script to remove default from column
SQL
1 vote281 views2 answers
Sqlalchemy.exc.OperationalError: (sqlite3.OperationalError) unable to open database file
SQL
0 vote324 views1 answer
Check database restore status sql script
SQL
1 vote280 views2 answers
Mysql does sentance contain word
SQL