On Tue, Nov 7, 2017 at 2:52 AM, Nicolas MARTIN <ntm...@locean.upmc.fr> wrote:
> $ time trac-admin ~/trac/ session purge "09/01/17 00:00:00"
> 18:34:31 Trac[env] INFO: -------------------------------- environment
> startup [Trac 1.0.1] --------------------------------
> ...
> 18:34:32 Trac[util] DEBUG: SQL:
> DELETE FROM session
> WHERE authenticated=0 AND last_visit<%s
>
> 18:34:32 Trac[util] DEBUG: args: (1504216800,)
> 18:34:32 Trac[util] DEBUG: SQL:
> DELETE FROM session_attribute
> WHERE authenticated=0
> AND sid NOT IN (SELECT sid FROM session
> WHERE authenticated=0)
> real 1m55.482s
> user 0m0.790s
> sys 0m0.090s
>
> [nemo@forge ~]$ psql -c "SELECT COUNT(*) FROM session;"
> count
> -------
> 32116
>
> I'm quite a newbie in SQL stuff but from my standpoint these 2 minutes are
> much too long for parsing the database.
>
> Couldn't we have a hidden issue here ?
Could you please share results of the following explain queries?
====
EXPLAIN DELETE FROM session WHERE authenticated=0 AND last_visit<1504216800;
EXPLAIN DELETE FROM session_attribute
WHERE authenticated=0
AND sid NOT IN (SELECT sid FROM session WHERE authenticated=0);
====
--
Jun Omae <jun6...@gmail.com> (大前 潤)
--
You received this message because you are subscribed to the Google Groups "Trac
Users" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to trac-users+unsubscr...@googlegroups.com.
To post to this group, send email to trac-users@googlegroups.com.
Visit this group at https://groups.google.com/group/trac-users.
For more options, visit https://groups.google.com/d/optout.
