Vous n'êtes pas identifié(e).
- Contributions : Récentes | Sans réponse
#1 Re : Optimisation » Des requêtes lentes, plus de 10 minutes par requête! » 27/04/2009 15:45:34
Merci beaucoup Marc, je suis vraiment impressionné par votre talent, merci aussi pour Gleu pour son assistance qui m'a apprit beaucoup de choses.
Je restaure donc ma table sur la nouvelle machine, construit la nouvelle table et son index, et je reviens ici pour annoncer le résultat.
A bientôt. 
#2 Re : Optimisation » Des requêtes lentes, plus de 10 minutes par requête! » 27/04/2009 13:38:37
Je pense que oui, cela est vrai. Il y a beaucoup de valeurs répétées pour chaque colonnes de la manière que vous avez décrite.
#3 Re : Optimisation » Des requêtes lentes, plus de 10 minutes par requête! » 27/04/2009 11:56:04
Bonjour,
Je ne suis pas sur d'avoir saisit votre question: si vous voulez dire ordonner les lignes au sein de la même table, il me semble que les trier par rapport a la première colonne imposera l'ordre déjà pour les autres colonnes, donc on ne pourra pas ordonner après selon les colonnes suivantes.
Mais si vous voulez dire dans les autres tables, je pense que oui, les contenus des colonnes sont sembles.
Par la même occasion, je ne pense pas que la maintenance pour les nombreuses tables sera pénible, puisqu'il n'y a pas ni d'insertion, ni suppression, juste des sélection.
Un temps raisonnable pour ces requêtes serait peut être de 10 secondes.
Sinon, n'importe quelle autre suggestion?
#4 Re : Optimisation » Des requêtes lentes, plus de 10 minutes par requête! » 26/04/2009 21:59:40
Maintenant je déménage l'application pour la nouvelle machine, et j'attends vos commentaires
#5 Re : Optimisation » Des requêtes lentes, plus de 10 minutes par requête! » 26/04/2009 21:57:44
Et finalement le iostat de la requête sur la colonne 4:
avg-cpu: %user %nice %system %iowait %steal %idle
6.06 0.00 1.01 92.93 0.00 0.00
Device: rrqm/s wrqm/s r/s w/s rMB/s wMB/s avgrq-sz avgqu-sz await svctm %util
sda 0.00 0.00 134.00 0.00 0.88 0.00 13.37 0.99 7.46 7.40 99.20
avg-cpu: %user %nice %system %iowait %steal %idle
6.00 0.00 1.00 93.00 0.00 0.00
Device: rrqm/s wrqm/s r/s w/s rMB/s wMB/s avgrq-sz avgqu-sz await svctm %util
sda 0.00 0.00 129.00 0.00 0.81 0.00 12.84 1.02 7.91 7.75 100.00
avg-cpu: %user %nice %system %iowait %steal %idle
6.00 0.00 2.00 92.00 0.00 0.00
Device: rrqm/s wrqm/s r/s w/s rMB/s wMB/s avgrq-sz avgqu-sz await svctm %util
sda 0.00 18.00 107.00 1.00 0.70 0.05 14.15 1.10 9.22 9.15 98.80
avg-cpu: %user %nice %system %iowait %steal %idle
5.94 0.00 1.98 92.08 0.00 0.00
Device: rrqm/s wrqm/s r/s w/s rMB/s wMB/s avgrq-sz avgqu-sz await svctm %util
sda 0.00 0.00 124.00 2.00 0.98 0.04 16.44 1.14 9.87 7.94 100.00
avg-cpu: %user %nice %system %iowait %steal %idle
5.05 0.00 2.02 92.93 0.00 0.00
Device: rrqm/s wrqm/s r/s w/s rMB/s wMB/s avgrq-sz avgqu-sz await svctm %util
sda 0.00 0.00 164.00 0.00 1.47 0.00 18.34 1.01 6.17 6.07 99.60
avg-cpu: %user %nice %system %iowait %steal %idle
6.93 0.00 2.97 90.10 0.00 0.00
Device: rrqm/s wrqm/s r/s w/s rMB/s wMB/s avgrq-sz avgqu-sz await svctm %util
sda 0.00 0.00 151.00 0.00 1.34 0.00 18.17 1.01 6.73 6.60 99.60
avg-cpu: %user %nice %system %iowait %steal %idle
7.00 0.00 1.00 92.00 0.00 0.00
Device: rrqm/s wrqm/s r/s w/s rMB/s wMB/s avgrq-sz avgqu-sz await svctm %util
sda 0.00 0.00 135.00 0.00 1.09 0.00 16.59 1.00 7.32 7.38 99.60
avg-cpu: %user %nice %system %iowait %steal %idle
6.06 0.00 1.01 92.93 0.00 0.00
Device: rrqm/s wrqm/s r/s w/s rMB/s wMB/s avgrq-sz avgqu-sz await svctm %util
sda 4.00 0.00 168.00 0.00 1.57 0.00 19.19 1.00 5.95 5.90 99.20
avg-cpu: %user %nice %system %iowait %steal %idle
6.93 0.00 2.97 90.10 0.00 0.00
Device: rrqm/s wrqm/s r/s w/s rMB/s wMB/s avgrq-sz avgqu-sz await svctm %util
sda 0.00 18.00 129.00 1.00 0.95 0.05 15.69 1.10 7.78 7.57 98.40
avg-cpu: %user %nice %system %iowait %steal %idle
6.00 0.00 1.00 93.00 0.00 0.00
Device: rrqm/s wrqm/s r/s w/s rMB/s wMB/s avgrq-sz avgqu-sz await svctm %util
sda 0.00 0.00 115.00 4.00 0.78 0.04 14.12 1.20 10.86 8.40 100.00
avg-cpu: %user %nice %system %iowait %steal %idle
6.00 0.00 1.00 93.00 0.00 0.00
Device: rrqm/s wrqm/s r/s w/s rMB/s wMB/s avgrq-sz avgqu-sz await svctm %util
sda 1.00 0.00 152.00 0.00 1.56 0.00 21.00 1.00 6.53 6.53 99.20
avg-cpu: %user %nice %system %iowait %steal %idle
5.94 0.00 2.97 91.09 0.00 0.00
Device: rrqm/s wrqm/s r/s w/s rMB/s wMB/s avgrq-sz avgqu-sz await svctm %util
sda 1.00 0.00 125.00 0.00 1.11 0.00 18.18 1.00 8.00 7.97 99.60
avg-cpu: %user %nice %system %iowait %steal %idle
6.06 0.00 1.01 92.93 0.00 0.00
Device: rrqm/s wrqm/s r/s w/s rMB/s wMB/s avgrq-sz avgqu-sz await svctm %util
sda 1.00 0.00 142.00 0.00 1.07 0.00 15.44 0.99 6.90 6.99 99.20
avg-cpu: %user %nice %system %iowait %steal %idle
6.00 0.00 1.00 93.00 0.00 0.00
Device: rrqm/s wrqm/s r/s w/s rMB/s wMB/s avgrq-sz avgqu-sz await svctm %util
sda 0.00 0.00 165.00 0.00 1.48 0.00 18.33 1.00 6.11 6.04 99.60
avg-cpu: %user %nice %system %iowait %steal %idle
6.00 0.00 2.00 92.00 0.00 0.00
Device: rrqm/s wrqm/s r/s w/s rMB/s wMB/s avgrq-sz avgqu-sz await svctm %util
sda 0.00 19.00 130.00 3.00 1.09 0.05 17.62 1.30 9.68 7.52 100.00
avg-cpu: %user %nice %system %iowait %steal %idle
6.00 0.00 0.00 94.00 0.00 0.00
Device: rrqm/s wrqm/s r/s w/s rMB/s wMB/s avgrq-sz avgqu-sz await svctm %util
sda 0.00 0.00 113.00 2.00 0.73 0.04 13.63 1.08 9.60 8.70 100.00
avg-cpu: %user %nice %system %iowait %steal %idle
6.93 0.00 1.98 91.09 0.00 0.00
Device: rrqm/s wrqm/s r/s w/s rMB/s wMB/s avgrq-sz avgqu-sz await svctm %util
sda 0.00 0.00 120.00 0.00 0.86 0.00 14.73 1.00 8.30 8.30 99.60
avg-cpu: %user %nice %system %iowait %steal %idle
6.06 0.00 1.01 92.93 0.00 0.00
Device: rrqm/s wrqm/s r/s w/s rMB/s wMB/s avgrq-sz avgqu-sz await svctm %util
sda 0.00 0.00 134.00 0.00 0.96 0.00 14.63 1.02 7.55 7.43 99.60
avg-cpu: %user %nice %system %iowait %steal %idle
6.93 0.00 0.99 92.08 0.00 0.00
Device: rrqm/s wrqm/s r/s w/s rMB/s wMB/s avgrq-sz avgqu-sz await svctm %util
sda 0.00 0.00 136.00 0.00 1.01 0.00 15.24 1.00 7.35 7.35 100.00
avg-cpu: %user %nice %system %iowait %steal %idle
6.06 0.00 3.03 90.91 0.00 0.00
Device: rrqm/s wrqm/s r/s w/s rMB/s wMB/s avgrq-sz avgqu-sz await svctm %util
sda 0.00 0.00 127.00 2.00 0.89 0.01 14.33 1.06 8.19 7.69 99.20
avg-cpu: %user %nice %system %iowait %steal %idle
5.94 0.00 0.99 93.07 0.00 0.00
Device: rrqm/s wrqm/s r/s w/s rMB/s wMB/s avgrq-sz avgqu-sz await svctm %util
sda 0.00 18.00 128.00 1.00 0.93 0.05 15.44 1.12 7.97 7.72 99.60
avg-cpu: %user %nice %system %iowait %steal %idle
6.00 0.00 2.00 92.00 0.00 0.00
Device: rrqm/s wrqm/s r/s w/s rMB/s wMB/s avgrq-sz avgqu-sz await svctm %util
sda 0.00 0.00 146.00 2.00 1.08 0.04 15.46 1.12 8.22 6.73 99.60
avg-cpu: %user %nice %system %iowait %steal %idle
6.06 0.00 1.01 92.93 0.00 0.00
Device: rrqm/s wrqm/s r/s w/s rMB/s wMB/s avgrq-sz avgqu-sz await svctm %util
sda 0.00 0.00 147.00 0.00 1.16 0.00 16.11 0.99 6.72 6.75 99.20
avg-cpu: %user %nice %system %iowait %steal %idle
5.94 0.00 2.97 91.09 0.00 0.00
Device: rrqm/s wrqm/s r/s w/s rMB/s wMB/s avgrq-sz avgqu-sz await svctm %util
sda 1.00 0.00 154.00 0.00 1.27 0.00 16.83 1.00 6.52 6.49 100.00
avg-cpu: %user %nice %system %iowait %steal %idle
6.00 0.00 2.00 92.00 0.00 0.00
Device: rrqm/s wrqm/s r/s w/s rMB/s wMB/s avgrq-sz avgqu-sz await svctm %util
sda 0.00 0.00 126.00 0.00 0.98 0.00 15.94 0.99 7.81 7.87 99.20
avg-cpu: %user %nice %system %iowait %steal %idle
6.00 0.00 1.00 93.00 0.00 0.00
Device: rrqm/s wrqm/s r/s w/s rMB/s wMB/s avgrq-sz avgqu-sz await svctm %util
sda 0.00 0.00 152.00 0.00 1.55 0.00 20.95 1.01 6.66 6.58 100.00
avg-cpu: %user %nice %system %iowait %steal %idle
6.06 0.00 1.01 92.93 0.00 0.00
Device: rrqm/s wrqm/s r/s w/s rMB/s wMB/s avgrq-sz avgqu-sz await svctm %util
sda 0.00 18.00 123.00 1.00 0.92 0.05 16.00 1.11 8.19 8.00 99.20
avg-cpu: %user %nice %system %iowait %steal %idle
6.06 0.00 1.01 92.93 0.00 0.00
Device: rrqm/s wrqm/s r/s w/s rMB/s wMB/s avgrq-sz avgqu-sz await svctm %util
sda 0.00 0.00 104.00 2.00 0.65 0.04 13.28 1.17 12.00 9.43 100.00
avg-cpu: %user %nice %system %iowait %steal %idle
7.84 0.00 0.98 91.18 0.00 0.00
Device: rrqm/s wrqm/s r/s w/s rMB/s wMB/s avgrq-sz avgqu-sz await svctm %util
sda 0.00 0.00 163.00 0.00 1.43 0.00 18.01 0.99 6.09 6.09 99.20
avg-cpu: %user %nice %system %iowait %steal %idle
6.00 0.00 1.00 93.00 0.00 0.00
Device: rrqm/s wrqm/s r/s w/s rMB/s wMB/s avgrq-sz avgqu-sz await svctm %util
sda 0.00 0.00 158.00 0.00 1.34 0.00 17.32 1.00 6.28 6.33 100.00
avg-cpu: %user %nice %system %iowait %steal %idle
4.00 0.00 4.00 92.00 0.00 0.00
Device: rrqm/s wrqm/s r/s w/s rMB/s wMB/s avgrq-sz avgqu-sz await svctm %util
sda 0.00 0.00 146.00 0.00 1.03 0.00 14.41 0.99 6.77 6.77 98.80
avg-cpu: %user %nice %system %iowait %steal %idle
6.06 0.00 1.01 92.93 0.00 0.00
Device: rrqm/s wrqm/s r/s w/s rMB/s wMB/s avgrq-sz avgqu-sz await svctm %util
sda 0.00 0.00 142.00 0.00 0.94 0.00 13.52 1.00 7.10 7.04 100.00
avg-cpu: %user %nice %system %iowait %steal %idle
5.94 0.00 0.99 93.07 0.00 0.00
Device: rrqm/s wrqm/s r/s w/s rMB/s wMB/s avgrq-sz avgqu-sz await svctm %util
sda 0.00 18.00 124.00 1.00 0.77 0.05 13.44 1.12 8.42 7.97 99.60
avg-cpu: %user %nice %system %iowait %steal %idle
7.07 0.00 0.00 92.93 0.00 0.00
Device: rrqm/s wrqm/s r/s w/s rMB/s wMB/s avgrq-sz avgqu-sz await svctm %util
sda 0.00 0.00 103.00 2.00 0.74 0.04 15.09 1.16 11.58 9.52 100.00
avg-cpu: %user %nice %system %iowait %steal %idle
6.00 0.00 0.00 94.00 0.00 0.00
Device: rrqm/s wrqm/s r/s w/s rMB/s wMB/s avgrq-sz avgqu-sz await svctm %util
sda 0.00 0.00 122.00 0.00 0.79 0.00 13.18 1.00 8.23 8.16 99.60
avg-cpu: %user %nice %system %iowait %steal %idle
7.00 0.00 2.00 91.00 0.00 0.00
Device: rrqm/s wrqm/s r/s w/s rMB/s wMB/s avgrq-sz avgqu-sz await svctm %util
sda 0.00 0.00 121.00 0.00 0.76 0.00 12.83 0.99 8.13 8.17 98.80
avg-cpu: %user %nice %system %iowait %steal %idle
6.00 0.00 1.00 93.00 0.00 0.00
Device: rrqm/s wrqm/s r/s w/s rMB/s wMB/s avgrq-sz avgqu-sz await svctm %util
sda 0.00 19.00 91.00 4.00 0.56 0.09 13.98 1.80 17.60 10.53 100.00
avg-cpu: %user %nice %system %iowait %steal %idle
6.00 0.00 2.00 92.00 0.00 0.00
Device: rrqm/s wrqm/s r/s w/s rMB/s wMB/s avgrq-sz avgqu-sz await svctm %util
sda 0.00 2.00 110.00 4.00 0.70 0.02 12.91 1.36 12.95 8.77 100.00
avg-cpu: %user %nice %system %iowait %steal %idle
5.94 0.00 1.98 92.08 0.00 0.00
Device: rrqm/s wrqm/s r/s w/s rMB/s wMB/s avgrq-sz avgqu-sz await svctm %util
sda 0.00 0.00 127.00 0.00 1.05 0.00 17.01 1.00 7.97 7.87 100.00
avg-cpu: %user %nice %system %iowait %steal %idle
5.05 0.00 2.02 92.93 0.00 0.00
Device: rrqm/s wrqm/s r/s w/s rMB/s wMB/s avgrq-sz avgqu-sz await svctm %util
sda 0.00 0.00 130.00 0.00 0.94 0.00 14.83 0.99 7.60 7.60 98.80
avg-cpu: %user %nice %system %iowait %steal %idle
9.00 0.00 0.00 91.00 0.00 0.00
Device: rrqm/s wrqm/s r/s w/s rMB/s wMB/s avgrq-sz avgqu-sz await svctm %util
sda 0.00 0.00 115.00 0.00 0.73 0.00 13.08 0.99 8.63 8.52 98.00
avg-cpu: %user %nice %system %iowait %steal %idle
6.00 0.00 2.00 92.00 0.00 0.00
Device: rrqm/s wrqm/s r/s w/s rMB/s wMB/s avgrq-sz avgqu-sz await svctm %util
sda 0.00 0.00 156.00 0.00 1.80 0.00 23.64 1.00 6.41 6.36 99.20
avg-cpu: %user %nice %system %iowait %steal %idle
7.92 0.00 0.00 92.08 0.00 0.00
Device: rrqm/s wrqm/s r/s w/s rMB/s wMB/s avgrq-sz avgqu-sz await svctm %util
sda 0.00 18.00 124.00 3.00 0.89 0.08 15.62 1.28 10.02 7.81 99.20
avg-cpu: %user %nice %system %iowait %steal %idle
6.06 0.00 1.01 92.93 0.00 0.00
Device: rrqm/s wrqm/s r/s w/s rMB/s wMB/s avgrq-sz avgqu-sz await svctm %util
sda 0.00 0.00 135.00 0.00 0.89 0.00 13.51 1.02 7.59 7.41 100.00
avg-cpu: %user %nice %system %iowait %steal %idle
6.93 0.00 0.99 92.08 0.00 0.00
Device: rrqm/s wrqm/s r/s w/s rMB/s wMB/s avgrq-sz avgqu-sz await svctm %util
sda 0.00 0.00 110.00 2.00 0.74 0.01 13.71 1.09 9.71 8.86 99.20
avg-cpu: %user %nice %system %iowait %steal %idle
5.05 0.00 0.00 94.95 0.00 0.00
Device: rrqm/s wrqm/s r/s w/s rMB/s wMB/s avgrq-sz avgqu-sz await svctm %util
sda 0.00 0.00 112.00 0.00 0.73 0.00 13.29 1.00 8.89 8.89 99.60
avg-cpu: %user %nice %system %iowait %steal %idle
6.00 0.00 2.00 92.00 0.00 0.00
Device: rrqm/s wrqm/s r/s w/s rMB/s wMB/s avgrq-sz avgqu-sz await svctm %util
sda 0.00 0.00 123.00 0.00 0.80 0.00 13.33 0.99 8.03 8.03 98.80
avg-cpu: %user %nice %system %iowait %steal %idle
7.00 0.00 2.00 91.00 0.00 0.00
Device: rrqm/s wrqm/s r/s w/s rMB/s wMB/s avgrq-sz avgqu-sz await svctm %util
sda 0.00 19.00 124.00 3.00 0.90 0.05 15.37 1.17 8.19 7.81 99.20
avg-cpu: %user %nice %system %iowait %steal %idle
7.00 0.00 0.00 93.00 0.00 0.00
Device: rrqm/s wrqm/s r/s w/s rMB/s wMB/s avgrq-sz avgqu-sz await svctm %util
sda 0.00 0.00 113.00 2.00 0.74 0.04 13.91 1.15 11.13 8.63 99.20
avg-cpu: %user %nice %system %iowait %steal %idle
5.94 0.00 1.98 92.08 0.00 0.00
Device: rrqm/s wrqm/s r/s w/s rMB/s wMB/s avgrq-sz avgqu-sz await svctm %util
sda 0.00 0.00 113.00 0.00 0.81 0.00 14.73 1.00 8.85 8.81 99.60
avg-cpu: %user %nice %system %iowait %steal %idle
6.00 0.00 1.00 93.00 0.00 0.00
Device: rrqm/s wrqm/s r/s w/s rMB/s wMB/s avgrq-sz avgqu-sz await svctm %util
sda 0.00 0.00 97.00 0.00 0.61 0.00 12.87 0.99 10.14 10.23 99.20
avg-cpu: %user %nice %system %iowait %steal %idle
6.06 0.00 0.00 93.94 0.00 0.00
Device: rrqm/s wrqm/s r/s w/s rMB/s wMB/s avgrq-sz avgqu-sz await svctm %util
sda 0.00 0.00 115.00 0.00 0.71 0.00 12.73 0.99 8.73 8.63 99.20
avg-cpu: %user %nice %system %iowait %steal %idle
6.06 0.00 2.02 91.92 0.00 0.00
Device: rrqm/s wrqm/s r/s w/s rMB/s wMB/s avgrq-sz avgqu-sz await svctm %util
sda 0.00 0.00 119.00 0.00 0.78 0.00 13.38 1.00 8.37 8.37 99.60
avg-cpu: %user %nice %system %iowait %steal %idle
5.94 0.00 1.98 92.08 0.00 0.00
Device: rrqm/s wrqm/s r/s w/s rMB/s wMB/s avgrq-sz avgqu-sz await svctm %util
sda 0.00 18.00 117.00 1.00 0.77 0.05 14.10 1.12 8.98 8.47 100.00
avg-cpu: %user %nice %system %iowait %steal %idle
8.00 0.00 1.00 91.00 0.00 0.00
Device: rrqm/s wrqm/s r/s w/s rMB/s wMB/s avgrq-sz avgqu-sz await svctm %util
sda 0.00 1.00 95.00 10.00 0.64 0.07 13.87 1.34 13.37 9.45 99.20
avg-cpu: %user %nice %system %iowait %steal %idle
6.00 0.00 2.00 92.00 0.00 0.00
Device: rrqm/s wrqm/s r/s w/s rMB/s wMB/s avgrq-sz avgqu-sz await svctm %util
sda 0.00 0.00 115.00 0.00 0.85 0.00 15.10 1.00 8.70 8.66 99.60
avg-cpu: %user %nice %system %iowait %steal %idle
7.00 0.00 1.00 92.00 0.00 0.00
Device: rrqm/s wrqm/s r/s w/s rMB/s wMB/s avgrq-sz avgqu-sz await svctm %util
sda 0.00 0.00 112.00 0.00 0.71 0.00 13.00 1.00 8.82 8.89 99.60
avg-cpu: %user %nice %system %iowait %steal %idle
6.93 0.00 1.98 91.09 0.00 0.00
Device: rrqm/s wrqm/s r/s w/s rMB/s wMB/s avgrq-sz avgqu-sz await svctm %util
sda 0.00 0.00 126.00 0.00 0.85 0.00 13.84 1.00 7.97 7.90 99.60
avg-cpu: %user %nice %system %iowait %steal %idle
5.00 0.00 3.00 92.00 0.00 0.00
Device: rrqm/s wrqm/s r/s w/s rMB/s wMB/s avgrq-sz avgqu-sz await svctm %util
sda 0.00 0.00 113.00 0.00 0.79 0.00 14.30 0.99 8.74 8.78 99.20
avg-cpu: %user %nice %system %iowait %steal %idle
6.06 0.00 1.01 92.93 0.00 0.00
Device: rrqm/s wrqm/s r/s w/s rMB/s wMB/s avgrq-sz avgqu-sz await svctm %util
sda 0.00 18.00 104.00 1.00 0.66 0.05 13.71 1.11 9.87 9.45 99.20
avg-cpu: %user %nice %system %iowait %steal %idle
6.93 0.00 1.98 91.09 0.00 0.00
Device: rrqm/s wrqm/s r/s w/s rMB/s wMB/s avgrq-sz avgqu-sz await svctm %util
sda 0.00 0.00 103.00 2.00 0.67 0.04 13.79 1.15 11.66 9.49 99.60
avg-cpu: %user %nice %system %iowait %steal %idle
5.00 0.00 2.00 93.00 0.00 0.00
Device: rrqm/s wrqm/s r/s w/s rMB/s wMB/s avgrq-sz avgqu-sz await svctm %util
sda 1.00 0.00 115.00 0.00 1.04 0.00 18.43 1.00 8.73 8.70 100.00
avg-cpu: %user %nice %system %iowait %steal %idle
7.00 0.00 0.00 93.00 0.00 0.00
Device: rrqm/s wrqm/s r/s w/s rMB/s wMB/s avgrq-sz avgqu-sz await svctm %util
sda 0.00 0.00 131.00 0.00 0.88 0.00 13.80 0.99 7.57 7.57 99.20
avg-cpu: %user %nice %system %iowait %steal %idle
6.00 0.00 1.00 93.00 0.00 0.00
Device: rrqm/s wrqm/s r/s w/s rMB/s wMB/s avgrq-sz avgqu-sz await svctm %util
sda 0.00 0.00 141.00 0.00 1.71 0.00 24.79 1.00 7.04 7.06 99.60
avg-cpu: %user %nice %system %iowait %steal %idle
6.00 0.00 1.00 93.00 0.00 0.00
Device: rrqm/s wrqm/s r/s w/s rMB/s wMB/s avgrq-sz avgqu-sz await svctm %util
sda 1.00 0.00 154.00 0.00 1.52 0.00 20.21 1.53 10.00 6.49 100.00
avg-cpu: %user %nice %system %iowait %steal %idle
7.00 0.00 1.00 92.00 0.00 0.00
Device: rrqm/s wrqm/s r/s w/s rMB/s wMB/s avgrq-sz avgqu-sz await svctm %util
sda 0.00 22.00 110.00 1.00 0.79 0.05 15.42 1.11 9.44 8.97 99.60
avg-cpu: %user %nice %system %iowait %steal %idle
6.00 0.00 1.00 93.00 0.00 0.00
Device: rrqm/s wrqm/s r/s w/s rMB/s wMB/s avgrq-sz avgqu-sz await svctm %util
sda 0.00 0.00 100.00 2.00 0.62 0.05 13.41 1.19 12.20 9.76 99.60
avg-cpu: %user %nice %system %iowait %steal %idle
6.00 0.00 0.00 94.00 0.00 0.00
Device: rrqm/s wrqm/s r/s w/s rMB/s wMB/s avgrq-sz avgqu-sz await svctm %util
sda 0.00 0.00 116.00 0.00 0.76 0.00 13.45 1.00 8.69 8.62 100.00
avg-cpu: %user %nice %system %iowait %steal %idle
7.00 0.00 1.00 92.00 0.00 0.00
Device: rrqm/s wrqm/s r/s w/s rMB/s wMB/s avgrq-sz avgqu-sz await svctm %util
sda 0.00 0.00 117.00 0.00 0.74 0.00 12.99 1.00 8.51 8.51 99.60
avg-cpu: %user %nice %system %iowait %steal %idle
5.00 0.00 1.00 94.00 0.00 0.00
Device: rrqm/s wrqm/s r/s w/s rMB/s wMB/s avgrq-sz avgqu-sz await svctm %util
sda 0.00 0.00 122.00 0.00 0.91 0.00 15.28 1.00 8.26 8.20 100.00
avg-cpu: %user %nice %system %iowait %steal %idle
7.00 0.00 1.00 92.00 0.00 0.00
Device: rrqm/s wrqm/s r/s w/s rMB/s wMB/s avgrq-sz avgqu-sz await svctm %util
sda 0.00 0.00 109.00 0.00 0.69 0.00 12.99 1.00 9.14 9.14 99.60
avg-cpu: %user %nice %system %iowait %steal %idle
6.06 0.00 1.01 92.93 0.00 0.00
Device: rrqm/s wrqm/s r/s w/s rMB/s wMB/s avgrq-sz avgqu-sz await svctm %util
sda 0.00 18.00 101.00 1.00 0.62 0.05 13.49 1.12 10.55 9.80 100.00
avg-cpu: %user %nice %system %iowait %steal %idle
6.00 0.00 1.00 93.00 0.00 0.00
Device: rrqm/s wrqm/s r/s w/s rMB/s wMB/s avgrq-sz avgqu-sz await svctm %util
sda 1.00 0.00 109.00 2.00 1.05 0.04 19.96 1.18 10.99 9.01 100.00
avg-cpu: %user %nice %system %iowait %steal %idle
6.00 0.00 1.00 93.00 0.00 0.00
Device: rrqm/s wrqm/s r/s w/s rMB/s wMB/s avgrq-sz avgqu-sz await svctm %util
sda 0.00 0.00 119.00 0.00 0.81 0.00 13.98 1.00 8.37 8.37 99.60
avg-cpu: %user %nice %system %iowait %steal %idle
6.93 0.00 0.99 92.08 0.00 0.00
Device: rrqm/s wrqm/s r/s w/s rMB/s wMB/s avgrq-sz avgqu-sz await svctm %util
sda 0.00 0.00 116.00 0.00 0.85 0.00 15.03 1.26 10.86 8.52 98.80
avg-cpu: %user %nice %system %iowait %steal %idle
5.05 0.00 1.01 93.94 0.00 0.00
Device: rrqm/s wrqm/s r/s w/s rMB/s wMB/s avgrq-sz avgqu-sz await svctm %util
sda 0.00 0.00 113.00 0.00 0.77 0.00 13.88 1.00 8.81 8.81 99.60
avg-cpu: %user %nice %system %iowait %steal %idle
7.92 0.00 0.99 91.09 0.00 0.00
Device: rrqm/s wrqm/s r/s w/s rMB/s wMB/s avgrq-sz avgqu-sz await svctm %util
sda 0.00 0.00 132.00 0.00 1.09 0.00 16.91 0.98 7.39 7.42 98.00
avg-cpu: %user %nice %system %iowait %steal %idle
6.00 0.00 4.00 90.00 0.00 0.00
Device: rrqm/s wrqm/s r/s w/s rMB/s wMB/s avgrq-sz avgqu-sz await svctm %util
sda 0.00 49.00 123.00 6.00 0.84 0.13 15.38 1.60 12.22 7.75 100.00
avg-cpu: %user %nice %system %iowait %steal %idle
6.00 0.00 1.00 93.00 0.00 0.00
Device: rrqm/s wrqm/s r/s w/s rMB/s wMB/s avgrq-sz avgqu-sz await svctm %util
sda 0.00 0.00 83.00 2.00 0.54 0.09 15.25 1.24 14.87 11.72 99.60
avg-cpu: %user %nice %system %iowait %steal %idle
18.00 0.00 2.00 8.00 0.00 72.00
Device: rrqm/s wrqm/s r/s w/s rMB/s wMB/s avgrq-sz avgqu-sz await svctm %util
sda 0.00 0.00 8.00 2.00 0.05 0.01 12.00 0.11 11.20 11.20 11.20
avg-cpu: %user %nice %system %iowait %steal %idle
2.97 0.00 0.00 0.00 0.00 97.03
Device: rrqm/s wrqm/s r/s w/s rMB/s wMB/s avgrq-sz avgqu-sz await svctm %util
sda 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
avg-cpu: %user %nice %system %iowait %steal %idle
11.00 0.00 1.00 0.00 0.00 88.00
Device: rrqm/s wrqm/s r/s w/s rMB/s wMB/s avgrq-sz avgqu-sz await svctm %util
sda 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
avg-cpu: %user %nice %system %iowait %steal %idle
3.00 0.00 0.00 0.00 0.00 97.00
Device: rrqm/s wrqm/s r/s w/s rMB/s wMB/s avgrq-sz avgqu-sz await svctm %util
sda 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00#6 Re : Optimisation » Des requêtes lentes, plus de 10 minutes par requête! » 26/04/2009 21:55:54
Et une dernière fois pour la colonne la plus chiante, la 4 eme:
Requête:
explain analyze select * from fourgrams where lower(part4)='ham' order by freq desc
----------
"Sort (cost=99245.27..99305.78 rows=24206 width=28) (actual time=115311.557..115321.557 rows=11391 loops=1)"
" Sort Key: freq"
" Sort Method: external merge Disk: 448kB"
" -> Index Scan using part4_idx on fourgrams (cost=0.00..96943.70 rows=24206 width=28) (actual time=134.015..115255.306 rows=11391 loops=1)"
" Index Cond: (lower((part4)::text) = 'ham'::text)"
"Total runtime: 115326.717 ms"
-----------
LOG: EXECUTOR STATISTICS
DETAIL: ! system usage stats:
! 115.327146 elapsed 0.188012 user 1.064066 system sec
! [23259.749643 user 736.966057 sys total]
! 222920/896 [500575440/211104568] filesystem blocks in/out
! 0/199 [4/16141] page faults/reclaims, 0 [0] swaps
! 0 [0] signals rcvd, 0/0 [0/0] messages rcvd/sent
! 14642/4 [1561816/5420965] voluntary/involuntary context switches
! buffer usage stats:
! Shared blocks: 10601 read, 0 written, buffer hit rate = 0.06%
! Local blocks: 0 read, 0 written, buffer hit rate = 0.00%
! Direct blocks: 0 read, 0 written
Total query runtime: 115355 ms.
6 rows retrieved.#7 Re : Optimisation » Des requêtes lentes, plus de 10 minutes par requête! » 26/04/2009 21:51:43
Encore une fois pour la colonne 1:
Requête:
explain analyze select * from fourgrams where lower(part1)='ham' order by freq desc
--------
"Sort (cost=85706.94..85779.84 rows=29163 width=28) (actual time=300.397..315.992 rows=12068 loops=1)"
" Sort Key: freq"
" Sort Method: external merge Disk: 472kB"
" -> Index Scan using part1_idx on fourgrams (cost=0.00..82893.23 rows=29163 width=28) (actual time=131.684..263.224 rows=12068 loops=1)"
" Index Cond: (lower((part1)::text) = 'ham'::text)"
"Total runtime: 323.489 ms"
-------
LOG: EXECUTOR STATISTICS
DETAIL: ! system usage stats:
! 0.372393 elapsed 0.056003 user 0.000000 system sec
! [23259.561631 user 735.897990 sys total]
! 3136/944 [500352520/211103664] filesystem blocks in/out
! 0/199 [4/15942] page faults/reclaims, 0 [0] swaps
! 0 [0] signals rcvd, 0/0 [0/0] messages rcvd/sent
! 28/15 [1547169/5420959] voluntary/involuntary context switches
! buffer usage stats:
! Shared blocks: 118 read, 0 written, buffer hit rate = 4.84%
! Local blocks: 0 read, 0 written, buffer hit rate = 0.00%
! Direct blocks: 0 read, 0 written
Total query runtime: 402 ms.
6 rows retrieved.et iostat:
Linux 2.6.24-23-generic (admin2-desktop) 26/04/09
avg-cpu: %user %nice %system %iowait %steal %idle
12.49 0.01 0.83 4.09 0.00 82.58
Device: rrqm/s wrqm/s r/s w/s rMB/s wMB/s avgrq-sz avgqu-sz await svctm %util
sda 4.64 98.33 15.82 3.94 1.24 0.40 170.17 1.44 72.85 3.89 7.69
avg-cpu: %user %nice %system %iowait %steal %idle
4.00 0.00 0.00 0.00 0.00 96.00
Device: rrqm/s wrqm/s r/s w/s rMB/s wMB/s avgrq-sz avgqu-sz await svctm %util
sda 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
avg-cpu: %user %nice %system %iowait %steal %idle
21.00 0.00 2.00 0.00 0.00 77.00
Device: rrqm/s wrqm/s r/s w/s rMB/s wMB/s avgrq-sz avgqu-sz await svctm %util
sda 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
avg-cpu: %user %nice %system %iowait %steal %idle
19.00 0.00 1.00 0.00 0.00 80.00
Device: rrqm/s wrqm/s r/s w/s rMB/s wMB/s avgrq-sz avgqu-sz await svctm %util
sda 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
avg-cpu: %user %nice %system %iowait %steal %idle
37.62 0.00 3.96 17.82 0.00 40.59
Device: rrqm/s wrqm/s r/s w/s rMB/s wMB/s avgrq-sz avgqu-sz await svctm %util
sda 1.00 4.00 41.00 20.00 1.53 0.09 54.56 0.48 7.93 5.31 32.40
avg-cpu: %user %nice %system %iowait %steal %idle
11.11 0.00 0.00 0.00 0.00 88.89
Device: rrqm/s wrqm/s r/s w/s rMB/s wMB/s avgrq-sz avgqu-sz await svctm %util
sda 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
avg-cpu: %user %nice %system %iowait %steal %idle
8.00 0.00 1.00 0.00 0.00 91.00
Device: rrqm/s wrqm/s r/s w/s rMB/s wMB/s avgrq-sz avgqu-sz await svctm %util
sda 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
avg-cpu: %user %nice %system %iowait %steal %idle
1.98 0.00 0.99 0.00 0.00 97.03
Device: rrqm/s wrqm/s r/s w/s rMB/s wMB/s avgrq-sz avgqu-sz await svctm %util
sda 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00#8 Re : Optimisation » Des requêtes lentes, plus de 10 minutes par requête! » 26/04/2009 21:48:56
et l'historique de iostat:
Linux 2.6.24-23-generic (admin2-desktop) 26/04/09
avg-cpu: %user %nice %system %iowait %steal %idle
12.50 0.01 0.83 4.08 0.00 82.58
Device: rrqm/s wrqm/s r/s w/s rMB/s wMB/s avgrq-sz avgqu-sz await svctm %util
sda 4.64 98.39 15.82 3.94 1.24 0.40 170.22 1.44 72.87 3.89 7.68
avg-cpu: %user %nice %system %iowait %steal %idle
1.01 0.00 0.00 0.00 0.00 98.99
Device: rrqm/s wrqm/s r/s w/s rMB/s wMB/s avgrq-sz avgqu-sz await svctm %util
sda 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
avg-cpu: %user %nice %system %iowait %steal %idle
4.00 0.00 0.00 0.00 0.00 96.00
Device: rrqm/s wrqm/s r/s w/s rMB/s wMB/s avgrq-sz avgqu-sz await svctm %util
sda 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
avg-cpu: %user %nice %system %iowait %steal %idle
7.92 0.00 0.99 0.00 0.00 91.09
Device: rrqm/s wrqm/s r/s w/s rMB/s wMB/s avgrq-sz avgqu-sz await svctm %util
sda 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
avg-cpu: %user %nice %system %iowait %steal %idle
3.00 0.00 1.00 0.00 0.00 96.00
Device: rrqm/s wrqm/s r/s w/s rMB/s wMB/s avgrq-sz avgqu-sz await svctm %util
sda 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
avg-cpu: %user %nice %system %iowait %steal %idle
4.00 0.00 0.00 0.00 0.00 96.00
Device: rrqm/s wrqm/s r/s w/s rMB/s wMB/s avgrq-sz avgqu-sz await svctm %util
sda 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
avg-cpu: %user %nice %system %iowait %steal %idle
12.00 0.00 2.00 76.00 0.00 10.00
Device: rrqm/s wrqm/s r/s w/s rMB/s wMB/s avgrq-sz avgqu-sz await svctm %util
sda 1.00 0.00 129.00 0.00 1.35 0.00 21.40 0.84 6.45 6.51 84.00
avg-cpu: %user %nice %system %iowait %steal %idle
5.05 0.00 2.02 92.93 0.00 0.00
Device: rrqm/s wrqm/s r/s w/s rMB/s wMB/s avgrq-sz avgqu-sz await svctm %util
sda 0.00 0.00 119.00 0.00 0.76 0.00 13.11 1.00 8.44 8.40 100.00
avg-cpu: %user %nice %system %iowait %steal %idle
7.00 0.00 0.00 93.00 0.00 0.00
Device: rrqm/s wrqm/s r/s w/s rMB/s wMB/s avgrq-sz avgqu-sz await svctm %util
sda 0.00 0.00 122.00 0.00 1.17 0.00 19.67 1.02 8.26 8.10 98.80
avg-cpu: %user %nice %system %iowait %steal %idle
5.00 0.00 2.00 93.00 0.00 0.00
Device: rrqm/s wrqm/s r/s w/s rMB/s wMB/s avgrq-sz avgqu-sz await svctm %util
sda 0.00 20.00 102.00 3.00 0.70 0.09 15.31 1.22 11.73 9.41 98.80
avg-cpu: %user %nice %system %iowait %steal %idle
4.95 0.00 2.97 92.08 0.00 0.00
Device: rrqm/s wrqm/s r/s w/s rMB/s wMB/s avgrq-sz avgqu-sz await svctm %util
sda 0.00 0.00 104.00 0.00 0.73 0.00 14.31 0.99 9.46 9.50 98.80
avg-cpu: %user %nice %system %iowait %steal %idle
5.05 0.00 1.01 93.94 0.00 0.00
Device: rrqm/s wrqm/s r/s w/s rMB/s wMB/s avgrq-sz avgqu-sz await svctm %util
sda 0.00 0.00 115.00 0.00 0.80 0.00 14.19 1.00 8.59 8.70 100.00
avg-cpu: %user %nice %system %iowait %steal %idle
5.00 0.00 3.00 92.00 0.00 0.00
Device: rrqm/s wrqm/s r/s w/s rMB/s wMB/s avgrq-sz avgqu-sz await svctm %util
sda 0.00 0.00 106.00 0.00 0.76 0.00 14.72 1.00 9.47 9.40 99.60
avg-cpu: %user %nice %system %iowait %steal %idle
6.00 0.00 0.00 94.00 0.00 0.00
Device: rrqm/s wrqm/s r/s w/s rMB/s wMB/s avgrq-sz avgqu-sz await svctm %util
sda 0.00 0.00 124.00 0.00 0.85 0.00 14.00 1.00 8.10 8.06 100.00
avg-cpu: %user %nice %system %iowait %steal %idle
5.94 0.00 1.98 92.08 0.00 0.00
Device: rrqm/s wrqm/s r/s w/s rMB/s wMB/s avgrq-sz avgqu-sz await svctm %util
sda 0.00 0.00 112.00 8.00 0.81 0.03 14.33 1.24 10.30 8.20 98.40
avg-cpu: %user %nice %system %iowait %steal %idle
6.06 0.00 2.02 91.92 0.00 0.00
Device: rrqm/s wrqm/s r/s w/s rMB/s wMB/s avgrq-sz avgqu-sz await svctm %util
sda 1.00 19.00 103.00 5.00 1.02 0.09 21.04 1.33 12.37 9.07 98.00
avg-cpu: %user %nice %system %iowait %steal %idle
6.00 0.00 2.00 92.00 0.00 0.00
Device: rrqm/s wrqm/s r/s w/s rMB/s wMB/s avgrq-sz avgqu-sz await svctm %util
sda 0.00 0.00 114.00 0.00 0.87 0.00 15.58 1.03 8.98 8.67 98.80
avg-cpu: %user %nice %system %iowait %steal %idle
6.00 0.00 0.00 94.00 0.00 0.00
Device: rrqm/s wrqm/s r/s w/s rMB/s wMB/s avgrq-sz avgqu-sz await svctm %util
sda 0.00 0.00 126.00 0.00 0.85 0.00 13.78 1.00 8.00 7.94 100.00
avg-cpu: %user %nice %system %iowait %steal %idle
6.00 0.00 2.00 92.00 0.00 0.00
Device: rrqm/s wrqm/s r/s w/s rMB/s wMB/s avgrq-sz avgqu-sz await svctm %util
sda 0.00 0.00 111.00 0.00 0.72 0.00 13.33 0.99 8.90 8.90 98.80
avg-cpu: %user %nice %system %iowait %steal %idle
6.00 0.00 1.00 93.00 0.00 0.00
Device: rrqm/s wrqm/s r/s w/s rMB/s wMB/s avgrq-sz avgqu-sz await svctm %util
sda 0.00 0.00 122.00 0.00 0.84 0.00 14.16 1.00 8.16 8.16 99.60
avg-cpu: %user %nice %system %iowait %steal %idle
5.00 0.00 1.00 94.00 0.00 0.00
Device: rrqm/s wrqm/s r/s w/s rMB/s wMB/s avgrq-sz avgqu-sz await svctm %util
sda 0.00 0.00 129.00 0.00 0.89 0.00 14.20 1.00 7.69 7.75 100.00
avg-cpu: %user %nice %system %iowait %steal %idle
6.00 0.00 2.00 92.00 0.00 0.00
Device: rrqm/s wrqm/s r/s w/s rMB/s wMB/s avgrq-sz avgqu-sz await svctm %util
sda 0.00 18.00 103.00 3.00 0.70 0.08 15.09 1.17 11.09 9.32 98.80
avg-cpu: %user %nice %system %iowait %steal %idle
5.05 0.00 1.01 93.94 0.00 0.00
Device: rrqm/s wrqm/s r/s w/s rMB/s wMB/s avgrq-sz avgqu-sz await svctm %util
sda 0.00 0.00 110.00 0.00 0.71 0.00 13.16 1.00 9.05 9.09 100.00
avg-cpu: %user %nice %system %iowait %steal %idle
6.93 0.00 0.99 92.08 0.00 0.00
Device: rrqm/s wrqm/s r/s w/s rMB/s wMB/s avgrq-sz avgqu-sz await svctm %util
sda 0.00 0.00 126.00 0.00 1.08 0.00 17.52 0.99 7.90 7.87 99.20
avg-cpu: %user %nice %system %iowait %steal %idle
5.00 0.00 3.00 92.00 0.00 0.00
Device: rrqm/s wrqm/s r/s w/s rMB/s wMB/s avgrq-sz avgqu-sz await svctm %util
sda 0.00 0.00 120.00 0.00 0.85 0.00 14.47 0.98 8.20 8.20 98.40
avg-cpu: %user %nice %system %iowait %steal %idle
6.93 0.00 1.98 91.09 0.00 0.00
Device: rrqm/s wrqm/s r/s w/s rMB/s wMB/s avgrq-sz avgqu-sz await svctm %util
sda 0.00 0.00 100.00 0.00 0.64 0.00 13.12 1.00 9.88 9.92 99.20
avg-cpu: %user %nice %system %iowait %steal %idle
6.00 0.00 2.00 92.00 0.00 0.00
Device: rrqm/s wrqm/s r/s w/s rMB/s wMB/s avgrq-sz avgqu-sz await svctm %util
sda 0.00 0.00 107.00 0.00 0.70 0.00 13.31 1.00 9.35 9.31 99.60
avg-cpu: %user %nice %system %iowait %steal %idle
6.00 0.00 1.00 93.00 0.00 0.00
Device: rrqm/s wrqm/s r/s w/s rMB/s wMB/s avgrq-sz avgqu-sz await svctm %util
sda 0.00 18.00 95.00 3.00 0.62 0.08 14.61 1.25 12.82 10.16 99.60
avg-cpu: %user %nice %system %iowait %steal %idle
5.05 0.00 1.01 93.94 0.00 0.00
Device: rrqm/s wrqm/s r/s w/s rMB/s wMB/s avgrq-sz avgqu-sz await svctm %util
sda 0.00 0.00 101.00 0.00 0.68 0.00 13.70 0.99 9.74 9.78 98.80
avg-cpu: %user %nice %system %iowait %steal %idle
5.94 0.00 2.97 91.09 0.00 0.00
Device: rrqm/s wrqm/s r/s w/s rMB/s wMB/s avgrq-sz avgqu-sz await svctm %util
sda 0.00 0.00 104.00 0.00 0.68 0.00 13.46 0.99 9.54 9.54 99.20
avg-cpu: %user %nice %system %iowait %steal %idle
6.06 0.00 0.00 93.94 0.00 0.00
Device: rrqm/s wrqm/s r/s w/s rMB/s wMB/s avgrq-sz avgqu-sz await svctm %util
sda 0.00 0.00 99.00 0.00 0.65 0.00 13.41 0.99 10.02 9.98 98.80
avg-cpu: %user %nice %system %iowait %steal %idle
6.93 0.00 0.99 92.08 0.00 0.00
Device: rrqm/s wrqm/s r/s w/s rMB/s wMB/s avgrq-sz avgqu-sz await svctm %util
sda 0.00 0.00 105.00 0.00 0.69 0.00 13.41 0.99 9.45 9.45 99.20
avg-cpu: %user %nice %system %iowait %steal %idle
5.00 0.00 1.00 94.00 0.00 0.00
Device: rrqm/s wrqm/s r/s w/s rMB/s wMB/s avgrq-sz avgqu-sz await svctm %util
sda 0.00 57.00 99.00 8.00 0.65 0.19 16.00 1.21 10.69 9.31 99.60
avg-cpu: %user %nice %system %iowait %steal %idle
6.00 0.00 0.00 94.00 0.00 0.00
Device: rrqm/s wrqm/s r/s w/s rMB/s wMB/s avgrq-sz avgqu-sz await svctm %util
sda 0.00 0.00 73.00 2.00 0.49 0.07 15.36 1.25 17.49 13.33 100.00
avg-cpu: %user %nice %system %iowait %steal %idle
6.00 0.00 2.00 92.00 0.00 0.00
Device: rrqm/s wrqm/s r/s w/s rMB/s wMB/s avgrq-sz avgqu-sz await svctm %util
sda 0.00 0.00 96.00 0.00 0.62 0.00 13.17 0.98 10.25 10.21 98.00
avg-cpu: %user %nice %system %iowait %steal %idle
13.00 0.00 3.00 11.00 0.00 73.00
Device: rrqm/s wrqm/s r/s w/s rMB/s wMB/s avgrq-sz avgqu-sz await svctm %util
sda 0.00 0.00 15.00 0.00 0.10 0.00 13.33 0.12 8.53 8.27 12.40
avg-cpu: %user %nice %system %iowait %steal %idle
2.00 0.00 0.00 0.00 0.00 98.00
Device: rrqm/s wrqm/s r/s w/s rMB/s wMB/s avgrq-sz avgqu-sz await svctm %util
sda 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
avg-cpu: %user %nice %system %iowait %steal %idle
13.00 0.00 14.00 0.00 0.00 73.00
Device: rrqm/s wrqm/s r/s w/s rMB/s wMB/s avgrq-sz avgqu-sz await svctm %util
sda 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
avg-cpu: %user %nice %system %iowait %steal %idle
14.00 0.00 2.00 0.00 0.00 84.00
Device: rrqm/s wrqm/s r/s w/s rMB/s wMB/s avgrq-sz avgqu-sz await svctm %util
sda 0.00 28.00 0.00 5.00 0.00 0.13 52.80 0.00 0.00 0.00 0.00
avg-cpu: %user %nice %system %iowait %steal %idle
20.00 0.00 3.00 0.00 0.00 77.00
Device: rrqm/s wrqm/s r/s w/s rMB/s wMB/s avgrq-sz avgqu-sz await svctm %util
sda 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00#9 Re : Optimisation » Des requêtes lentes, plus de 10 minutes par requête! » 26/04/2009 21:46:53
Et pour le iostat, voici les resultats:
Requete:
explain analyze select * from fourgrams where lower(part2)='ham' order by freq desc
----
"Sort (cost=97958.94..98018.92 rows=23994 width=28) (actual time=28984.027..29001.872 rows=13579 loops=1)"
" Sort Key: freq"
" Sort Method: external merge Disk: 520kB"
" -> Index Scan using part2_idx on fourgrams (cost=0.00..95677.83 rows=23994 width=28) (actual time=134.097..28942.334 rows=13579 loops=1)"
" Index Cond: (lower((part2)::text) = 'ham'::text)"
"Total runtime: 29007.830 ms"
----
LOG: EXECUTOR STATISTICS
DETAIL: ! system usage stats:
! 29.008271 elapsed 0.084005 user 0.264016 system sec
! [23259.505628 user 735.897990 sys total]
! 46984/1040 [500349384/211102704] filesystem blocks in/out
! 1/163 [4/15743] page faults/reclaims, 0 [0] swaps
! 0 [0] signals rcvd, 0/0 [0/0] messages rcvd/sent
! 3173/5 [1547136/5420943] voluntary/involuntary context switches
! buffer usage stats:
! Shared blocks: 2238 read, 0 written, buffer hit rate = 0.09%
! Local blocks: 0 read, 0 written, buffer hit rate = 0.00%
! Direct blocks: 0 read, 0 written
Total query runtime: 29031 ms.
6 rows retrieved.#10 Re : Optimisation » Des requêtes lentes, plus de 10 minutes par requête! » 26/04/2009 21:42:58
Bonjour,
d'abord pour le echo 'deadline' ne marche pas, voila ce qui ce passe:
sudo echo 'deadline' > /sys/block/sda/queue/scheduler
bash: /sys/block/sda/queue/scheduler: Permission deniedvous voyez bien que j'utilise le sudo, et quand je tape le sudo nano voila le resultat:
sudo nano /sys/block/sda/queue/scheduler
GNU nano 2.0.7 File: /sys/block/sda/queue/scheduler
noop anticipatory deadline [cfq]Donc il me semble que la ligne existe déjà dans ce fichier.
#11 Re : Optimisation » Des requêtes lentes, plus de 10 minutes par requête! » 24/04/2009 17:47:45
Marc Cousin a écrit :
+ l'ajout de la ligne deadline s'est fait comment ? (c'est un peu particulier) => que donne un cat sur ce fichier ?
+ la modification du sysctl n'a pas changé les paramètres de cache de postgresql, simplement reparamétré linux pour qu'il les accepte. Il faut augmenter le paramètre shared_buffers dans postgresql.conf pour cela
- pour la dealine j'ai utilisé sudo nano /sys/block/sda/queue/scheduler, maintenant je viens de vérifier que ce fichier contient exactement " noop anticipatory deadline [cfq]"
- la valeur de shared_buffers est de : shared_buffers = 330MB j'ai fait cela et redémarre postgres depuis 2 jours.
#12 Re : Optimisation » Des requêtes lentes, plus de 10 minutes par requête! » 24/04/2009 16:34:09
Bonjour;
Merci pour vos réponses, revenons au résultats:
- initialement il y avait kernel.shmmax = 33 554 432, que j'ai multiplié par 10, pour avoir 333 MO
- j'ai mis cette valeur dans le /etc/sysctl.conf
- j'ai ajouté la ligne "deadline" dans le fichier /sys/block/sda/queue/sheduler,
et voici les resultats des requetes:
explain analyze select * from fourgrams where lower(part2)='cheese' order by freq desc
"Sort (cost=97958.94..98018.92 rows=23994 width=28) (actual time=55098.200..55142.929 rows=37135 loops=1)"
" Sort Key: freq"
" Sort Method: external merge Disk: 1568kB"
" -> Index Scan using part2_idx on fourgrams (cost=0.00..95677.83 rows=23994 width=28) (actual time=196.002..54971.364 rows=37135 loops=1)"
" Index Cond: (lower((part2)::text) = 'cheese'::text)"
"Total runtime: 55158.776 ms"
LOG: EXECUTOR STATISTICS
DETAIL: ! system usage stats:
! 55.229908 elapsed 0.208013 user 0.488030 system sec
! [23258.213547 user 731.029686 sys total]
! 92568/3160 [499206888/211090872] filesystem blocks in/out
! 0/244 [3/15086] page faults/reclaims, 0 [0] swaps
! 0 [0] signals rcvd, 0/0 [0/0] messages rcvd/sent
! 6323/14 [1480440/5420876] voluntary/involuntary context switches
! buffer usage stats:
! Shared blocks: 3910 read, 0 written, buffer hit rate = 1.59%
! Local blocks: 0 read, 0 written, buffer hit rate = 0.00%
! Direct blocks: 0 read, 0 written
Total query runtime: 55257 ms.
6 rows retrieved.
--------------------------------------------------------------------------------------------
explain analyze select * from fourgrams where lower(part3)='cheese' order by freq desc
"Sort (cost=93369.58..93427.33 rows=23099 width=28) (actual time=159452.597..159497.776 rows=39521 loops=1)"
" Sort Key: freq"
" Sort Method: external merge Disk: 1680kB"
" -> Index Scan using part3_idx on fourgrams (cost=0.00..91180.91 rows=23099 width=28) (actual time=125.511..159257.109 rows=39521 loops=1)"
" Index Cond: (lower((part3)::text) = 'cheese'::text)"
"Total runtime: 159526.801 ms"
LOG: EXECUTOR STATISTICS
DETAIL: ! system usage stats:
! 159.527275 elapsed 0.424027 user 1.504094 system sec
! [23258.637574 user 732.533780 sys total]
! 338056/3384 [499544944/211094264] filesystem blocks in/out
! 0/164 [3/15250] page faults/reclaims, 0 [0] swaps
! 0 [0] signals rcvd, 0/0 [0/0] messages rcvd/sent
! 21800/19 [1502244/5420898] voluntary/involuntary context switches
! buffer usage stats:
! Shared blocks: 16652 read, 0 written, buffer hit rate = 0.02%
! Local blocks: 0 read, 0 written, buffer hit rate = 0.00%
! Direct blocks: 0 read, 0 written
Total query runtime: 159578 ms.
6 rows retrieved.
------------------------------------------------------------------------------------------------------
explain analyze select * from fourgrams where lower(part4)='cheese' order by freq desc
"Sort (cost=99245.27..99305.78 rows=24206 width=28) (actual time=211044.823..211099.183 rows=36617 loops=1)"
" Sort Key: freq"
" Sort Method: external merge Disk: 1576kB"
" -> Index Scan using part4_idx on fourgrams (cost=0.00..96943.70 rows=24206 width=28) (actual time=178.206..210811.916 rows=36617 loops=1)"
" Index Cond: (lower((part4)::text) = 'cheese'::text)"
"Total runtime: 211116.443 ms"
LOG: EXECUTOR STATISTICS
DETAIL: ! system usage stats:
! 211.153733 elapsed 0.520032 user 2.316145 system sec
! [23259.157606 user 734.853925 sys total]
! 628608/3184 [500173600/211097464] filesystem blocks in/out
! 0/164 [3/15414] page faults/reclaims, 0 [0] swaps
! 0 [0] signals rcvd, 0/0 [0/0] messages rcvd/sent
! 32611/9 [1534864/5420908] voluntary/involuntary context switches
! buffer usage stats:
! Shared blocks: 29282 read, 0 written, buffer hit rate = 0.00%
! Local blocks: 0 read, 0 written, buffer hit rate = 0.00%
! Direct blocks: 0 read, 0 written
Total query runtime: 211211 ms.
6 rows retrieved.#13 Re : Optimisation » Des requêtes lentes, plus de 10 minutes par requête! » 24/04/2009 04:34:19
J'ai une idée qui, bien qu'elle soit très naïve, elle peut résoudre le problème parfaitement:
puisque le secret de rapidité magique de la première colonne réside dans l'ordonnancement des lignes par rapport a celle-ci, je pense de créer autant de copies de la table que de colonnes qu'elle a, chacune de ces nouvelles copies est ordonné par rapport à une colonne, et ne contenant que l'indexe de cette colonne (dans notre cas 4 tables puisqu'on a 4 colonnes interrogables), cela devra fonctionner tous les indexes de manière similaire a celle de la première colonne.
Le seul problème pour moi ici est: comment ordonner une table relativement a une colonne déterminée?
Peut on ajouter une contrainte lors de la création du table, ou a partir d'une table existante?
Que pensez vous de cette idée?
#14 Re : Optimisation » Des requêtes lentes, plus de 10 minutes par requête! » 24/04/2009 04:25:38
gleu a écrit :
Concernant le premier bloc de résultat, si part2 n'avait plus d'index, c'est assez logique. Il faut créer un index du même type que ce que j'ai marqué plus haut, mais pour chacune des colonnes.
Quant au deuxième bloc, il montre clairement qu'il y a beaucoup plus de lectures sur le disque, ce qui explique les lenteurs.
Je suis désolé pour cette erreur, j'ai permuté l'affichage de deux requêtes, maintenant le résultat est correct vous pouvez le reconsulter:
- Seule la requête sur la colonne part2 dans la table ou je n'ai que l'index que vous m'avez demandé de créer (avec le ops)
- les 3 requêtes sur les 3 colonnes une, deux et trois dans la tables là où il y a tous les anciens indexes
En tout cas je vais reconstruire les autres indexes pour la table comme vous l'avez indiqué.
#15 Re : Optimisation » Des requêtes lentes, plus de 10 minutes par requête! » 23/04/2009 22:28:11
Bonsoir c'est moi de nouveau,
Je suis désolé de ne rien avoir posté ce jour, mais la machine n'était pas libre.
Bref, je ne sais plus d'où commencer:
La création du nouveau indexe n'a rien (aprioris) ajouté, je m'en doute s'il a été crée correctement, je le refais ce soir et je vous poste les résultats demain.
Pour l'instant, voici ce que j'ai eu comme resultat pour cette colonne, qui est dans une seconde instance de la table, qui ne contient que ce nouveau index:
explain analyze select * from fourgrams where lower(part2)='milk' order by freq desc
--------
"Sort (cost=129241085.53..129241145.97 rows=24175 width=28) (actual time=1620489.771..1620561.163 rows=51203 loops=1)"
" Sort Key: freq"
" Sort Method: external merge Disk: 2064kB"
" -> Seq Scan on fourgrams (cost=100000000.00..129238786.44 rows=24175 width=28) (actual time=3855.122..1620049.389 rows=51203 loops=1)"
" Filter: (lower((part2)::text) = 'milk'::text)"
"Total runtime: 1620630.742 ms"
--------
LOG: EXECUTOR STATISTICS
DETAIL: ! system usage stats:
! 1620.631116 elapsed 1368.085500 user 121.723607 system sec
! [27074.340040 user 1046.909427 sys total]
! 152622608/4176 [805090120/211145544] filesystem blocks in/out
! 0/75 [27/48092] page faults/reclaims, 0 [0] swaps
! 0 [0] signals rcvd, 0/0 [0/0] messages rcvd/sent
! 28256/351112 [1154487/6565795] voluntary/involuntary context switches
! buffer usage stats:
! Shared blocks: 9529349 read, 0 written, buffer hit rate = 0.00%
! Local blocks: 0 read, 0 written, buffer hit rate = 0.00%
! Direct blocks: 0 read, 0 written
Total query runtime: 1620691 ms.
6 rows retrieved.Cela ne me parait pas raisonnable, meme au niveau du seq_scan que j'ai désactivé et vérifié deux fois avant le lancement de la requete.
Pour ce quei concerne l'instance initiale de la table, voici quelques resultats:
explain analyze select * from fourgrams where lower(part1)='cheese' order by freq desc
-----------------------------
"Sort (cost=85715.66..85788.58 rows=29166 width=28) (actual time=395.897..432.396 rows=30220 loops=1)"
" Sort Key: freq"
" Sort Method: external merge Disk: 1272kB"
" -> Index Scan using part1_idx on fourgrams (cost=0.00..82901.71 rows=29166 width=28) (actual time=159.217..320.277 rows=30220 loops=1)"
" Index Cond: (lower((part1)::text) = 'cheese'::text)"
"Total runtime: 445.361 ms"
----------------------
LOG: EXECUTOR STATISTICS
DETAIL: ! system usage stats:
! 0.546619 elapsed 0.124008 user 0.036002 system sec
! [315.939745 user 91.889742 sys total]
! 6136/2544 [154765944/27320] filesystem blocks in/out
! 0/164 [3/9227] page faults/reclaims, 0 [0] swaps
! 0 [0] signals rcvd, 0/0 [0/0] messages rcvd/sent
! 34/31 [695160/157752] voluntary/involuntary context switches
! buffer usage stats:
! Shared blocks: 315 read, 0 written, buffer hit rate = 1.87%
! Local blocks: 0 read, 0 written, buffer hit rate = 0.00%
! Direct blocks: 0 read, 0 written
Total query runtime: 563 ms.
6 rows retrieved.
------------------------------------------------------
explain analyze select * from fourgrams where lower(part2)='cheese' order by freq desc
----------
"Sort (cost=97967.05..98027.04 rows=23996 width=28) (actual time=54295.803..54334.025 rows=37135 loops=1)"
" Sort Key: freq"
" Sort Method: external merge Disk: 1568kB"
" -> Index Scan using part2_idx on fourgrams (cost=0.00..95685.78 rows=23996 width=28) (actual time=226.634..54170.885 rows=37135 loops=1)"
" Index Cond: (lower((part2)::text) = 'cheese'::text)"
"Total runtime: 54356.035 ms"
----------
LOG: EXECUTOR STATISTICS
DETAIL: ! system usage stats:
! 54.356459 elapsed 0.224014 user 0.444028 system sec
! [315.815737 user 91.853740 sys total]
! 92960/3168 [154759808/24768] filesystem blocks in/out
! 0/164 [3/9063] page faults/reclaims, 0 [0] swaps
! 0 [0] signals rcvd, 0/0 [0/0] messages rcvd/sent
! 6333/12 [695122/157720] voluntary/involuntary context switches
! buffer usage stats:
! Shared blocks: 3919 read, 0 written, buffer hit rate = 0.00%
! Local blocks: 0 read, 0 written, buffer hit rate = 0.00%
! Direct blocks: 0 read, 0 written
Total query runtime: 54387 ms.
6 rows retrieved.
-------------------------------------------------------------------------------
explain analyze select * from fourgrams where lower(part3)='cheese' order by freq desc
----------
"Sort (cost=93373.59..93431.34 rows=23100 width=28) (actual time=137699.725..137748.542 rows=39521 loops=1)"
" Sort Key: freq"
" Sort Method: external merge Disk: 1680kB"
" -> Index Scan using part3_idx on fourgrams (cost=0.00..91184.85 rows=23100 width=28) (actual time=78.770..137514.032 rows=39521 loops=1)"
" Index Cond: (lower((part3)::text) = 'cheese'::text)"
"Total runtime: 137765.283 ms"
----------
LOG: EXECUTOR STATISTICS
DETAIL: ! system usage stats:
! 1691.255280 elapsed 1369.757605 user 124.775798 system sec
! [25706.250540 user 925.185820 sys total]
! 152638008/34464 [652467464/211141352] filesystem blocks in/out
! 0/81 [27/48016] page faults/reclaims, 0 [0] swaps
! 0 [0] signals rcvd, 0/0 [0/0] messages rcvd/sent
! 28906/376734 [1126217/6214682] voluntary/involuntary context switches
! buffer usage stats:
! Shared blocks: 9527015 read, 0 written, buffer hit rate = 0.02%
! Local blocks: 0 read, 0 written, buffer hit rate = 0.00%
! Direct blocks: 0 read, 0 written
Total query runtime: 1691330 ms.
6 rows retrieved.A plus tard pour plus de resultats...
#16 Re : Optimisation » Des requêtes lentes, plus de 10 minutes par requête! » 22/04/2009 19:49:17
Marc Cousin a écrit :
Effectivement, les performances pour les deux requêtes en exemple sont vraiment basses. Ça laisse vraiment supposer un problème de performance disque. Parce que même sans aucun cache, ça devrait être plus rapide. En attendant que la nouvelle machine (qui est aussi un pc de bureau si je ne m'abuse à la description du matériel) ne soit prête, je serais intéressé par les executor_stats associées aux requêtes du message #31 (histoire de savoir combien de blocs postgresql va chercher sur le disque).
Voulez-vous dire log_executor_stats ?
Si c'est le cas un show log_executor_stats me donne le résultat off. Sinon quelle commande pour avoir ces statistiques?
Par la même occasion, les résultat du #31 sont après l'augmentation du shared buffer a 330 MO, le 1/3 de mon ram actuel.
#17 Re : Optimisation » Des requêtes lentes, plus de 10 minutes par requête! » 22/04/2009 16:23:39
gleu a écrit :
Oubliez ma question sur la requête. Par contre, recréez l'index avec le text_pattern_ops, et refaites le EXPLAIN ANALYZE.
Concernant un nouveau serveur, ce sera certainement plus rapide grâce à la mémoire. Maintenant, pas sûr que cela résolve votre problème. En tout cas, oubliez vista si vous voulez des performances. Peu importe le linux que vous installez. Quant à PostgreSQL, utilisez la dernière version stable (8.3.7 aujourd'hui). Avoir plusieurs disques peut servir.
PS : il aurait été sympa de dire que vous aviez déjà fait des recherches et qu'il y avait déjà tout un tas d'infos sur http://www.developpez.net/forums/d70537 … ex-malgre/. Ça aurait évité qu'on ait à les chercher.
Je suis vraiment désolé de ne pas mentionner cela, c'est grâce a eux que j'ai eu l'idée de poster dans ce forum. Mais simplement j'ai cru que faire un résumé des tentatives que j'ai fait sera suffisant.
Mais vous avez raison.
#18 Re : Optimisation » Des requêtes lentes, plus de 10 minutes par requête! » 22/04/2009 16:19:11
gleu a écrit :
Désolé pour les multiples messages. Je suis étonné que la désactivation du bitmapscan n'ait rien donné. Il serait possible d'avoir le EXPLAIN ANALYZE suite à un « SET enable_bitmapscan TO off ».
Vous avez raison, les premiers résultats sont avant la désactivation des bitmapscan, voici les nouveaux resultats:
explain analyze select * from fourgrams where lower(part2)='cheese' order by freq desc;
"Sort (cost=97967.05..98027.04 rows=23996 width=28) (actual time=53971.568..54016.015 rows=37135 loops=1)"
" Sort Key: freq"
" Sort Method: external merge Disk: 1568kB"
" -> Index Scan using part2_idx on fourgrams (cost=0.00..95685.78 rows=23996 width=28) (actual time=216.131..53750.682 rows=37135 loops=1)"
" Index Cond: (lower((part2)::text) = 'cheese'::text)"
"Total runtime: 54032.019 ms"
------------------------------------------------------------------------------------
explain analyze select * from fourgrams where lower(part3)='cheese' order by freq desc;
"Sort (cost=93373.59..93431.34 rows=23100 width=28) (actual time=158072.587..158119.490 rows=39521 loops=1)"
" Sort Key: freq"
" Sort Method: external merge Disk: 1680kB"
" -> Index Scan using part3_idx on fourgrams (cost=0.00..91184.85 rows=23100 width=28) (actual time=138.592..157876.670 rows=39521 loops=1)"
" Index Cond: (lower((part3)::text) = 'cheese'::text)"
"Total runtime: 158136.191 ms"
------------------------------------------------------------------------------------
explain analyze select * from fourgrams where lower(part4)='cheese' order by freq desc;
"Sort (cost=99253.41..99313.93 rows=24208 width=28) (actual time=194107.895..194171.071 rows=36617 loops=1)"
" Sort Key: freq"
" Sort Method: external merge Disk: 1576kB"
" -> Index Scan using part4_idx on fourgrams (cost=0.00..96951.68 rows=24208 width=28) (actual time=194.410..193886.645 rows=36617 loops=1)"
" Index Cond: (lower((part4)::text) = 'cheese'::text)"
"Total runtime: 194186.804 ms"#19 Re : Optimisation » Des requêtes lentes, plus de 10 minutes par requête! » 22/04/2009 16:05:59
gleu a écrit :
Question complémentaire, il y a combien de lignes dans la table indexée ?
1 313 818 354 lignes.
#20 Re : Optimisation » Des requêtes lentes, plus de 10 minutes par requête! » 22/04/2009 16:03:26
Marc Cousin a écrit :
En ce qui me concerne, cela me semble très 'raisonnable' comme temps de réponse : 55 secondes pour retourner 50 000 enregistrements, cela fait 1ms par enregistrement. Si ils sont réellement éparpillés sur le disque, on ne pourra pas faire beaucoup mieux. Enfin si, avec la 8.4, plein de disques le effective_io_concurrency mais on change un peu de budget là.
A part ça on voit aussi qu'il n'est plus dans les choux au niveau statistiques (un rapport 2 ça n'est pas si mal). Ça lui permet au moins de faire du bitmap_index_scan, ce qui me semble le plan raisonnable pour ce genre de requête.
On peut passer à l'étape d'après: voir ce que ça donne avec un plus gros cache (après le test demandé par gleu, qui peut permettre de gagner un peu aussi).
J'ai décidé de changer la machine de serveur avec une plus performante: 8 GO de ram, et un core2 duo.
Ceci veut dire que vais réinstaller le OS, et refaire tout a zéro, heureusement que j'ai une copie sauvegarde de chaque table. Ce qui serait intéressant ici est d'essayer d'optimiser tout:
- Quel OS choisir? Quel système de fichier? J'ai entendu que le Ubunutu 9.04 a le système de fichier ext4, on dit qu'il est 2 fois plus rapide que le ext3. Ou peut être garder simplement le vista?
- Quelle version de postgres? Vous avez parlé de 8.04, je n'ai pas de grandes informations sur ça.
- Ajouter un autre disque dur aidera plus? En fait cette machine dispose déjà d'un disque a 250 GO, peut être diviser chaque table sur les deux disque divisera le temps de recherche par 2?
#21 Re : Optimisation » Des requêtes lentes, plus de 10 minutes par requête! » 22/04/2009 15:43:19
gleu a écrit :
Question peut-être complètement stupide, mais quelle locale utilises-tu ? si tu n'utilises pas C, peux-tu re-créer les index avec la classe text_pattern_ops ? cela donne la requête suivante :
CREATE INDEX part1_idx ON tableau1 USING btree (lower(part1) text_pattern_ops);Ensuite les ANALYZE, et les EXPLAIN ANALYZE.
Je ne suis pas sur d'avoir votre question.
C'est quoi la locale? Comment la connaitre?
J'ai essayé de trouver la solution tout seul, mais j'ai rien trouvé.
Sinon je vais essayer de refaire un index dans une autre copie de la base avec cette commande pour la 2éme colonne.
#22 Re : Optimisation » Des requêtes lentes, plus de 10 minutes par requête! » 22/04/2009 14:46:13
Voici les explains pour une même requête:
explain analyze select * from fourgrams where lower(part1)='milk' order by freq desc
"Sort (cost=85715.66..85788.58 rows=29166 width=28) (actual time=989.862..1041.283 rows=43797 loops=1)"
" Sort Key: freq"
" Sort Method: external merge Disk: 1776kB"
" -> Index Scan using part1_idx on fourgrams (cost=0.00..82901.71 rows=29166 width=28) (actual time=334.769..876.553 rows=43797 loops=1)"
" Index Cond: (lower((part1)::text) = 'milk'::text)"
"Total runtime: 1060.206 ms"
------------------------------------------------------------------------------------------------------------------------------------------------------------------------
explain analyze select * from fourgrams where lower(part2)='milk' order by freq desc
"Sort (cost=95474.27..95534.26 rows=23996 width=28) (actual time=54981.544..55042.934 rows=51203 loops=1)"
" Sort Key: freq"
" Sort Method: external merge Disk: 2064kB"
" -> Bitmap Heap Scan on fourgrams (cost=574.70..93193.00 rows=23996 width=28) (actual time=95.337..54804.747 rows=51203 loops=1)"
" Recheck Cond: (lower((part2)::text) = 'milk'::text)"
" -> Bitmap Index Scan on part2_idx (cost=0.00..568.71 rows=23996 width=0) (actual time=60.391..60.391 rows=51203 loops=1)"
" Index Cond: (lower((part2)::text) = 'milk'::text)"
"Total runtime: 55064.261 ms"
------------------------------------------------------------------------------------------------------------------------------------------------------------------------
explain analyze select * from fourgrams where lower(part3)='milk' order by freq desc
"Sort (cost=91976.84..92034.59 rows=23100 width=28) (actual time=206224.938..206288.703 rows=52850 loops=1)"
" Sort Key: freq"
" Sort Method: external merge Disk: 2144kB"
" -> Bitmap Heap Scan on fourgrams (cost=555.60..89788.09 rows=23100 width=28) (actual time=2725.524..205967.449 rows=52850 loops=1)"
" Recheck Cond: (lower((part3)::text) = 'milk'::text)"
" -> Bitmap Index Scan on part3_idx (cost=0.00..549.83 rows=23100 width=0) (actual time=2688.857..2688.857 rows=52850 loops=1)"
" Index Cond: (lower((part3)::text) = 'milk'::text)"
"Total runtime: 206310.657 ms"
------------------------------------------------------------------------------------------------------------------------------------------------------------------------
explain analyze select * from fourgrams where lower(part4)='milk' order by freq desc
"Sort (cost=96299.54..96360.06 rows=24208 width=28) (actual time=304220.039..304296.193 rows=46700 loops=1)"
" Sort Key: freq"
" Sort Method: external merge Disk: 1912kB"
" -> Bitmap Heap Scan on fourgrams (cost=576.29..93997.82 rows=24208 width=28) (actual time=14647.348..303898.506 rows=46700 loops=1)"
" Recheck Cond: (lower((part4)::text) = 'milk'::text)"
" -> Bitmap Index Scan on part4_idx (cost=0.00..570.24 rows=24208 width=0) (actual time=14600.721..14600.721 rows=46700 loops=1)"
" Index Cond: (lower((part4)::text) = 'milk'::text)"
"Total runtime: 304316.153 ms"Alors ça a l'aire d'être mieux non?
#23 Re : Optimisation » Des requêtes lentes, plus de 10 minutes par requête! » 22/04/2009 13:12:07
Bonjour,
Merci encore une fois pour vous deux.
Pour les questions de Marc, je commence une par une comme vous avez dit, je vous copie les résultats des que les ai, je viens de commencer avec les set statistics et explain.
A tout a l'heure.
#24 Re : Optimisation » Des requêtes lentes, plus de 10 minutes par requête! » 21/04/2009 11:49:36
Alors, ces résultats ne vous disent rien?
#25 Re : Optimisation » Des requêtes lentes, plus de 10 minutes par requête! » 20/04/2009 17:10:26
Après Analyze (suite):
"public";"fourgrams";"part2";0;5;53972;"{"","",the,-,of,and,to,:,in,<UNK>,(,a,for,),is,""\"""",on,that,with,/,by,The,'s,or,|,from,are,at,as,I,',this,&,$,was,it,>,an,have,you,not,will,],be,[,your,has,1,all,...,A,can,*,2,=,their,about,2005,my,which,they,his,new,we,3,more,0,one,up,%,+,--,other,our,#,but,were,had,who,any,into,he,its,if,so,also,may,4,her,these,In,5,when,some,no,time,would,This,use,like,free,should,just,out,than,two,@,over,New,what,10,them,information,only,through,US,2004,most,do,""\\"",been,people,»,such,me,All,Home,6,after,£,then,2006,·,between,For,using,where,said,under,And,how,very,7,8,many,before,could,data,there,make,off,because,de,system,To,12,first,i,must,American,even,C,John,2003,get,us,including,used,made,now,s,work,being,By,It,20,those,No,good,see,E,him,number,<,You,based,does,each,THE,within,9,business,own,she,support,years,~,©,day,right,shall,From,online,""{"",back,public,here,On,service,state,both,while,100,around,sex,OF,set,way,18,available,high,last,little,three,Your,home,PM,0.00,did,file,Free,30,B,Web,14,D,message,Service,We,..,power,x,same,services,11,Business,found,much,News,Of,Â,down,Health,pm,Services,since,State,University,16,Online,case,during,help,Hotel,products,What,13,different,full,got,million,My,Our,site,students,water,AM,DVD,include,list,small,X,against,AND,making,per,software,year,always,find,provide,Re,World,""}"",City,control,Date,music,name,research,M,program,South,take,A.,Black,form,If,Other,See,With,2000,am,book,But,Music,old,performance,real,Education,every,give,go,Internet,know,life,National,private,well,15,another,teen,without,world,2001,25,As,local,One,24,children,family,Information,line,Mr.,quality,still,View,About,big,Center,Contact,current,given,He,market,need,version,change,International,level,network,S,School,think,web,50,health,less,More,Search,T,left,members,school,history,page,programs,'re,size,company,getting,government,May,men,R,really,related,resources,second,security,Support,.,17,2002,22,®,best,better,contact,House,large,card,community,long,never,personal,specific,systems,TO,type,value,An,development,Group,might,n,needs,pages,person,Posts,search,Software,user,access,David,economic,Management,N,project,special,Community,gay,Law,love,next,PC,policy,student,until,West,White,women,again,care,files,great,important,IN,problem,required,video,want,working,23,car,design,going,High,Jan,No.,open,part,place,say,Time,together,`,19,26,class,come,Department,East,How,North,That,21,address,CD,light,major,P,Page,problems,Research,w,analysis,black,China,cost,country,early,game,hand,Hotels,January,makes,plan,too,°,Best,companies,December,four,keep,live,run,story,Systems,W,young,above,America,area,books,computer,content,County,date,days,management,Network,Phone,rather,tax,Total,UK,Women,06,across,away,Buy,credit,girls,Michael,often,possible,process,provides,results,room,says,single,System,total,College,e,end,field,First,group,law,Office,order,Part,percent,post,range,received,review,staff,start,term,They,today,various,Windows,create,Design,download,Dr.,features,further,future,hours,II,Life,others,point,price,Products,Site,Street,Top,When,already,Canada,feel,following,general,having,issues,King,Location,m,non,offers,rates,River,S.,Set,So,Table,times,top,true,art,Board,called,costs,due,either,existing,face,few,General,God,His,info,international,key,Member,phone,porn,posted,r,rate,section,something,Special,test,These,things,York,After,areas,Art,body,call,check,course,Development,email,FOR,G,higher,human,IT,J,'ll,machine,Main,man,meeting,months,offer,read,record,send,show,Source,teens,white,William,activities,additional,Association,Big,code,English,ever,F,Guide,June,least,look,mature,news,night,o,office,Park,put,significant,Star,team,technology,0.000,Add,Club,Company,complete,Day,enough,food,fully,industry,links,low,model,pictures,request,Robert,standard,States,website,application,certain,child,designed,Great,H,hotel,insurance,la,looking,move,p,Paul,planning,poker,Project,property,return,St.,upon,written,1999,31,August,Book,Books,buy,c,changes,clear,five,image,Inc.,interest,items,J.,job,L,mail,Most,national,Now,party,photos,play,provided,Public,pussy,risk,series,social,taking,text,Use,Western,whether,28,§,Access,action,along,become,digital,Drive,Family,learning,levels,Local,medical,once,paper,product,reason,Review,Size,Technology,USA,War,40,amount,cell,Computer,Copyright,Country,Director,doing,house,images,issue,known,method,net,NEW,outside,Road,self,Series,server,similar,sound,Texas,usually,200,air,At,b,California,came,Car,Church,Committee,created,Do,et,final,Forum,Friday,friends,Game,growth,head,hot,James,lead,Links,London,Media,Model,movie,Only,picture,prior,questions,quite,Red,'S,She,training,visit,actually,Blue,Chinese,Code,Commission,drug,European,events,February,income,Lake,Last,List,M.,main,necessary,nice,present,professional,September,side,sites,t,third,took,United,User,account,Air,apply,appropriate,Australia,building,Can,cum,direct,education,force,individual,Insurance,Journal,latest,Library,loss,minutes,money,normal,Not,Peter,production,providing,question,require,San,Science,Server,Show,simply,Training,TV,Us,V,Video,29,Accessories,add,Africa,almost,among,Any,applications,Area,bit,center,Conference,Court,'d,energy,equipment,federal,gets,Government,hard,K,kind,Lee,material,memory,Name,October,Old,position,Power,President,probably,share,six,stock,store,stories,study,Title,treatment,wife,yet,^,....,01,Address,Back,Be,became,C.,color,Council,customers,d,Daily,developed,Digital,directory,E.,f,Find,Gallery,Get,Global,Human,III,Is,leading,let,lot,'m,models,numbers,ON,Order,pay,Personal,points,release,several,Small,space,style,Tom,trying,whole,wrote,27,Action,adult,advice,although}";"{0.04848,0.0260533,0.0221,0.0206833,0.0198467,0.01692,0.01382,0.0128633,0.0125633,0.01179,0.0114333,0.00868667,0.00806333,0.00699333,0.00606667,0.00565667,0.00540333,0.00529667,0.00492667,0.00463667,0.00458667,0.00419667,0.00362667,0.00343667,0.00331667,0.00319,0.00316333,0.00304,0.0024,0.00231667,0.00230667,0.00223333,0.00215,0.00214333,0.00213667,0.00208333,0.00207333,0.00204,0.00202333,0.00199667,0.00198667,0.00191667,0.00191333,0.00188,0.00180333,0.00171333,0.00167,0.00160333,0.00155667,0.00151,0.00147667,0.00142667,0.00137333,0.00135,0.00127,0.00120333,0.00114333,0.00111,0.00110667,0.00110333,0.0011,0.00107333,0.00106,0.00102667,0.00102667,0.000993333,0.000986667,0.00098,0.00096,0.000956667,0.000943333,0.000936667,0.000913333,0.000906667,0.000906667,0.000903333,0.000893333,0.000886667,0.000853333,0.000836667,0.00083,0.00083,0.000793333,0.000786667,0.00078,0.000773333,0.000763333,0.00076,0.000756667,0.000743333,0.00071,0.0007,0.000683333,0.00068,0.000676667,0.000676667,0.000666667,0.000666667,0.000656667,0.000653333,0.000646667,0.000643333,0.000643333,0.000636667,0.000626667,0.00062,0.000606667,0.0006,0.0006,0.000586667,0.000586667,0.00056,0.000553333,0.000553333,0.000553333,0.00055,0.00055,0.000546667,0.000543333,0.00054,0.000536667,0.000523333,0.000523333,0.000516667,0.000513333,0.000513333,0.000496667,0.000496667,0.000483333,0.000483333,0.000476667,0.000473333,0.00047,0.000466667,0.000466667,0.000466667,0.00046,0.00046,0.000456667,0.000443333,0.000443333,0.00044,0.000436667,0.000436667,0.000433333,0.000433333,0.000423333,0.000423333,0.000416667,0.000416667,0.00041,0.000406667,0.000403333,0.000403333,0.000396667,0.000396667,0.000396667,0.000396667,0.000393333,0.000393333,0.00039,0.00039,0.000386667,0.000386667,0.000386667,0.00038,0.00038,0.000376667,0.000376667,0.00037,0.000366667,0.000363333,0.000363333,0.000363333,0.00036,0.00036,0.000356667,0.000353333,0.000353333,0.000346667,0.000346667,0.000343333,0.00034,0.000336667,0.000333333,0.000333333,0.000333333,0.000333333,0.000333333,0.00033,0.00033,0.00033,0.00033,0.00033,0.000326667,0.000323333,0.000323333,0.000323333,0.000323333,0.000323333,0.00032,0.00032,0.000316667,0.000316667,0.000316667,0.000313333,0.000313333,0.000313333,0.000313333,0.00031,0.00031,0.000306667,0.000306667,0.000306667,0.000303333,0.000303333,0.000303333,0.0003,0.0003,0.0003,0.000296667,0.000296667,0.000296667,0.000296667,0.000293333,0.000293333,0.00029,0.00029,0.00029,0.00029,0.000286667,0.000286667,0.000286667,0.000283333,0.000283333,0.000283333,0.000283333,0.000283333,0.00028,0.00028,0.00028,0.000276667,0.000276667,0.000273333,0.000273333,0.000273333,0.000273333,0.000273333,0.000273333,0.00027,0.00027,0.00027,0.00027,0.00027,0.00027,0.00027,0.00027,0.000266667,0.000266667,0.000263333,0.000263333,0.000263333,0.000263333,0.000263333,0.000263333,0.00026,0.00026,0.00026,0.00026,0.00026,0.00026,0.00026,0.00026,0.00026,0.00026,0.000256667,0.000256667,0.000256667,0.000256667,0.000256667,0.000256667,0.000253333,0.000253333,0.000253333,0.000253333,0.000253333,0.000253333,0.00025,0.00025,0.00025,0.00025,0.00025,0.000246667,0.000246667,0.000246667,0.000246667,0.000246667,0.000246667,0.000246667,0.000243333,0.000243333,0.000243333,0.000243333,0.00024,0.00024,0.00024,0.00024,0.00024,0.00024,0.00024,0.000236667,0.000236667,0.000236667,0.000236667,0.000236667,0.000236667,0.000236667,0.000236667,0.000233333,0.000233333,0.000233333,0.000233333,0.000233333,0.000233333,0.000233333,0.000233333,0.000233333,0.000233333,0.00023,0.00023,0.00023,0.00023,0.00023,0.000226667,0.000226667,0.000226667,0.000226667,0.000226667,0.000223333,0.000223333,0.000223333,0.000223333,0.000223333,0.000223333,0.000223333,0.000223333,0.000223333,0.00022,0.00022,0.00022,0.00022,0.00022,0.00022,0.00022,0.00022,0.00022,0.00022,0.000216667,0.000216667,0.000216667,0.000216667,0.000216667,0.000216667,0.000216667,0.000216667,0.000213333,0.000213333,0.000213333,0.00021,0.00021,0.00021,0.000206667,0.000206667,0.000206667,0.000203333,0.000203333,0.000203333,0.000203333,0.000203333,0.0002,0.0002,0.0002,0.0002,0.0002,0.0002,0.0002,0.0002,0.0002,0.0002,0.0002,0.0002,0.000196667,0.000196667,0.000196667,0.000196667,0.000196667,0.000196667,0.000196667,0.000196667,0.000196667,0.000196667,0.000193333,0.000193333,0.000193333,0.000193333,0.000193333,0.000193333,0.000193333,0.000193333,0.000193333,0.000193333,0.00019,0.00019,0.00019,0.00019,0.00019,0.00019,0.00019,0.00019,0.00019,0.00019,0.00019,0.00019,0.000186667,0.000186667,0.000186667,0.000186667,0.000186667,0.000186667,0.000186667,0.000183333,0.000183333,0.000183333,0.000183333,0.000183333,0.000183333,0.000183333,0.000183333,0.000183333,0.000183333,0.000183333,0.000183333,0.00018,0.00018,0.00018,0.00018,0.00018,0.00018,0.00018,0.00018,0.00018,0.00018,0.00018,0.000176667,0.000176667,0.000176667,0.000176667,0.000176667,0.000176667,0.000176667,0.000176667,0.000176667,0.000176667,0.000176667,0.000176667,0.000176667,0.000173333,0.000173333,0.000173333,0.000173333,0.000173333,0.000173333,0.000173333,0.000173333,0.000173333,0.000173333,0.00017,0.00017,0.00017,0.00017,0.00017,0.00017,0.00017,0.00017,0.00017,0.00017,0.000166667,0.000166667,0.000166667,0.000166667,0.000166667,0.000166667,0.000166667,0.000166667,0.000166667,0.000166667,0.000166667,0.000166667,0.000166667,0.000163333,0.000163333,0.000163333,0.000163333,0.000163333,0.000163333,0.000163333,0.000163333,0.000163333,0.000163333,0.000163333,0.000163333,0.00016,0.00016,0.00016,0.00016,0.00016,0.00016,0.00016,0.00016,0.00016,0.00016,0.00016,0.00016,0.00016,0.00016,0.00016,0.00016,0.00016,0.000156667,0.000156667,0.000156667,0.000156667,0.000156667,0.000156667,0.000156667,0.000156667,0.000156667,0.000156667,0.000156667,0.000156667,0.000156667,0.000156667,0.000156667,0.000156667,0.000156667,0.000153333,0.000153333,0.000153333,0.000153333,0.000153333,0.000153333,0.000153333,0.000153333,0.000153333,0.000153333,0.000153333,0.000153333,0.000153333,0.000153333,0.000153333,0.000153333,0.000153333,0.000153333,0.000153333,0.000153333,0.000153333,0.000153333,0.00015,0.00015,0.00015,0.00015,0.00015,0.00015,0.00015,0.00015,0.00015,0.00015,0.00015,0.00015,0.00015,0.00015,0.00015,0.00015,0.00015,0.00015,0.000146667,0.000146667,0.000146667,0.000146667,0.000146667,0.000146667,0.000146667,0.000146667,0.000146667,0.000146667,0.000146667,0.000146667,0.000146667,0.000146667,0.000146667,0.000146667,0.000146667,0.000146667,0.000146667,0.000146667,0.000146667,0.000143333,0.000143333,0.000143333,0.000143333,0.000143333,0.000143333,0.000143333,0.000143333,0.000143333,0.000143333,0.000143333,0.000143333,0.000143333,0.000143333,0.000143333,0.000143333,0.000143333,0.000143333,0.000143333,0.000143333,0.000143333,0.000143333,0.000143333,0.000143333,0.000143333,0.000143333,0.000143333,0.000143333,0.00014,0.00014,0.00014,0.00014,0.00014,0.00014,0.00014,0.00014,0.00014,0.00014,0.00014,0.00014,0.00014,0.00014,0.00014,0.00014,0.00014,0.00014,0.00014,0.00014,0.00014,0.00014,0.00014,0.00014,0.00014,0.00014,0.00014,0.00014,0.00014,0.00014,0.000136667,0.000136667,0.000136667,0.000136667,0.000136667,0.000136667,0.000136667,0.000136667,0.000136667,0.000136667,0.000136667,0.000136667,0.000136667,0.000136667,0.000136667,0.000136667,0.000136667,0.000136667,0.000136667,0.000136667,0.000136667,0.000136667,0.000136667,0.000133333,0.000133333,0.000133333,0.000133333,0.000133333,0.000133333,0.000133333,0.000133333,0.000133333,0.000133333,0.000133333,0.000133333,0.000133333,0.000133333,0.000133333,0.000133333,0.000133333,0.000133333,0.000133333,0.00013,0.00013,0.00013,0.00013,0.00013,0.00013,0.00013,0.00013,0.00013,0.00013,0.00013,0.00013,0.00013,0.00013,0.00013,0.00013,0.00013,0.00013,0.00013,0.00013,0.00013,0.000126667,0.000126667,0.000126667,0.000126667,0.000126667,0.000126667,0.000126667,0.000126667,0.000126667,0.000126667,0.000126667,0.000126667,0.000126667,0.000126667,0.000126667,0.000126667,0.000126667,0.000126667,0.000126667,0.000126667,0.000126667,0.000126667,0.000126667,0.000126667,0.000126667,0.000126667,0.000126667,0.000126667,0.000126667,0.000126667,0.000126667,0.000126667,0.000126667,0.000126667,0.000126667,0.000123333,0.000123333,0.000123333,0.000123333,0.000123333,0.000123333,0.000123333,0.000123333,0.000123333,0.000123333,0.000123333,0.000123333,0.000123333,0.000123333,0.000123333,0.000123333,0.000123333,0.000123333,0.000123333,0.000123333,0.000123333,0.000123333,0.00012,0.00012,0.00012,0.00012,0.00012,0.00012,0.00012,0.00012,0.00012,0.00012,0.00012,0.00012,0.00012,0.00012,0.00012,0.00012,0.00012,0.00012,0.00012,0.00012,0.00012,0.00012,0.00012,0.00012,0.000116667,0.000116667,0.000116667,0.000116667,0.000116667,0.000116667,0.000116667,0.000116667,0.000116667,0.000116667,0.000116667,0.000116667,0.000116667,0.000116667,0.000116667,0.000116667,0.000116667,0.000116667,0.000116667,0.000116667,0.000116667,0.000116667,0.000116667,0.000116667,0.000116667,0.000116667,0.000116667,0.000116667,0.000116667,0.000116667,0.000116667,0.000116667,0.000116667,0.000116667,0.000116667,0.000116667,0.000116667,0.000113333,0.000113333,0.000113333,0.000113333,0.000113333,0.000113333,0.000113333,0.000113333,0.000113333,0.000113333,0.000113333,0.000113333,0.000113333,0.000113333,0.000113333,0.000113333,0.000113333,0.000113333,0.000113333,0.000113333,0.000113333,0.000113333,0.000113333,0.000113333,0.000113333,0.000113333,0.000113333,0.00011,0.00011,0.00011,0.00011,0.00011,0.00011,0.00011,0.00011,0.00011,0.00011,0.00011,0.00011,0.00011,0.00011,0.00011,0.00011,0.00011,0.00011,0.00011,0.00011,0.00011,0.00011,0.00011,0.00011,0.00011,0.00011,0.00011,0.00011,0.00011,0.00011,0.00011,0.00011,0.00011,0.00011,0.00011,0.00011,0.000106667,0.000106667,0.000106667,0.000106667,0.000106667,0.000106667,0.000106667,0.000106667,0.000106667,0.000106667,0.000106667,0.000106667,0.000106667,0.000106667,0.000106667,0.000106667,0.000106667,0.000106667,0.000106667,0.000106667,0.000106667,0.000106667,0.000106667,0.000106667,0.000106667,0.000106667,0.000106667,0.000106667,0.000106667,0.000106667,0.000106667,0.000106667,0.000106667,0.000106667,0.000106667,0.000106667,0.000106667,0.000106667,0.000106667,0.000106667,0.000106667,0.000106667,0.000103333,0.000103333,0.000103333,0.000103333,0.000103333,0.000103333,0.000103333,0.000103333,0.000103333,0.000103333,0.000103333,0.000103333,0.000103333,0.000103333,0.000103333,0.000103333,0.000103333,0.000103333,0.000103333,0.000103333,0.000103333,0.000103333,0.000103333,0.000103333,0.000103333,0.000103333,0.000103333,0.000103333,0.000103333,0.000103333,0.000103333,0.000103333,0.000103333,0.000103333,0.000103333,0.000103333,0.000103333,0.000103333,0.000103333,0.000103333,0.000103333,0.000103333,0.000103333,0.000103333,0.000103333,0.0001,0.0001,0.0001,0.0001,0.0001}";"{``,.*,0.0,00:24,01.181929,020,0337,05,+0.61,07:54,09-08-2004,1000,1012,-10.5,1094653909,1117730784,116,12/01/05,1255,13-14,14/02/2005,14th,155.steroid,168,177Kb,1856,1921,1968,1990s,1998,2.0,2005-03-28,20:55,21:58:26,230,2.49,2.589300,2767,29.95,300.00,312314,33,3499.99,363294,3901,400,42,43998,460,4.9,500-599,519,551,5.8.5,6:00,63,659.95,6ES7450K2BRK,718,76,7p.m.,8.22,87007,900MHz,""94,995"",992,¬,“,±,÷,Æ,A13,Aaronson,able,Abuses,acceptable,accomodation,accurate,acknowledge,acted,Activity,Adams,addition,Adjustable,admitted,Adult,Adventure,aerobic,aforesaid,aged,aggregate,agrees,AIDS,Airport,Alanine,aldi,alignment,allow,Aloud,Alternatives,Amaya,american,Amr,analyze,Andy,Animation,Announcements,answering,Antivirus,anywhere,APC22264,appears,Application,appreciated,APPX,Arbor,Arctic,arial,Army,ARTHUR,artists,ashlee,asked,Assault,assignments,association,ate,attached,attitudes,Auctions,Augé,Authoring,Auto,availability,Average,Aware,B0000AKVJC,Bachelor,bag,Ball,bangbus,Banners,barium,baseball,basis,Batman,bazar,Beach,beat,becomes,beer,behalf,believes,Bending,Bernard,Bev,BIDS,BILL,biofoam,birth,BLACKBERRY,Blight,Blond,Blowjobs,board,Bogut,bonds,boost,born,boul,box0,bracketing,branding,breaking,Brian,brilliant,broadband,Brothers,brunbob,Buddha,bugs,bukakke,Buried,Bush,button,bytes,cabinet,Cake,Call,Cambridge,camper,candidates,capabilities,Captain,cards,Caribe,carry,cases,Cassy,categories,Caught'ya,CCC,celebrity,centers,Ceramic,Cezanne,chalkboard,Change,Chapter,charges,charter,Chechen,chemistry,Chicago,Chill,Choose,Christine,churches,Cisco,civil,Clan,classification,cleaning,Click,Clinical,close,club,Co.,cock,Colby,collecting,Collins,Colour,com.c2i2,Comley,Comments,committed,communication,comparative,competition,completeness,compositeur,con,concessions,condo,config.h,Congress,conniving,Considerations,CONSTANTS,consultants,contain,Contents,Continuing,Control,conversion,cool,Copper,Cornell,correct,Costa,Counted,Course,cover,cozinha,Crane,Creating,Crest,Croatia,crush,cube,cumshot,currently,Customer,CyberSpeedz2000,D.,Dale,Dance,Darwin,dating,dbz,deal,Deb,decent,decorated,default,defined,del,delivers,demands,denotes,deploy,derivation,deserve,Desperate,details,Deutermann,device,di,dick,dies,diffs,Ding,directly,disapproval,discovered,disdained,display,distinct,disturbing,Django,document,dog,Dolphin,done,Doris,doubt,Downs,drawing,drive,drop,DS,Duffels,Dutch,dying,earlier,easily,eater,ECMWF,edge,Editorial,effect,efforts,Eiendomme,elected,Electronic,eleven,Eltron,Emerging,employee,Emulation,encouraged,endwise,Engine,enhanced,Enrollment,entertainment,Entry,EPA,Equipment,Erin,ESEA,EST,estimated,EU,evaluation,Event,Everyone,EX,Examples,exchange,executive,exit,Expenditures,expert,explores,extend,extra,Eyes,facesitting,factories,failsafe,falling,Fantasia,Farming,Fat,fax,feature,fee,Fees,FEMINIST,Ffm,Fifth,filing,filters,Financial,Finished,firm,fitness,FL,flavoured,floating,flower,Foam,follando,footage,forderjunk,Form,forms,Forums,fourth,Françaises,FRCS,French,friendly,Frye,fuel,function,fundies,Furniture,G5,galleries,Games,Gardens,Gates,GC,Gene,genesis,George,GETAWAYS,gift,Girl,Glaser,Gloster,Go,gold,Gone,gorgeous,GPs,Graf,granulocyte,greater,Greenskeeper.org,gross,Growth,guess,guitar,guys,habitat,Halcyon,hamper,hands,Happy,harmful,hate,hayes,header,heard,Heath,held,Hematologists,herd,hey,Highest,Hilton,historic,HJ,holders,Holmenkollen,Homespun,hoop,horse,hostess,hou,however,html,Hull,hunting,Hyperlinks,IBM,IDCHLEN,identify,ifps,illustrate,immediate,impairment,Important,improving,inch,incoming,increasingly,Indexed,indictment,INDUSTRIAL,influenced,Ingle,Initiative,Inner,insecurity,inspired,instead,Instructions,integer,intensive,interests,internet,Intimate,inventory,invisible,Iowa,Ireland,isbn,Israel,Italy,itself,Jacks,Japan,Jayson,Jeremy,Jewish,Jobs,Join,Joomla,Js,Julians,jury,k4,Kastrup,keeping,Kentucky.com,keywords,kill,Kings,kkustron,knowledge,Korea,Kunene,L4,Laboratory,Laffey,Land,languages,Largest,later,launched,layouts,leaders,learned,leaves,legal,Leipzig,Les,letter,Leyden,library,Liechtenstein,lights,limitations,linear,LINK,listed,literary,lives,llvmc,lobbyist,locks,logo,longitudinal,Lord,LOTMA,Low,Ltd.,Lung,Lyrics,MacMillan,Magenta,Mail,Maintains,male,managed,Manhattan,manufacturing,Mar,Marigold,Market,MARRON,MARYLAND,Master,materials,matter,maximum,Mc,Me,measure,MEDALION,medium,MegaRAID,membrane,ment,merely,Messenger,methods,Mfr.,Michigan,Middleton,mile,milk,mineral,minister,Minutes,mission,mixed,można,moderated,Mohammadi,Monday,monolayer,monuments,morphological,Mother,Mount,movement,mozilla,Mrs.,muck,multiplication,Mushroom,MX,N.,NAME,NAPOLITANO,native,Nav,near,Nederlands,Neighbourhood,NET,NeverEnding,Newtonmore,NICE,NiLASOFT,NNPT,nomination,normally,NOT,Nothing,novelists,NSWindow,Number,Nutsedge,O.,Objective,obtaining,OCTOBER,offered,official,Ohio,older,Onet.pl,OPEN,operation,Opportunities,Option,Orange,organisation,orientated,orthodoxy,Oulu,Outlet,Over,Overview,Oxford,p4,packages,paid,palace,panel,Papers,parent,Parks,particular,Party,past,Pathological,Patton,payments,PE,pellets,People,Perfect,period,Perry,Pest,Ph.,Philip,Photo,PHPRunner,Pick,piece,pin,pissing,placed,Planning,plastic,player,please,Plug,PO,pokemon,political,pond,popularized,Port,POSITION,Post,posts,pounds,pp.,Prague,predict,premises,preseason,Presidents,pretty,previous,PrimalX,print,Priority,Pro,Process,produces,Professionals,programme,projector,Promotional,Proposal,protecting,prototype,prudential,PT,Publisher,pump,PurePower,puts,Qatar,quantification,Query,Quijote,ra,Radical,RAILWAY,Ranch,Rape,rational,RDF,Read,Reagan,Rear,recallable,recently,recommendations,records,red,reduction,references,refurbished,Regional,regular,REIT,relative,Relevant,remain,remotely,rent,replaced,reported,representing,requirements,reserved,resolved,respiratory,rest,Results,Retreats,Rev.,revised,rhaid,Richmond,Rights,RISK,roadwarrior,Rockin,roll,Room,rot,routine,RSS,rule,running,rx,sadles,Saimiri,sales,sample,Sandra,Sass,savage,saying,scanners,scheduler,Schramski,score,screen,scrubbed,SEARCH,SEC,Section,sedatives,seem,Select,selling,Senior,sentient,serial,servicio,settings,Sex,Shabby,shared,sheep,Shiite,Shirt,shop,Shorts,shown,Sibu,signal,Silk,Simple,Single,sittin,Ski,Slackware,slings,SM,Smokey,SnowShoe,soda,soldier,solutions,sometimes,sont,Sort,source,SP,Sparc,SPECIAL,specified,Spelman,Spinning,spookiest,spree,SQUARE,ST,Stags,standards,Stars,Statement,STATUE,steel,steps,Still,stop,stores,strange,stream,strides,strongest,Student,stuff,Subbuteo,submitted,Substances,Such,Sugandhalaya,Suites,Sun,Superfine,supported,Sure,surrounding,Suzi,Sweetest,Sworn,synthetic,table,Taisen,talk,tape,Task,taxation,teach,TEAM,Technische,TEKS,tell,tend,Terms,Tested,textual,that'sa,Then,There,thing,Thomas,thousand,Thromboembolism,thus,Tigger,timing,Titanic,TN,Tolkien,tool,topographic,toughness,tower,TR,Trading,trained,transform,TRANSPORT,travelled,tree,trial,trio,Truck,try,Tuesday,turned,twice,Type,u,Uk,Unabhängige,Underground,unenforceable,unique,Universities,unmodified,Uow,updates,upward,usability,users,uteri,v.,vacuum,Valley,Van,Various,Vegas,venturing,versus,via,victory,Viewer,Vincent,Virtual,Visit,Vitro,Vol,vote,vs,WA3NAN,walked,wanda,wardrobe,WAS,watches,wax,wears,wedding,weeks,Wellington,wetness,Whether,whom,wide,Wild,Wilson,WINDSOR,Winter,Wise,Wizard,wonderful,Word,Working,worm,wrapped,Written,www.pensxpress.com,xemacs,XT,Yakomo,Yeh,Yoho,youth,Zürich,Zip,ZZAP}";0.105289
"public";"fourgrams";"part4";0;5;52712;"{</S>,"","",.,the,-,and,to,of,<UNK>,in,),(,a,:,for,""\"""",is,on,/,with,that,or,by,'s,|,at,from,are,as,be,;,you,it,not,&,...,I,this,?,',!,1,an,was,have,],will,>,your,2,$,all,[,The,has,which,can,more,their,but,one,*,they,3,we,0,%,his,A,who,=,out,up,other,my,so,+,--,its,our,about,new,5,he,when,4,any,than,were,if,do,been,would,may,into,time,only,such,no,there,them,information,#,free,two,some,like,over,had,her,New,also,8,use,people,should,10,me,just,what,these,6,PM,through,each,work,well,now,""\\"",7,system,@,us,many,set,made,2005,see,after,first,including,said,then,being,very,data,how,most,before,good,here,home,could,under,where,years,make,those,used,because,get,US,..,12,between,him,does,support,based,business,online,year,service,she,20,·,»,available,both,i,sex,number,back,even,site,15,high,must,AM,Home,program,while,2004,three,de,did,without,x,down,24,C,To,using,11,area,page,right,day,during,life,shall,16,18,30,help,public,s,services,13,e,go,Services,state,within,""}"",£,2003,Inc.,off,too,different,full,last,long,need,<,9,News,order,provide,web,against,big,file,great,name,THE,In,game,way,group,health,17,American,list,little,process,same,software,""{"",All,E,School,take,University,best,every,line,school,Web,25,City,John,real,Service,still,children,development,women,21,management,Page,part,100,B,black,include,much,per,14,around,For,products,since,systems,working,book,family,Information,value,Your,again,And,local,show,50,Center,days,State,video,world,~,June,More,OF,old,Online,S,23,Â,County,find,members,Of,You,2002,DVD,Health,place,research,2001,am,another,large,less,May,access,January,non,own,person,students,teen,19,art,North,policy,power,type,0.00,2000,2006,car,girls,small,technology,Business,come,control,December,related,required,AND,left,never,programs,user,change,Date,government,issues,love,music,next,nude,World,Board,design,given,human,least,really,Research,specific,version,current,experience,Free,gay,Guide,low,think,UK,company,following,Group,M,making,model,project,read,South,United,X,areas,class,computer,form,Management,Street,study,training,22,action,case,English,F,food,Internet,level,man,men,NEW,play,today,water,website,27,code,L,point,quality,things,application,away,better,CD,country,end,General,God,might,report,second,security,With,care,International,know,London,property,several,T,26,called,Company,function,games,market,Music,offer,post,rate,results,Search,special,System,want,address,April,body,complete,few,general,It,n,October,Systems,text,together,upon,'ve,community,course,found,IN,Jan,light,money,N,National,needs,network,On,Price,product,Program,search,sites,Windows,29,companies,Contact,cost,date,either,etc.,hard,High,Hotels,news,open,performance,pm,put,Road,section,something,times,top,treatment,W,among,become,call,four,history,job,million,November,personal,porn,size,subject,This,view,West,White,40,ass,Club,contact,financial,give,individual,others,PC,problems,say,Set,St.,'',28,activities,air,Black,College,early,education,From,Hotel,House,important,let,look,office,present,private,provided,Public,questions,R,Software,stories,TO,We,young,above,always,Art,child,D,event,further,future,G,going,July,necessary,provides,pussy,self,series,test,Time,USA,View,came,changes,ever,getting,got,II,image,My,No,once,Site,source,story,student,team,teens,until,©,c,email,enough,insurance,J.,keep,key,land,List,main,makes,Mr.,often,Park,patients,space,start,though,week,words,York,`,31,America,Box,building,buy,By,comments,common,costs,Day,effective,field,hours,issue,known,link,offers,percent,phone,possible,question,run,September,travel,true,whether,^,®,added,along,applications,Association,Canada,check,Data,due,economic,files,hotel,interest,'ll,major,mature,Member,Other,pages,party,please,potential,problem,Products,risk,server,al,already,card,Central,Community,Education,hand,industry,live,looking,media,medical,message,mode,models,price,production,receive,record,room,Series,social,stock,types,via,....,city,countries,Department,Development,equipment,hot,international,item,later,No.,Office,original,P,Read,short,single,someone,staff,States,store,table,title,Washington,What,yet,bit,box,California,clear,click,Council,create,David,especially,existing,five,included,James,member,output,period,return,rights,Security,tax,total,usually,various,Video,0.000,1999,60,Books,Centre,cover,d,designed,details,example,FOR,front,gallery,having,head,language,law,m,means,natural,Network,particular,position,Project,request,review,San,standards,style,Top,Women,°,animal,b,below,China,credit,film,friends,GMT,income,kids,kind,lesbian,machine,March,minutes,normal,oil,plan,Power,prices,release,Report,response,Travel,w,06,base,board,Book,Committee,courses,download,events,federal,g,Green,includes,items,knowledge,'m,M.,Manager,o,Open,pictures,points,Real,strong,thought,unit,unless,visit,01,add,appropriate,August,character,close,developed,directory,done,easy,effects,ensure,eyes,features,final,foreign,gas,H,held,History,house,increase,Media,meet,mp3,needed,Our,past,Phone,picture,Product,'re,solutions,sound,St,users,word,About,according,approach,Blue,Care,cell,Click,decision,Design,drive,else,et,European,far,images,info,Institute,la,Law,links,Links,mail,material,night,One,pay,range,Red,requirements,result,says,similar,Sports,teachers,terms,thing,TV,Type,v,war,written,y,Year,05,1998,32,activity,additional,adult,allow,almost,analysis,bad,books,British,Car,cause,certain,content,described,Do,documents,doing,error,Europe,Forum,fully,fun,Great,growth,however,internet,K,Lake,legal,location,memory,Microsoft,option,outside,rather,received,resources,respect,road,S.,sale,Science,Support,taken,Technology,Texas,turn,V,wrote,35,A.,able,Act,believe,built,CA,Christmas,comes,command,conditions,Conference,Digital,Director,District,Email,en,fast,Fax}";"{0.0548533,0.0420067,0.0293367,0.0225567,0.0192033,0.0191133,0.0135367,0.0132167,0.01266,0.0111133,0.0109633,0.0105933,0.00941667,0.00924667,0.00715333,0.00643667,0.00571333,0.00493,0.00460667,0.00458,0.00454333,0.00379667,0.00356,0.00318333,0.00310667,0.00304667,0.00302667,0.00297333,0.00289,0.0028,0.00269333,0.00254667,0.00253,0.00247,0.00235333,0.00227,0.00220333,0.00216,0.00211,0.00208333,0.00208,0.00198667,0.00197667,0.00189667,0.00183,0.00182667,0.00182667,0.00162333,0.00161333,0.00154,0.00148667,0.00145667,0.00140333,0.00140333,0.00138667,0.00135333,0.00134,0.00127667,0.00123,0.00119667,0.00119333,0.00112667,0.00109333,0.00104667,0.00104,0.00103333,0.001,0.00099,0.000983333,0.000983333,0.000973333,0.000963333,0.000963333,0.0009,0.000886667,0.00088,0.000876667,0.000866667,0.000863333,0.000856667,0.000843333,0.000843333,0.00082,0.000816667,0.000816667,0.00081,0.000806667,0.00078,0.00077,0.000766667,0.000763333,0.00076,0.000753333,0.00074,0.000726667,0.000693333,0.00068,0.000663333,0.00066,0.00066,0.000656667,0.000653333,0.000643333,0.000643333,0.000643333,0.000633333,0.00063,0.000623333,0.00062,0.00062,0.000616667,0.0006,0.00059,0.000586667,0.000563333,0.000556667,0.000553333,0.000546667,0.00054,0.00054,0.000533333,0.000526667,0.000516667,0.000506667,0.000503333,0.000496667,0.000483333,0.000473333,0.000466667,0.000456667,0.000456667,0.00045,0.000446667,0.00044,0.00043,0.000426667,0.00042,0.00042,0.000416667,0.000416667,0.000413333,0.000413333,0.000413333,0.00041,0.00041,0.000406667,0.000406667,0.000406667,0.000403333,0.000403333,0.000403333,0.000403333,0.0004,0.0004,0.0004,0.0004,0.000396667,0.000396667,0.000396667,0.000393333,0.000393333,0.00039,0.000386667,0.000386667,0.000386667,0.000383333,0.00038,0.00038,0.000373333,0.000373333,0.00037,0.00037,0.000366667,0.000366667,0.000363333,0.000363333,0.000363333,0.000363333,0.000363333,0.000363333,0.000363333,0.00036,0.000356667,0.000356667,0.000356667,0.000346667,0.000343333,0.000343333,0.000336667,0.000333333,0.000333333,0.000333333,0.00033,0.00033,0.000326667,0.00032,0.00032,0.00032,0.000316667,0.00031,0.00031,0.00031,0.00031,0.000306667,0.000306667,0.000306667,0.000306667,0.000303333,0.000303333,0.000303333,0.000303333,0.0003,0.0003,0.0003,0.0003,0.0003,0.0003,0.0003,0.000296667,0.000296667,0.000296667,0.000296667,0.000296667,0.000296667,0.000293333,0.000293333,0.00029,0.00029,0.00029,0.00029,0.000286667,0.000286667,0.000286667,0.000286667,0.000286667,0.000283333,0.000283333,0.000283333,0.000283333,0.000283333,0.000283333,0.00028,0.00028,0.00028,0.00028,0.00028,0.00028,0.000276667,0.000273333,0.000273333,0.00027,0.00027,0.000266667,0.000266667,0.000266667,0.000266667,0.000266667,0.000266667,0.000266667,0.000263333,0.000263333,0.000263333,0.000263333,0.000263333,0.00026,0.000256667,0.000256667,0.000256667,0.000256667,0.000256667,0.000253333,0.000253333,0.000253333,0.000253333,0.000253333,0.000253333,0.00025,0.00025,0.00025,0.000246667,0.000246667,0.000246667,0.000246667,0.000243333,0.000243333,0.000243333,0.000243333,0.000243333,0.000243333,0.00024,0.00024,0.00024,0.00024,0.00024,0.00024,0.00024,0.000236667,0.000236667,0.000236667,0.000236667,0.000236667,0.000233333,0.000233333,0.000233333,0.000233333,0.00023,0.00023,0.00023,0.00023,0.00023,0.00023,0.000226667,0.000226667,0.000226667,0.000226667,0.000226667,0.000226667,0.000226667,0.000223333,0.000223333,0.000223333,0.000223333,0.000223333,0.000223333,0.000223333,0.00022,0.00022,0.00022,0.00022,0.00022,0.000216667,0.000216667,0.000216667,0.000216667,0.000216667,0.000216667,0.000213333,0.000213333,0.000213333,0.000213333,0.000213333,0.000213333,0.000213333,0.00021,0.00021,0.00021,0.00021,0.00021,0.00021,0.000206667,0.000206667,0.000206667,0.000206667,0.000206667,0.000206667,0.000206667,0.000203333,0.000203333,0.000203333,0.000203333,0.000203333,0.000203333,0.0002,0.0002,0.0002,0.0002,0.0002,0.000196667,0.000196667,0.000196667,0.000196667,0.000196667,0.000196667,0.000196667,0.000196667,0.000196667,0.000193333,0.000193333,0.000193333,0.000193333,0.000193333,0.000193333,0.000193333,0.000193333,0.000193333,0.00019,0.00019,0.00019,0.00019,0.00019,0.00019,0.00019,0.00019,0.000186667,0.000186667,0.000186667,0.000186667,0.000186667,0.000186667,0.000186667,0.000186667,0.000186667,0.000186667,0.000186667,0.000183333,0.000183333,0.000183333,0.000183333,0.000183333,0.000183333,0.000183333,0.000183333,0.00018,0.00018,0.00018,0.00018,0.00018,0.00018,0.00018,0.00018,0.00018,0.00018,0.00018,0.00018,0.00018,0.00018,0.00018,0.000176667,0.000176667,0.000176667,0.000176667,0.000176667,0.000176667,0.000173333,0.000173333,0.000173333,0.000173333,0.000173333,0.000173333,0.000173333,0.000173333,0.000173333,0.000173333,0.000173333,0.000173333,0.000173333,0.00017,0.00017,0.00017,0.00017,0.00017,0.00017,0.00017,0.000166667,0.000166667,0.000166667,0.000166667,0.000166667,0.000166667,0.000166667,0.000166667,0.000166667,0.000166667,0.000166667,0.000166667,0.000166667,0.000166667,0.000166667,0.000163333,0.000163333,0.000163333,0.000163333,0.000163333,0.000163333,0.000163333,0.000163333,0.000163333,0.000163333,0.000163333,0.000163333,0.000163333,0.000163333,0.00016,0.00016,0.00016,0.00016,0.00016,0.00016,0.00016,0.00016,0.00016,0.00016,0.00016,0.00016,0.00016,0.00016,0.00016,0.00016,0.00016,0.00016,0.000156667,0.000156667,0.000156667,0.000156667,0.000156667,0.000156667,0.000156667,0.000156667,0.000156667,0.000156667,0.000156667,0.000156667,0.000156667,0.000156667,0.000156667,0.000156667,0.000156667,0.000156667,0.000156667,0.000156667,0.000156667,0.000156667,0.000153333,0.000153333,0.000153333,0.000153333,0.000153333,0.000153333,0.000153333,0.000153333,0.000153333,0.000153333,0.000153333,0.000153333,0.000153333,0.000153333,0.000153333,0.000153333,0.00015,0.00015,0.00015,0.00015,0.00015,0.00015,0.00015,0.00015,0.00015,0.00015,0.00015,0.00015,0.00015,0.000146667,0.000146667,0.000146667,0.000146667,0.000146667,0.000146667,0.000146667,0.000146667,0.000146667,0.000146667,0.000146667,0.000146667,0.000146667,0.000146667,0.000146667,0.000146667,0.000146667,0.000146667,0.000146667,0.000146667,0.000146667,0.000146667,0.000146667,0.000146667,0.000146667,0.000146667,0.000143333,0.000143333,0.000143333,0.000143333,0.000143333,0.000143333,0.000143333,0.000143333,0.000143333,0.000143333,0.000143333,0.000143333,0.000143333,0.000143333,0.000143333,0.000143333,0.000143333,0.000143333,0.000143333,0.000143333,0.00014,0.00014,0.00014,0.00014,0.00014,0.00014,0.00014,0.00014,0.00014,0.00014,0.00014,0.00014,0.00014,0.00014,0.00014,0.00014,0.00014,0.000136667,0.000136667,0.000136667,0.000136667,0.000136667,0.000136667,0.000136667,0.000136667,0.000136667,0.000136667,0.000136667,0.000136667,0.000136667,0.000136667,0.000136667,0.000136667,0.000136667,0.000136667,0.000136667,0.000136667,0.000136667,0.000136667,0.000133333,0.000133333,0.000133333,0.000133333,0.000133333,0.000133333,0.000133333,0.000133333,0.000133333,0.000133333,0.000133333,0.000133333,0.000133333,0.000133333,0.000133333,0.000133333,0.000133333,0.000133333,0.000133333,0.000133333,0.000133333,0.000133333,0.000133333,0.000133333,0.000133333,0.000133333,0.000133333,0.00013,0.00013,0.00013,0.00013,0.00013,0.00013,0.00013,0.00013,0.00013,0.00013,0.00013,0.00013,0.00013,0.00013,0.00013,0.00013,0.00013,0.00013,0.00013,0.00013,0.00013,0.00013,0.00013,0.00013,0.00013,0.00013,0.00013,0.000126667,0.000126667,0.000126667,0.000126667,0.000126667,0.000126667,0.000126667,0.000126667,0.000126667,0.000126667,0.000126667,0.000126667,0.000126667,0.000126667,0.000126667,0.000126667,0.000126667,0.000126667,0.000126667,0.000126667,0.000126667,0.000126667,0.000126667,0.000126667,0.000126667,0.000123333,0.000123333,0.000123333,0.000123333,0.000123333,0.000123333,0.000123333,0.000123333,0.000123333,0.000123333,0.000123333,0.000123333,0.000123333,0.000123333,0.000123333,0.000123333,0.000123333,0.000123333,0.000123333,0.000123333,0.000123333,0.000123333,0.000123333,0.000123333,0.000123333,0.000123333,0.00012,0.00012,0.00012,0.00012,0.00012,0.00012,0.00012,0.00012,0.00012,0.00012,0.00012,0.00012,0.00012,0.00012,0.00012,0.00012,0.00012,0.00012,0.00012,0.00012,0.00012,0.00012,0.00012,0.00012,0.000116667,0.000116667,0.000116667,0.000116667,0.000116667,0.000116667,0.000116667,0.000116667,0.000116667,0.000116667,0.000116667,0.000116667,0.000116667,0.000116667,0.000116667,0.000116667,0.000116667,0.000116667,0.000116667,0.000116667,0.000116667,0.000116667,0.000116667,0.000116667,0.000116667,0.000116667,0.000116667,0.000116667,0.000116667,0.000116667,0.000116667,0.000113333,0.000113333,0.000113333,0.000113333,0.000113333,0.000113333,0.000113333,0.000113333,0.000113333,0.000113333,0.000113333,0.000113333,0.000113333,0.000113333,0.000113333,0.000113333,0.000113333,0.000113333,0.000113333,0.000113333,0.000113333,0.000113333,0.000113333,0.000113333,0.000113333,0.000113333,0.00011,0.00011,0.00011,0.00011,0.00011,0.00011,0.00011,0.00011,0.00011,0.00011,0.00011,0.00011,0.00011,0.00011,0.00011,0.00011,0.00011,0.00011,0.00011,0.00011,0.00011,0.00011,0.00011,0.00011,0.00011,0.00011,0.00011,0.000106667,0.000106667,0.000106667,0.000106667,0.000106667,0.000106667,0.000106667,0.000106667,0.000106667,0.000106667,0.000106667,0.000106667,0.000106667,0.000106667,0.000106667,0.000106667,0.000106667,0.000106667,0.000106667,0.000106667,0.000106667,0.000106667,0.000106667,0.000106667,0.000106667,0.000106667,0.000106667,0.000106667,0.000106667,0.000106667,0.000106667,0.000106667,0.000106667,0.000106667,0.000106667,0.000106667,0.000106667,0.000103333,0.000103333,0.000103333,0.000103333,0.000103333,0.000103333,0.000103333,0.000103333,0.000103333,0.000103333,0.000103333,0.000103333,0.000103333,0.000103333,0.000103333,0.000103333,0.000103333,0.000103333,0.000103333,0.000103333,0.000103333,0.000103333,0.000103333,0.000103333,0.000103333,0.000103333,0.000103333,0.000103333,0.000103333,0.000103333,0.000103333,0.000103333,0.000103333,0.000103333,0.000103333,0.000103333,0.000103333,0.000103333,0.000103333,0.000103333,0.000103333,0.000103333,0.000103333,0.0001,0.0001,0.0001,0.0001,0.0001,0.0001,0.0001,0.0001,0.0001,0.0001,0.0001,0.0001,0.0001,0.0001,0.0001,0.0001,0.0001,0.0001,0.0001,0.0001,0.0001,0.0001,0.0001,0.0001,0.0001,0.0001,0.0001,0.0001,0.0001,0.0001,0.0001,0.0001,0.0001,0.0001,0.0001,0.0001,0.0001,0.0001,0.0001,0.0001,0.0001,0.0001,0.0001,0.0001,0.0001,0.0001,0.0001,0.0001,0.0001,0.0001,0.0001,0.0001,9.66667e-05,9.66667e-05,9.66667e-05,9.66667e-05,9.66667e-05,9.66667e-05,9.66667e-05,9.66667e-05,9.66667e-05,9.66667e-05,9.66667e-05,9.66667e-05,9.66667e-05,9.66667e-05,9.66667e-05,9.66667e-05,9.66667e-05,9.66667e-05,9.66667e-05}";"{``,***,0.0000000,0.051044,01:20,02:00,0314991,04:41,06:06,07/30/04,08:50,0.99.2,1.000,10-1/2,10:43,1078742543,11/01/2006,1129952702,1173,121,125.00,131,13m,14.66,15:15,16-26,1710,1806,1899,1931,1969,1987,1994,1a,-2:00,2004-08,2.0.27,21:14:40,223,2368.5,249.89,25840,-27838,2BR/2.5BA,""3,000,000"",317318,333,354,37,3.95,4:00,416,437,46,-485.0,500,5.15pm,54,57,5S,619-628,6488,68.00,701-761,7340,770,8.00,838,889,90ml,95,98hs,¨,‘,±,÷,Ë,A1010,abandon,absence,academic,Access,Accommodation,accounts,acid,Across,active,actually,ADD,adequate,administrative,ads,Advantages,advocacy,affiliated,afternoon,agency,Aging,Agricultural,Air,Airways,Albert,Algebras,Allevard,alone,alternator,amazing,Americans,&,anal,Anderson,animals,Annotation,Ansonia,Antique,anywhere,apocalyptic,Apple,apply,approval,Aqua,Architects,Area,arm,array,Article,Arts,Asia,Asked,assertion,assistance,assumes,atctgctttt,attached,attended,ATX,AUDUBON,AUT,Authorware,Availability,Avg,aware,à ,baby,backpacks,Bahrain,balms,bangs,bar,barriers,basically,baths,Bay,Beach,BEATRICE,bed,begging,Behind,BEN,beppin,Beta,Biblical,bikini,binary,Birdbath,Bl,Blessed,Blog,blowjob,boards,BODY,bone,boot,Bosnia,bounded,boys,branch,break,Breeds,BRIGANCE,broad,brother,Bruno,Budget,buildings,burden,Bush,butterfly,bygone,cabin,cages,Callan,camera,camps,cancer,Cap,Capriccio,cardiff,Carfax,CARRIER,Cartwright,Casino,catalyst,Catovsky,cclient,celebrity,center,CERTAIN,CG1,challenges,Change,Chapman,charged,Chase,Check,Chemistry,chicken,Ching,choose,christmas,chute,Cisco,claim,classes,clean,Clerk,Clinic,closed,club,Co,coat,CODE,Cola,collection,colon,colpo,combined,Command,Commercial,committees,Communities,compatible,Complaint,compliance,comprehensive,conc,conclusion,conducting,configuring,connect,consensus,consist,constructed,consumer,contains,continue,Contractor,Controlled,convey,cooperation,Copyright,CORP,correctly,Cottages4You,Country,coursework,covered,Crab,Cream,credibility,criminal,crop,Cruise,Cuba,cum,currently,customer,cutoff,cynical,DAB,damage,Daniel,database,DAVID,DE,dean,debugger,decisively,dedication,defence,definition,delays,Delivery,Democrats,Dentistry,deployment,des,Designer,Destin,detecting,Deutscher,develpper,di,dibasic,diet,Dig,dine,directed,Directory,DISC,discover,disease,dispatch,distance,district,DIVISION,doctor,dog,domain,DoNotAge,doses,DOWNLOAD,drachma,dream,Drive,drop,Dryers,dumped,dvd,E.,earrings,eastern,Eco,edge,editorial,effect,efforts,EITHER,electric,elegant,elites,Embroidered,Empire,employs,encourage,ENE,engine,enhance,Ensim,entire,envelope,EPG,Equipment,Ernst,esp,estado,Etc,Euro,Event,EVHA,examination,except,Exclusive,exhibitionism,expectations,experimental,explored,expression,extra,f,fabulous,facility,fail,fake,families,fantasy,fashion,fatty,FE,Feb,feed,feet,fence,FFE8E8,Fifth,Filename,filter,Financing,fingering,Firefox,fish,Fittings,Flame,fleet,Flood,flower,FM93C56A,folks,Foods,Force,Forest,Format,Fort,Forza,Fox,France,FREE,Frequencies,FriendEmail,fruit,fucking,Fun,fundamentally,Furniture,Gactimus,Gallery,gamma,garnish,Gaviiformes,GEN,generators,Geological,Germany,ghestes,Gilbert,gives,glide,glutaminyl,Goals,golf,Goodwin,governmental,Graduate,Grant,gratuit,green,grill,groups,GT,Guests,GUITAR,GYN,haha,Halloween,handle,happen,hardware,Harwood,Hawai'i,Head,heard,heated,HELEN,HemCon,Hereford,Hickman,highmem,hindrance,hit,Hockey,holes,homeownership,Honolulu,Horny,host,Hotmail,HOUSING,HTML,Hulme,Hunt,hydromorphone,IC,Ide,Identify,IFAS.,illinois,imitrex,impeding,imported,in.,incestuous,incorruptible,independent,Indiana,Indonesia,Infant,Info,initial,inner,insert,install,Institut,Instruments,Integrated,intention,Interesting,internal,interviews,invent,Investors,Iowa,Iraq,Is,Islands,issued,Items,j,Jacques,Japanese,JE,Jerzees,Jim,jocks,joint,journey,judgments,junior,k,Kate,keeps,kernel,KG,killers,Kirkwood,Kiwanis,knots,Krakout,l',labels,ladies,Land,Lao,Laser,Latin,lavitra,LCD2180WG,Leadership,learning,leaving,legislation,Lens,Let,levels,liberal,Library,Life,lights,limitation,LINE,linked,listed,literature,Liverpool,LLP,Local,Lockets,LOGIN,longer,Lord,lost,Louisiana,lower,Ltd.,Luther,Lyrics,machinery,MAG,mahogany,maintaining,Making,Man,manga,manufacture,Mapping,Marine,marketing,married,Maryland,master,materials,Mattei,maximum,McFly,Meal,measures,Medical,meeting,melted,menopause,mercy,Messenger,method,mg,Michigan,Midnight,MILES,Miller,minds,Minister,Miracles,Mississippi,mixture,Mobile,moderation,Module,Moms,monitoring,month,MORE,Most,Motorama,Mouse,movie,MP3,Msg,Multi,Muri,mutually,N.,Name,NASA,nationwide,navy,nearest,negative,nerves,networks,Newsarama,NH600D,nights,Nissan,noisy,NOPRINT,Northumberland,NOTEBOOK,notifications,Now,NUDES,Nursery,NZ,OBJECT,obtain,occurred,OECD,officers,OGSA,Oklahoma,Olympus,Only,opens,operations,opportunity,Options,Order,organisations,Oriental,Os,ounces,Outlook,overlap,owners,P.,Pack,padded,Painting,pan781203,paper,parallel,Paris,Part,partir,Party,paste,patient,Pavement,Pb,PE,peer,PENNSYLVANIA,perfect,periodic,perpetuities,perspectives,Pewter,Ph.D.,Phono,Photo.net,physical,picked,piece,Pink,Pitsea,Plaid,planning,plants,Play,playmates,plugin,pockets,Poker,Polish,Polyester,poorly,Pork,PORTION,possibility,posting,Poverty,PQRS,pragma,predecessors,premise,presence,President,pretty,priced,Princess,Printers,Privacy,probably,processes,PRODUCERS,Professor,programming,projects,prompts,Prophet,protect,Protocol,Province,PSP,publication,Puebla,puppies,purposes,Pyotr,quake,quartile,quickcam,Quote,rabid,radio,rain,ran,Rape,Rating,RCCL,reaches,ready,reason,receiver,Recipients,reconciled,Recount,redheads,reference,reflection,regarding,Regional,regular,rejection,relatives,reliable,remaining,removed,renting,replies,represent,Republicans,requires,resident,resort,respondants,Restaurant,Results,Return,revidw,revoked,ribs,Riders,Ring,rit1,roaming,rock,roll,roofs,Ross,router,RSM,ruleid,RURAL,'S,safari,Sailing,salesperson,samson,santeria,satified,Save,Sbjct,scene,Schlyter,Sci,score,screen,SD,Searching,secondary,sections,seeds,seen,selection,semester,Senegal,sent,sequence,Server,SET,SeV,sexual,Shaggy,shared,She,Sheriff,SHIPPING,shooting,shortening,Shower,Shutdown,sighed,significant,SimCity,sin,sistas,six,Skier,Sky,Slicers,slution,Smoke,So,society,SOIL,solution,sometimes,sonneries,sorts,Sources,spaces,SPD,Specials,specify,spend,Spiritual,sport,Spring,Square,stable,stamp,Standing,started,STATEMENT,Stations,stayed,step,stick,stolen,Storage,Stover,Strategy,Stress,stronger,Stud,Study,sub,submitted,substitution,suck,suicides,Summer,Sunningdale,supervisors,SUPPORT,surface,Survey,Suzanne,Sweet,Sydney,Syrian,tab,tag,takes,Talks,target,Tatyana,TE,tear,technologies,telephone,TEMP,TENDER,Terms,testimony,TF,THAT,Then,therefore,thinkers,thon,threat,Thu,tickets,Tim,tipped,tits,toilets,ton,tools,topsoil,Touchstone,towards,Toys,trade,trail,tranquil,transition,trash,Trebilcock,Trial,trip,trout,Trustees,tub,Tungsten,turns,Twins,u,ul,uncertain,understanding,unintended,Units,unmoving,Up,Upgrades,urge,USC,Users,utilities,V750,Valdris,values,Variable,vav,vehicles,Vergil,veterinary,Victoria,viewing,vinyl,virus,Vista,voice,volunteer,voyeur,Vulnerabilities,waiver,Wall,WAPsite,warranty,Watch,Wave,weapons,Website,Week,Weird,Were,WHAT,whispered,WHOLESALE,wide,Wildlife,Win32,Winlogon,Wisconsin,wks,wonderful,Wordwide,works,worsening,wrist,wrong,X1,Xmas,xy,Yawn,YES,youngest,z,Zimbabwe,Zz}";0.0777566
"public";"fourgrams";"freq";0;8;5972;"{40,41,42,43,44,46,45,47,48,49,50,51,52,53,54,56,55,58,57,60,59,61,62,63,64,66,65,67,68,69,70,72,71,73,74,75,76,78,77,79,80,83,81,82,86,84,85,88,87,89,90,91,93,92,95,96,98,97,99,94,104,100,102,101,103,105,107,106,110,108,109,113,114,116,111,115,122,118,112,120,117,119,121,124,127,123,128,126,130,125,129,131,136,132,137,134,138,133,140,135,141,142,145,139,148,146,144,150,151,152,149,153,154,143,147,157,156,155,161,164,159,158,170,162,166,169,160,174,172,163,167,165,168,178,171,179,176,173,188,182,177,186,187,194,175,181,180,184,192,185,202,198,189,183,191,190,193,197,201,200,214,196,195,203,204,208,213,216,209,199,210,206,212,219,232,211,231,217,222,207,215,224,228,218,205,220,223,225,227,221,237,226,241,235,234,240,230,229,233,239,244,245,246,236,238,248,242,275,243,271,247,249,252,264,258,255,254,257,251,256,260,261,279,250,262,276,268,263,259,253,265,272,293,269,270,281,285,286,287,267,277,294,266,289,288,273,282,290,274,295,307,280,278,284,300,306,291,301,302,308,292,296,318,299,305,309,297,333,320,321,311,303,304,312,283,338,310,332,319,342,298,315,328,313,325,317,314,349,361,324,323,330,348,329,340,343,380,331,337,334,316,322,339,327,369,352,326,359,345,360,362,364,376,335,351,355,382,371,347,336,350,395,344,353,365,413,346,370,378,354,363,373,375,384,387,368,367,341,356,366,383,389,392,357,358,426,400,412,456,374,388,391,397,422,381,416,429,431,393,398,405,406,372,417,401,403,408,418,432,379,396,428,390,394,385,377,402,414,443,411,386,409,450,459,407,421,438,399,410,430,425,433,439,451,458,460,404,419,423,427,440,463,476,415,442,448,449}";"{0.02455,0.0224967,0.02151,0.0207267,0.01975,0.0185033,0.0183667,0.01724,0.0168433,0.0159167,0.01554,0.0149333,0.01406,0.0135667,0.0134533,0.0128067,0.0125233,0.0122067,0.01185,0.0112867,0.0111033,0.0100133,0.00997667,0.00991667,0.00969333,0.00895333,0.00889333,0.00853,0.00833,0.00806,0.00803,0.00771,0.00750667,0.00733,0.00728,0.00695667,0.00684667,0.0066,0.00648333,0.00612333,0.00594667,0.00583667,0.00579667,0.00573333,0.00552333,0.00547333,0.00545333,0.00518333,0.00515667,0.00514,0.00496333,0.00488333,0.00451333,0.00448333,0.00445,0.00434,0.00433667,0.0043,0.00429667,0.00420333,0.00395,0.00389333,0.00376333,0.00375667,0.00369333,0.00364667,0.00353667,0.00347333,0.00343333,0.00337333,0.00329667,0.00325667,0.00321,0.00313,0.00312667,0.00305,0.00296,0.00288333,0.00288,0.00288,0.00287,0.00273333,0.00273333,0.0027,0.00265,0.00257667,0.00254,0.00249333,0.00244333,0.00243667,0.00227667,0.00224333,0.00224,0.00223667,0.00223,0.00221667,0.00214,0.00213667,0.00205333,0.00203,0.00201,0.00198333,0.00197333,0.00194667,0.00193667,0.00191333,0.00189,0.00183333,0.00181333,0.00181333,0.00179,0.00174333,0.00174,0.00173667,0.00170333,0.00169,0.00165667,0.00165333,0.00164,0.00155667,0.00155333,0.00154333,0.00153667,0.00153333,0.00151667,0.00147,0.00145667,0.00141667,0.00140333,0.0014,0.0014,0.00139,0.00139,0.00137667,0.00135667,0.00128667,0.00127333,0.00126,0.00124667,0.00122333,0.00122,0.00122,0.00122,0.00121667,0.00120333,0.00119,0.00116667,0.00116333,0.00114333,0.00114,0.0011,0.00109333,0.00109,0.00108667,0.00108667,0.00107667,0.00105667,0.00105333,0.00104667,0.00104333,0.00103333,0.00102,0.00101667,0.00101667,0.00101,0.000983333,0.000983333,0.00097,0.00096,0.000946667,0.000943333,0.000936667,0.00093,0.000896667,0.000896667,0.000883333,0.000883333,0.000876667,0.000866667,0.000863333,0.000863333,0.000846667,0.000836667,0.00083,0.000823333,0.000816667,0.000816667,0.00081,0.000806667,0.0008,0.000793333,0.00079,0.00079,0.000776667,0.000756667,0.000743333,0.00072,0.000716667,0.000713333,0.000713333,0.000713333,0.000713333,0.000706667,0.000703333,0.000693333,0.000693333,0.000686667,0.000683333,0.000656667,0.000646667,0.00064,0.00064,0.00064,0.000636667,0.00063,0.00062,0.000616667,0.000613333,0.000606667,0.000606667,0.000606667,0.000603333,0.000603333,0.0006,0.0006,0.0006,0.000596667,0.000593333,0.000586667,0.000576667,0.000573333,0.000566667,0.000566667,0.00056,0.00056,0.000556667,0.00055,0.000546667,0.000546667,0.000526667,0.000523333,0.000523333,0.00052,0.00052,0.000516667,0.00051,0.000503333,0.000503333,0.0005,0.000496667,0.000496667,0.00049,0.000486667,0.000483333,0.000473333,0.000473333,0.00047,0.00047,0.000466667,0.000463333,0.000453333,0.000453333,0.00045,0.000446667,0.000446667,0.000446667,0.000443333,0.000443333,0.000436667,0.000433333,0.000426667,0.000423333,0.000423333,0.000423333,0.00042,0.000416667,0.000413333,0.000413333,0.00041,0.000406667,0.000403333,0.000403333,0.0004,0.00039,0.00039,0.000386667,0.00038,0.00038,0.000373333,0.00037,0.000366667,0.000366667,0.000366667,0.00036,0.00036,0.00036,0.000356667,0.000353333,0.000353333,0.00035,0.000346667,0.000346667,0.000346667,0.000343333,0.000343333,0.00034,0.000333333,0.000333333,0.00033,0.00033,0.00033,0.000326667,0.000326667,0.000323333,0.000323333,0.000323333,0.000323333,0.00032,0.000316667,0.000313333,0.000313333,0.000313333,0.00031,0.00031,0.00031,0.00031,0.000306667,0.000306667,0.000306667,0.000303333,0.000303333,0.000303333,0.000303333,0.000303333,0.000303333,0.0003,0.000296667,0.000293333,0.000293333,0.000293333,0.000286667,0.000283333,0.000283333,0.00028,0.00028,0.000276667,0.000273333,0.000273333,0.00027,0.000266667,0.000266667,0.000263333,0.000263333,0.000263333,0.00026,0.00026,0.00026,0.00026,0.000256667,0.000256667,0.000256667,0.000256667,0.000253333,0.000253333,0.00025,0.00025,0.00025,0.00025,0.00025,0.000246667,0.000246667,0.000246667,0.000243333,0.000243333,0.00024,0.000236667,0.000236667,0.000236667,0.000236667,0.000233333,0.00023,0.00023,0.00023,0.000226667,0.000223333,0.000223333,0.000223333,0.00022,0.00022,0.00022,0.000216667,0.000216667,0.000216667,0.000216667,0.000216667,0.000216667,0.000213333,0.000213333,0.000213333,0.000213333,0.000213333,0.000213333,0.000213333,0.00021,0.00021,0.00021,0.00021}";"{420,420,420,424,424,434,434,435,435,436,436,437,437,441,441,444,444,445,445,446,446,447,447,452,452,453,453,454,454,455,455,457,457,461,462,462,462,464,464,465,465,466,466,467,467,468,468,469,469,470,471,471,472,472,473,473,474,474,475,475,477,477,478,478,479,479,480,480,481,481,482,482,483,483,484,484,485,485,486,486,487,488,488,489,489,490,490,491,491,492,492,493,494,494,495,495,496,496,497,498,498,499,499,500,500,501,502,502,503,503,504,504,505,506,506,507,507,508,509,509,510,510,511,511,512,512,513,514,514,515,516,516,517,517,518,518,519,519,520,521,521,522,523,523,524,524,525,526,526,526,527,528,528,529,530,530,531,532,532,532,533,534,534,535,535,536,537,538,538,539,539,540,540,541,542,542,543,544,544,545,546,546,547,547,548,549,549,550,551,552,552,553,554,554,555,555,556,557,558,558,559,560,560,561,562,562,563,564,564,565,566,567,568,568,569,570,571,572,572,573,573,574,575,576,577,578,579,579,580,580,581,582,583,584,584,585,586,587,588,588,589,590,591,592,592,593,594,594,595,596,597,597,598,599,599,600,601,602,603,604,604,605,606,607,607,608,609,610,611,612,613,614,615,615,616,617,618,619,620,620,621,622,623,624,625,625,627,627,628,629,630,631,632,633,633,634,635,636,637,638,639,640,641,642,643,644,645,646,647,647,648,649,650,651,652,653,654,655,656,657,658,659,660,661,661,662,663,664,665,666,667,668,668,669,670,671,672,673,674,675,676,678,678,679,680,681,682,683,684,685,686,687,688,689,690,692,693,695,696,697,698,699,700,701,702,703,704,706,707,708,709,710,711,712,713,715,716,718,719,720,721,722,723,724,725,726,727,728,729,730,731,732,734,734,736,737,738,739,741,742,744,745,746,747,749,750,751,751,753,754,755,757,758,759,760,761,763,764,765,766,767,769,770,771,772,774,775,777,778,780,781,783,784,786,788,789,790,792,793,794,796,797,798,799,800,802,803,805,806,808,809,810,812,814,815,816,818,819,821,822,823,825,826,829,830,832,834,836,837,838,840,842,844,846,847,849,850,852,854,856,857,859,860,862,863,866,867,869,870,872,873,875,876,878,880,881,883,885,887,889,891,892,894,896,897,899,901,903,905,908,910,912,913,915,917,920,921,923,925,927,929,931,933,936,937,939,940,942,943,946,948,950,952,955,956,959,961,963,965,968,970,972,974,976,977,980,981,983,985,987,989,991,994,995,998,1001,1003,1005,1007,1010,1013,1015,1018,1020,1022,1024,1026,1028,1030,1032,1035,1037,1040,1042,1045,1048,1050,1053,1055,1056,1059,1062,1064,1067,1069,1071,1074,1075,1078,1081,1083,1087,1089,1092,1093,1096,1098,1101,1103,1106,1108,1110,1114,1117,1120,1123,1125,1128,1132,1134,1138,1140,1143,1147,1150,1153,1157,1160,1164,1167,1170,1173,1176,1179,1183,1187,1190,1192,1196,1200,1203,1206,1210,1213,1217,1220,1223,1226,1230,1232,1235,1238,1242,1245,1248,1251,1254,1257,1260,1264,1266,1270,1273,1276,1280,1282,1285,1289,1292,1295,1298,1302,1306,1311,1315,1318,1321,1324,1328,1332,1335,1338,1343,1346,1351,1354,1359,1363,1367,1371,1376,1382,1387,1391,1396,1400,1404,1408,1413,1419,1422,1426,1430,1435,1439,1443,1447,1451,1454,1458,1463,1468,1473,1478,1485,1490,1497,1501,1506,1511,1517,1521,1527,1532,1536,1540,1544,1549,1555,1561,1567,1572,1578,1583,1588,1593,1597,1602,1608,1615,1621,1626,1632,1639,1645,1650,1656,1663,1671,1675,1682,1686,1693,1699,1707,1712,1720,1728,1734,1742,1749,1755,1763,1770,1778,1786,1794,1802,1806,1813,1821,1830,1836,1845,1852,1859,1866,1873,1881,1888,1894,1903,1910,1916,1925,1936,1943,1954,1962,1968,1977,1987,1994,2003,2014,2021,2032,2043,2052,2059,2070,2079,2089,2098,2107,2115,2125,2135,2145,2154,2163,2172,2183,2191,2202,2212,2219,2227,2238,2252,2263,2278,2287,2298,2307,2316,2327,2336,2343,2357,2369,2387,2398,2411,2426,2437,2450,2465,2478,2491,2509,2521,2531,2549,2566,2584,2594,2614,2633,2644,2662,2677,2691,2705,2718,2735,2752,2766,2782,2805,2827,2846,2861,2879,2893,2903,2919,2941,2956,2968,2983,2999,3017,3034,3045,3067,3087,3117,3130,3152,3174,3190,3211,3230,3259,3280,3297,3315,3344,3374,3393,3419,3445,3481,3508,3540,3570,3609,3628,3657,3692,3729,3765,3796,3835,3872,3910,3945,3983,4012,4042,4091,4131,4154,4194,4220,4254,4313,4353,4393,4443,4482,4550,4582,4621,4655,4742,4794,4844,4902,4952,5004,5058,5131,5200,5266,5315,5377,5436,5498,5567,5635,5718,5788,5878,5950,6046,6124,6254,6343,6416,6515,6619,6677,6776,6872,6965,7050,7163,7304,7423,7547,7680,7845,7952,8121,8303,8457,8662,8870,9100,9257,9495,9743,10020,10265,10470,10691,10931,11248,11673,12050,12457,12675,13201,13765,14264,14734,15349,16102,16613,17233,18239,18839,20306,21471,22569,23881,25016,27137,29264,31613,34295,38463,44701,50931,60782,72271,99770,166351,2693966}";-0.0122433