pgFouine: PostgreSQL log analysis report

Overall statistics | Queries by type | Slowest queries | Queries that took up the most time (N) | Most frequent queries (N) | Slowest queries (N)

Normalized reports are marked with a "(N)".

Overall statistics ^

Queries by type ^

Type Count Percentage
SELECT 210,483 100.0

Slowest queries ^

Rank Duration (s) Query
1 0.28
SELECT * FROM accounts WHERE aid=68552;
2 0.27
SELECT * FROM accounts WHERE aid=60888;
3 0.24
SELECT * FROM accounts WHERE aid=91343;
4 0.24
SELECT * FROM accounts WHERE aid=51575;
5 0.24
SELECT history.* FROM accounts, history WHERE accounts.aid=11473 AND accounts.aid=history.aid;
6 0.23
SELECT * FROM accounts WHERE aid=56300;
7 0.21
SELECT * FROM accounts WHERE aid=33659;
8 0.21
SELECT * FROM accounts WHERE aid=83461;
9 0.21
SELECT * FROM accounts WHERE aid=98611;
10 0.21
SELECT * FROM accounts WHERE aid=50781;
11 0.20
SELECT * FROM accounts WHERE aid=39924;
12 0.20
SELECT * FROM accounts WHERE aid=25571;
13 0.20
SELECT * FROM accounts WHERE aid=27704;
14 0.18
SELECT * FROM accounts WHERE aid=95049;
15 0.18
SELECT * FROM accounts WHERE aid=99805;
16 0.18
SELECT * FROM accounts WHERE aid=5322;
17 0.18
SELECT * FROM accounts WHERE aid=35954;
18 0.18
SELECT * FROM accounts WHERE aid=76969;
19 0.18
SELECT history.* FROM accounts, history WHERE accounts.aid=46372 AND accounts.aid=history.aid;
20 0.18
SELECT * FROM accounts WHERE aid=15366;

Queries that took up the most time (N) ^

Rank Total duration Times executed Av. duration (s) Query
1 17m13s
23,387
Day Time Count Av. Duration
Dec 8 11am 635 0.05
  12pm 708 0.04
  1pm 678 0.04
  2pm 673 0.04
  3pm 570 0.04
  4pm 589 0.04
  5pm 555 0.04
  6pm 533 0.04
  7pm 502 0.04
  8pm 516 0.04
  9pm 491 0.04
  10pm 464 0.04
  11pm 461 0.04
Dec 9 12am 434 0.04
  1am 417 0.04
  2am 407 0.04
  3am 387 0.04
  4am 412 0.04
  5am 402 0.04
  6am 391 0.04
  7am 361 0.04
  8am 371 0.04
  9am 357 0.04
  10am 357 0.04
  11am 350 0.04
  12pm 339 0.04
  1pm 327 0.04
  2pm 328 0.04
  3pm 329 0.04
  4pm 321 0.04
  5pm 318 0.04
  6pm 314 0.04
  7pm 317 0.04
  8pm 309 0.04
  9pm 304 0.04
  10pm 307 0.04
  11pm 303 0.04
Dec 10 12am 284 0.04
  1am 274 0.04
  2am 276 0.04
  3am 268 0.04
  4am 273 0.04
  5am 246 0.04
  6am 260 0.04
  7am 264 0.04
  8am 266 0.04
  9am 263 0.04
  10am 258 0.04
  11am 265 0.04
  12pm 251 0.04
  1pm 247 0.04
  2pm 250 0.04
  3pm 245 0.04
  4pm 239 0.04
  5pm 246 0.04
  6pm 241 0.04
  7pm 230 0.04
  8pm 228 0.04
  9pm 223 0.04
  10pm 233 0.04
  11pm 232 0.04
Dec 11 12am 230 0.04
  1am 229 0.04
  2am 224 0.04
  3am 226 0.04
  4am 225 0.04
  5am 222 0.04
  6am 132 0.04
0.04
SELECT history.* FROM accounts, history WHERE accounts.aid=0 AND accounts.aid=history.aid;
2 15m4s
23,387
Day Time Count Av. Duration
Dec 8 11am 635 0.04
  12pm 708 0.04
  1pm 678 0.04
  2pm 673 0.04
  3pm 570 0.04
  4pm 589 0.04
  5pm 555 0.04
  6pm 533 0.04
  7pm 502 0.04
  8pm 516 0.04
  9pm 491 0.04
  10pm 464 0.04
  11pm 461 0.04
Dec 9 12am 434 0.04
  1am 417 0.04
  2am 407 0.04
  3am 387 0.04
  4am 412 0.04
  5am 402 0.04
  6am 391 0.04
  7am 361 0.04
  8am 371 0.04
  9am 357 0.04
  10am 357 0.04
  11am 350 0.04
  12pm 339 0.04
  1pm 327 0.04
  2pm 328 0.04
  3pm 329 0.04
  4pm 321 0.04
  5pm 318 0.04
  6pm 314 0.04
  7pm 317 0.04
  8pm 309 0.04
  9pm 304 0.04
  10pm 307 0.04
  11pm 303 0.04
Dec 10 12am 284 0.04
  1am 274 0.04
  2am 276 0.04
  3am 268 0.04
  4am 273 0.04
  5am 246 0.04
  6am 260 0.04
  7am 264 0.04
  8am 266 0.04
  9am 263 0.04
  10am 258 0.04
  11am 265 0.04
  12pm 251 0.04
  1pm 247 0.04
  2pm 250 0.04
  3pm 245 0.04
  4pm 239 0.04
  5pm 246 0.04
  6pm 241 0.04
  7pm 230 0.04
  8pm 228 0.04
  9pm 223 0.04
  10pm 233 0.04
  11pm 232 0.04
Dec 11 12am 230 0.04
  1am 229 0.04
  2am 224 0.04
  3am 226 0.04
  4am 225 0.04
  5am 222 0.04
  6am 132 0.04
0.04
SELECT accounts.* FROM accounts,history WHERE history.aid=0 AND accounts.aid=history.aid;
3 13m56s
23,387
Day Time Count Av. Duration
Dec 8 11am 635 0.04
  12pm 708 0.04
  1pm 678 0.04
  2pm 673 0.04
  3pm 570 0.04
  4pm 589 0.03
  5pm 555 0.04
  6pm 533 0.04
  7pm 502 0.03
  8pm 516 0.04
  9pm 491 0.04
  10pm 464 0.04
  11pm 461 0.04
Dec 9 12am 434 0.04
  1am 417 0.04
  2am 407 0.04
  3am 387 0.04
  4am 412 0.04
  5am 402 0.04
  6am 391 0.04
  7am 361 0.04
  8am 371 0.04
  9am 357 0.04
  10am 357 0.04
  11am 350 0.04
  12pm 339 0.04
  1pm 327 0.03
  2pm 328 0.03
  3pm 329 0.04
  4pm 321 0.04
  5pm 318 0.04
  6pm 314 0.04
  7pm 317 0.04
  8pm 309 0.04
  9pm 304 0.04
  10pm 307 0.04
  11pm 303 0.04
Dec 10 12am 284 0.04
  1am 274 0.04
  2am 276 0.04
  3am 268 0.04
  4am 273 0.04
  5am 246 0.04
  6am 260 0.04
  7am 264 0.04
  8am 266 0.04
  9am 263 0.04
  10am 258 0.04
  11am 265 0.04
  12pm 251 0.04
  1pm 247 0.04
  2pm 250 0.04
  3pm 245 0.04
  4pm 239 0.04
  5pm 246 0.04
  6pm 241 0.03
  7pm 230 0.04
  8pm 228 0.04
  9pm 223 0.04
  10pm 233 0.03
  11pm 232 0.04
Dec 11 12am 230 0.04
  1am 229 0.04
  2am 224 0.03
  3am 226 0.04
  4am 225 0.04
  5am 222 0.04
  6am 132 0.04
0.04
SELECT history.* FROM accounts, branches, tellers, history WHERE accounts.aid=0 AND branches.bid=accounts.aid AND tellers.bid=accounts.aid AND history.aid=accounts.aid AND history.bid=branches.bid AND history.tid=tellers.tid;
4 5m32s
46,774
Day Time Count Av. Duration
Dec 8 11am 1,270 0.03
  12pm 1,416 0.01
  1pm 1,356 0.01
  2pm 1,346 0.00
  3pm 1,141 0.00
  4pm 1,177 0.00
  5pm 1,110 0.00
  6pm 1,067 0.00
  7pm 1,003 0.00
  8pm 1,032 0.00
  9pm 982 0.00
  10pm 928 0.00
  11pm 922 0.00
Dec 9 12am 868 0.00
  1am 834 0.00
  2am 814 0.01
  3am 774 0.01
  4am 824 0.01
  5am 804 0.01
  6am 783 0.01
  7am 722 0.01
  8am 741 0.01
  9am 714 0.01
  10am 715 0.01
  11am 699 0.00
  12pm 679 0.01
  1pm 653 0.00
  2pm 656 0.01
  3pm 658 0.00
  4pm 642 0.01
  5pm 636 0.00
  6pm 629 0.00
  7pm 633 0.00
  8pm 619 0.01
  9pm 607 0.00
  10pm 614 0.01
  11pm 606 0.01
Dec 10 12am 568 0.01
  1am 548 0.01
  2am 552 0.01
  3am 537 0.01
  4am 546 0.01
  5am 492 0.01
  6am 520 0.01
  7am 528 0.01
  8am 532 0.01
  9am 525 0.01
  10am 516 0.01
  11am 530 0.01
  12pm 502 0.01
  1pm 494 0.01
  2pm 500 0.01
  3pm 490 0.01
  4pm 479 0.01
  5pm 491 0.01
  6pm 482 0.01
  7pm 461 0.01
  8pm 455 0.01
  9pm 447 0.01
  10pm 465 0.01
  11pm 464 0.01
Dec 11 12am 461 0.01
  1am 458 0.01
  2am 447 0.01
  3am 452 0.01
  4am 451 0.01
  5am 443 0.01
  6am 264 0.01
0.01
SELECT * FROM accounts WHERE aid=0;
5 1m38s
23,387
Day Time Count Av. Duration
Dec 8 11am 635 0.00
  12pm 708 0.00
  1pm 678 0.00
  2pm 673 0.00
  3pm 571 0.01
  4pm 588 0.00
  5pm 555 0.01
  6pm 534 0.00
  7pm 501 0.01
  8pm 516 0.00
  9pm 491 0.01
  10pm 464 0.00
  11pm 461 0.01
Dec 9 12am 434 0.01
  1am 417 0.00
  2am 407 0.00
  3am 387 0.00
  4am 412 0.00
  5am 402 0.00
  6am 392 0.00
  7am 361 0.01
  8am 370 0.00
  9am 357 0.00
  10am 358 0.00
  11am 349 0.00
  12pm 340 0.00
  1pm 326 0.00
  2pm 328 0.01
  3pm 329 0.00
  4pm 321 0.00
  5pm 318 0.01
  6pm 315 0.01
  7pm 316 0.00
  8pm 310 0.01
  9pm 303 0.01
  10pm 307 0.00
  11pm 303 0.01
Dec 10 12am 284 0.00
  1am 274 0.00
  2am 276 0.01
  3am 269 0.01
  4am 273 0.00
  5am 246 0.01
  6am 260 0.01
  7am 264 0.00
  8am 266 0.00
  9am 262 0.00
  10am 258 0.00
  11am 265 0.00
  12pm 251 0.00
  1pm 247 0.01
  2pm 250 0.00
  3pm 245 0.01
  4pm 240 0.00
  5pm 245 0.00
  6pm 241 0.00
  7pm 231 0.01
  8pm 227 0.01
  9pm 224 0.01
  10pm 232 0.00
  11pm 232 0.00
Dec 11 12am 231 0.00
  1am 229 0.00
  2am 223 0.00
  3am 226 0.01
  4am 226 0.00
  5am 221 0.01
  6am 132 0.01
0.00
SELECT * FROM branches WHERE bid=0;
6 1m6s
70,161
Day Time Count Av. Duration
Dec 8 11am 1,905 0.00
  12pm 2,124 0.00
  1pm 2,034 0.00
  2pm 2,019 0.00
  3pm 1,711 0.00
  4pm 1,766 0.00
  5pm 1,665 0.00
  6pm 1,600 0.00
  7pm 1,505 0.00
  8pm 1,548 0.00
  9pm 1,473 0.00
  10pm 1,392 0.00
  11pm 1,383 0.00
Dec 9 12am 1,302 0.00
  1am 1,251 0.00
  2am 1,221 0.00
  3am 1,161 0.00
  4am 1,236 0.00
  5am 1,206 0.00
  6am 1,174 0.00
  7am 1,083 0.00
  8am 1,112 0.00
  9am 1,071 0.00
  10am 1,072 0.00
  11am 1,049 0.00
  12pm 1,018 0.00
  1pm 980 0.00
  2pm 984 0.00
  3pm 987 0.00
  4pm 963 0.00
  5pm 954 0.00
  6pm 943 0.00
  7pm 950 0.00
  8pm 928 0.00
  9pm 911 0.00
  10pm 921 0.00
  11pm 909 0.00
Dec 10 12am 852 0.00
  1am 822 0.00
  2am 828 0.00
  3am 805 0.00
  4am 819 0.00
  5am 738 0.00
  6am 780 0.00
  7am 792 0.00
  8am 798 0.00
  9am 788 0.00
  10am 774 0.00
  11am 795 0.00
  12pm 753 0.00
  1pm 741 0.00
  2pm 750 0.00
  3pm 735 0.00
  4pm 718 0.00
  5pm 737 0.00
  6pm 723 0.00
  7pm 691 0.00
  8pm 683 0.00
  9pm 670 0.00
  10pm 698 0.00
  11pm 696 0.00
Dec 11 12am 691 0.00
  1am 687 0.00
  2am 671 0.00
  3am 678 0.00
  4am 676 0.00
  5am 665 0.00
  6am 396 0.00
0.00
SELECT * FROM tellers WHERE tid=0;

Most frequent queries (N) ^

Rank Times executed Total duration Av. duration (s) Query
1
70,161
Day Time Count Av. Duration
Dec 8 11am 1,905 0.00
  12pm 2,124 0.00
  1pm 2,034 0.00
  2pm 2,019 0.00
  3pm 1,711 0.00
  4pm 1,766 0.00
  5pm 1,665 0.00
  6pm 1,600 0.00
  7pm 1,505 0.00
  8pm 1,548 0.00
  9pm 1,473 0.00
  10pm 1,392 0.00
  11pm 1,383 0.00
Dec 9 12am 1,302 0.00
  1am 1,251 0.00
  2am 1,221 0.00
  3am 1,161 0.00
  4am 1,236 0.00
  5am 1,206 0.00
  6am 1,174 0.00
  7am 1,083 0.00
  8am 1,112 0.00
  9am 1,071 0.00
  10am 1,072 0.00
  11am 1,049 0.00
  12pm 1,018 0.00
  1pm 980 0.00
  2pm 984 0.00
  3pm 987 0.00
  4pm 963 0.00
  5pm 954 0.00
  6pm 943 0.00
  7pm 950 0.00
  8pm 928 0.00
  9pm 911 0.00
  10pm 921 0.00
  11pm 909 0.00
Dec 10 12am 852 0.00
  1am 822 0.00
  2am 828 0.00
  3am 805 0.00
  4am 819 0.00
  5am 738 0.00
  6am 780 0.00
  7am 792 0.00
  8am 798 0.00
  9am 788 0.00
  10am 774 0.00
  11am 795 0.00
  12pm 753 0.00
  1pm 741 0.00
  2pm 750 0.00
  3pm 735 0.00
  4pm 718 0.00
  5pm 737 0.00
  6pm 723 0.00
  7pm 691 0.00
  8pm 683 0.00
  9pm 670 0.00
  10pm 698 0.00
  11pm 696 0.00
Dec 11 12am 691 0.00
  1am 687 0.00
  2am 671 0.00
  3am 678 0.00
  4am 676 0.00
  5am 665 0.00
  6am 396 0.00
1m6s 0.00
SELECT * FROM tellers WHERE tid=0;
2
46,774
Day Time Count Av. Duration
Dec 8 11am 1,270 0.03
  12pm 1,416 0.01
  1pm 1,356 0.01
  2pm 1,346 0.00
  3pm 1,141 0.00
  4pm 1,177 0.00
  5pm 1,110 0.00
  6pm 1,067 0.00
  7pm 1,003 0.00
  8pm 1,032 0.00
  9pm 982 0.00
  10pm 928 0.00
  11pm 922 0.00
Dec 9 12am 868 0.00
  1am 834 0.00
  2am 814 0.01
  3am 774 0.01
  4am 824 0.01
  5am 804 0.01
  6am 783 0.01
  7am 722 0.01
  8am 741 0.01
  9am 714 0.01
  10am 715 0.01
  11am 699 0.00
  12pm 679 0.01
  1pm 653 0.00
  2pm 656 0.01
  3pm 658 0.00
  4pm 642 0.01
  5pm 636 0.00
  6pm 629 0.00
  7pm 633 0.00
  8pm 619 0.01
  9pm 607 0.00
  10pm 614 0.01
  11pm 606 0.01
Dec 10 12am 568 0.01
  1am 548 0.01
  2am 552 0.01
  3am 537 0.01
  4am 546 0.01
  5am 492 0.01
  6am 520 0.01
  7am 528 0.01
  8am 532 0.01
  9am 525 0.01
  10am 516 0.01
  11am 530 0.01
  12pm 502 0.01
  1pm 494 0.01
  2pm 500 0.01
  3pm 490 0.01
  4pm 479 0.01
  5pm 491 0.01
  6pm 482 0.01
  7pm 461 0.01
  8pm 455 0.01
  9pm 447 0.01
  10pm 465 0.01
  11pm 464 0.01
Dec 11 12am 461 0.01
  1am 458 0.01
  2am 447 0.01
  3am 452 0.01
  4am 451 0.01
  5am 443 0.01
  6am 264 0.01
5m32s 0.01
SELECT * FROM accounts WHERE aid=0;
3
23,387
Day Time Count Av. Duration
Dec 8 11am 635 0.05
  12pm 708 0.04
  1pm 678 0.04
  2pm 673 0.04
  3pm 570 0.04
  4pm 589 0.04
  5pm 555 0.04
  6pm 533 0.04
  7pm 502 0.04
  8pm 516 0.04
  9pm 491 0.04
  10pm 464 0.04
  11pm 461 0.04
Dec 9 12am 434 0.04
  1am 417 0.04
  2am 407 0.04
  3am 387 0.04
  4am 412 0.04
  5am 402 0.04
  6am 391 0.04
  7am 361 0.04
  8am 371 0.04
  9am 357 0.04
  10am 357 0.04
  11am 350 0.04
  12pm 339 0.04
  1pm 327 0.04
  2pm 328 0.04
  3pm 329 0.04
  4pm 321 0.04
  5pm 318 0.04
  6pm 314 0.04
  7pm 317 0.04
  8pm 309 0.04
  9pm 304 0.04
  10pm 307 0.04
  11pm 303 0.04
Dec 10 12am 284 0.04
  1am 274 0.04
  2am 276 0.04
  3am 268 0.04
  4am 273 0.04
  5am 246 0.04
  6am 260 0.04
  7am 264 0.04
  8am 266 0.04
  9am 263 0.04
  10am 258 0.04
  11am 265 0.04
  12pm 251 0.04
  1pm 247 0.04
  2pm 250 0.04
  3pm 245 0.04
  4pm 239 0.04
  5pm 246 0.04
  6pm 241 0.04
  7pm 230 0.04
  8pm 228 0.04
  9pm 223 0.04
  10pm 233 0.04
  11pm 232 0.04
Dec 11 12am 230 0.04
  1am 229 0.04
  2am 224 0.04
  3am 226 0.04
  4am 225 0.04
  5am 222 0.04
  6am 132 0.04
17m13s 0.04
SELECT history.* FROM accounts, history WHERE accounts.aid=0 AND accounts.aid=history.aid;
4
23,387
Day Time Count Av. Duration
Dec 8 11am 635 0.04
  12pm 708 0.04
  1pm 678 0.04
  2pm 673 0.04
  3pm 570 0.04
  4pm 589 0.04
  5pm 555 0.04
  6pm 533 0.04
  7pm 502 0.04
  8pm 516 0.04
  9pm 491 0.04
  10pm 464 0.04
  11pm 461 0.04
Dec 9 12am 434 0.04
  1am 417 0.04
  2am 407 0.04
  3am 387 0.04
  4am 412 0.04
  5am 402 0.04
  6am 391 0.04
  7am 361 0.04
  8am 371 0.04
  9am 357 0.04
  10am 357 0.04
  11am 350 0.04
  12pm 339 0.04
  1pm 327 0.04
  2pm 328 0.04
  3pm 329 0.04
  4pm 321 0.04
  5pm 318 0.04
  6pm 314 0.04
  7pm 317 0.04
  8pm 309 0.04
  9pm 304 0.04
  10pm 307 0.04
  11pm 303 0.04
Dec 10 12am 284 0.04
  1am 274 0.04
  2am 276 0.04
  3am 268 0.04
  4am 273 0.04
  5am 246 0.04
  6am 260 0.04
  7am 264 0.04
  8am 266 0.04
  9am 263 0.04
  10am 258 0.04
  11am 265 0.04
  12pm 251 0.04
  1pm 247 0.04
  2pm 250 0.04
  3pm 245 0.04
  4pm 239 0.04
  5pm 246 0.04
  6pm 241 0.04
  7pm 230 0.04
  8pm 228 0.04
  9pm 223 0.04
  10pm 233 0.04
  11pm 232 0.04
Dec 11 12am 230 0.04
  1am 229 0.04
  2am 224 0.04
  3am 226 0.04
  4am 225 0.04
  5am 222 0.04
  6am 132 0.04
15m4s 0.04
SELECT accounts.* FROM accounts,history WHERE history.aid=0 AND accounts.aid=history.aid;
5
23,387
Day Time Count Av. Duration
Dec 8 11am 635 0.04
  12pm 708 0.04
  1pm 678 0.04
  2pm 673 0.04
  3pm 570 0.04
  4pm 589 0.03
  5pm 555 0.04
  6pm 533 0.04
  7pm 502 0.03
  8pm 516 0.04
  9pm 491 0.04
  10pm 464 0.04
  11pm 461 0.04
Dec 9 12am 434 0.04
  1am 417 0.04
  2am 407 0.04
  3am 387 0.04
  4am 412 0.04
  5am 402 0.04
  6am 391 0.04
  7am 361 0.04
  8am 371 0.04
  9am 357 0.04
  10am 357 0.04
  11am 350 0.04
  12pm 339 0.04
  1pm 327 0.03
  2pm 328 0.03
  3pm 329 0.04
  4pm 321 0.04
  5pm 318 0.04
  6pm 314 0.04
  7pm 317 0.04
  8pm 309 0.04
  9pm 304 0.04
  10pm 307 0.04
  11pm 303 0.04
Dec 10 12am 284 0.04
  1am 274 0.04
  2am 276 0.04
  3am 268 0.04
  4am 273 0.04
  5am 246 0.04
  6am 260 0.04
  7am 264 0.04
  8am 266 0.04
  9am 263 0.04
  10am 258 0.04
  11am 265 0.04
  12pm 251 0.04
  1pm 247 0.04
  2pm 250 0.04
  3pm 245 0.04
  4pm 239 0.04
  5pm 246 0.04
  6pm 241 0.03
  7pm 230 0.04
  8pm 228 0.04
  9pm 223 0.04
  10pm 233 0.03
  11pm 232 0.04
Dec 11 12am 230 0.04
  1am 229 0.04
  2am 224 0.03
  3am 226 0.04
  4am 225 0.04
  5am 222 0.04
  6am 132 0.04
13m56s 0.04
SELECT history.* FROM accounts, branches, tellers, history WHERE accounts.aid=0 AND branches.bid=accounts.aid AND tellers.bid=accounts.aid AND history.aid=accounts.aid AND history.bid=branches.bid AND history.tid=tellers.tid;
6
23,387
Day Time Count Av. Duration
Dec 8 11am 635 0.00
  12pm 708 0.00
  1pm 678 0.00
  2pm 673 0.00
  3pm 571 0.01
  4pm 588 0.00
  5pm 555 0.01
  6pm 534 0.00
  7pm 501 0.01
  8pm 516 0.00
  9pm 491 0.01
  10pm 464 0.00
  11pm 461 0.01
Dec 9 12am 434 0.01
  1am 417 0.00
  2am 407 0.00
  3am 387 0.00
  4am 412 0.00
  5am 402 0.00
  6am 392 0.00
  7am 361 0.01
  8am 370 0.00
  9am 357 0.00
  10am 358 0.00
  11am 349 0.00
  12pm 340 0.00
  1pm 326 0.00
  2pm 328 0.01
  3pm 329 0.00
  4pm 321 0.00
  5pm 318 0.01
  6pm 315 0.01
  7pm 316 0.00
  8pm 310 0.01
  9pm 303 0.01
  10pm 307 0.00
  11pm 303 0.01
Dec 10 12am 284 0.00
  1am 274 0.00
  2am 276 0.01
  3am 269 0.01
  4am 273 0.00
  5am 246 0.01
  6am 260 0.01
  7am 264 0.00
  8am 266 0.00
  9am 262 0.00
  10am 258 0.00
  11am 265 0.00
  12pm 251 0.00
  1pm 247 0.01
  2pm 250 0.00
  3pm 245 0.01
  4pm 240 0.00
  5pm 245 0.00
  6pm 241 0.00
  7pm 231 0.01
  8pm 227 0.01
  9pm 224 0.01
  10pm 232 0.00
  11pm 232 0.00
Dec 11 12am 231 0.00
  1am 229 0.00
  2am 223 0.00
  3am 226 0.01
  4am 226 0.00
  5am 221 0.01
  6am 132 0.01
1m38s 0.00
SELECT * FROM branches WHERE bid=0;

Slowest queries (N) ^

Rank Av. duration (s) Times executed Total duration Query
1 0.04
23,387
Day Time Count Av. Duration
Dec 8 11am 635 0.05
  12pm 708 0.04
  1pm 678 0.04
  2pm 673 0.04
  3pm 570 0.04
  4pm 589 0.04
  5pm 555 0.04
  6pm 533 0.04
  7pm 502 0.04
  8pm 516 0.04
  9pm 491 0.04
  10pm 464 0.04
  11pm 461 0.04
Dec 9 12am 434 0.04
  1am 417 0.04
  2am 407 0.04
  3am 387 0.04
  4am 412 0.04
  5am 402 0.04
  6am 391 0.04
  7am 361 0.04
  8am 371 0.04
  9am 357 0.04
  10am 357 0.04
  11am 350 0.04
  12pm 339 0.04
  1pm 327 0.04
  2pm 328 0.04
  3pm 329 0.04
  4pm 321 0.04
  5pm 318 0.04
  6pm 314 0.04
  7pm 317 0.04
  8pm 309 0.04
  9pm 304 0.04
  10pm 307 0.04
  11pm 303 0.04
Dec 10 12am 284 0.04
  1am 274 0.04
  2am 276 0.04
  3am 268 0.04
  4am 273 0.04
  5am 246 0.04
  6am 260 0.04
  7am 264 0.04
  8am 266 0.04
  9am 263 0.04
  10am 258 0.04
  11am 265 0.04
  12pm 251 0.04
  1pm 247 0.04
  2pm 250 0.04
  3pm 245 0.04
  4pm 239 0.04
  5pm 246 0.04
  6pm 241 0.04
  7pm 230 0.04
  8pm 228 0.04
  9pm 223 0.04
  10pm 233 0.04
  11pm 232 0.04
Dec 11 12am 230 0.04
  1am 229 0.04
  2am 224 0.04
  3am 226 0.04
  4am 225 0.04
  5am 222 0.04
  6am 132 0.04
17m13s
SELECT history.* FROM accounts, history WHERE accounts.aid=0 AND accounts.aid=history.aid;
2 0.04
23,387
Day Time Count Av. Duration
Dec 8 11am 635 0.04
  12pm 708 0.04
  1pm 678 0.04
  2pm 673 0.04
  3pm 570 0.04
  4pm 589 0.04
  5pm 555 0.04
  6pm 533 0.04
  7pm 502 0.04
  8pm 516 0.04
  9pm 491 0.04
  10pm 464 0.04
  11pm 461 0.04
Dec 9 12am 434 0.04
  1am 417 0.04
  2am 407 0.04
  3am 387 0.04
  4am 412 0.04
  5am 402 0.04
  6am 391 0.04
  7am 361 0.04
  8am 371 0.04
  9am 357 0.04
  10am 357 0.04
  11am 350 0.04
  12pm 339 0.04
  1pm 327 0.04
  2pm 328 0.04
  3pm 329 0.04
  4pm 321 0.04
  5pm 318 0.04
  6pm 314 0.04
  7pm 317 0.04
  8pm 309 0.04
  9pm 304 0.04
  10pm 307 0.04
  11pm 303 0.04
Dec 10 12am 284 0.04
  1am 274 0.04
  2am 276 0.04
  3am 268 0.04
  4am 273 0.04
  5am 246 0.04
  6am 260 0.04
  7am 264 0.04
  8am 266 0.04
  9am 263 0.04
  10am 258 0.04
  11am 265 0.04
  12pm 251 0.04
  1pm 247 0.04
  2pm 250 0.04
  3pm 245 0.04
  4pm 239 0.04
  5pm 246 0.04
  6pm 241 0.04
  7pm 230 0.04
  8pm 228 0.04
  9pm 223 0.04
  10pm 233 0.04
  11pm 232 0.04
Dec 11 12am 230 0.04
  1am 229 0.04
  2am 224 0.04
  3am 226 0.04
  4am 225 0.04
  5am 222 0.04
  6am 132 0.04
15m4s
SELECT accounts.* FROM accounts,history WHERE history.aid=0 AND accounts.aid=history.aid;
3 0.04
23,387
Day Time Count Av. Duration
Dec 8 11am 635 0.04
  12pm 708 0.04
  1pm 678 0.04
  2pm 673 0.04
  3pm 570 0.04
  4pm 589 0.03
  5pm 555 0.04
  6pm 533 0.04
  7pm 502 0.03
  8pm 516 0.04
  9pm 491 0.04
  10pm 464 0.04
  11pm 461 0.04
Dec 9 12am 434 0.04
  1am 417 0.04
  2am 407 0.04
  3am 387 0.04
  4am 412 0.04
  5am 402 0.04
  6am 391 0.04
  7am 361 0.04
  8am 371 0.04
  9am 357 0.04
  10am 357 0.04
  11am 350 0.04
  12pm 339 0.04
  1pm 327 0.03
  2pm 328 0.03
  3pm 329 0.04
  4pm 321 0.04
  5pm 318 0.04
  6pm 314 0.04
  7pm 317 0.04
  8pm 309 0.04
  9pm 304 0.04
  10pm 307 0.04
  11pm 303 0.04
Dec 10 12am 284 0.04
  1am 274 0.04
  2am 276 0.04
  3am 268 0.04
  4am 273 0.04
  5am 246 0.04
  6am 260 0.04
  7am 264 0.04
  8am 266 0.04
  9am 263 0.04
  10am 258 0.04
  11am 265 0.04
  12pm 251 0.04
  1pm 247 0.04
  2pm 250 0.04
  3pm 245 0.04
  4pm 239 0.04
  5pm 246 0.04
  6pm 241 0.03
  7pm 230 0.04
  8pm 228 0.04
  9pm 223 0.04
  10pm 233 0.03
  11pm 232 0.04
Dec 11 12am 230 0.04
  1am 229 0.04
  2am 224 0.03
  3am 226 0.04
  4am 225 0.04
  5am 222 0.04
  6am 132 0.04
13m56s
SELECT history.* FROM accounts, branches, tellers, history WHERE accounts.aid=0 AND branches.bid=accounts.aid AND tellers.bid=accounts.aid AND history.aid=accounts.aid AND history.bid=branches.bid AND history.tid=tellers.tid;
4 0.01
46,774
Day Time Count Av. Duration
Dec 8 11am 1,270 0.03
  12pm 1,416 0.01
  1pm 1,356 0.01
  2pm 1,346 0.00
  3pm 1,141 0.00
  4pm 1,177 0.00
  5pm 1,110 0.00
  6pm 1,067 0.00
  7pm 1,003 0.00
  8pm 1,032 0.00
  9pm 982 0.00
  10pm 928 0.00
  11pm 922 0.00
Dec 9 12am 868 0.00
  1am 834 0.00
  2am 814 0.01
  3am 774 0.01
  4am 824 0.01
  5am 804 0.01
  6am 783 0.01
  7am 722 0.01
  8am 741 0.01
  9am 714 0.01
  10am 715 0.01
  11am 699 0.00
  12pm 679 0.01
  1pm 653 0.00
  2pm 656 0.01
  3pm 658 0.00
  4pm 642 0.01
  5pm 636 0.00
  6pm 629 0.00
  7pm 633 0.00
  8pm 619 0.01
  9pm 607 0.00
  10pm 614 0.01
  11pm 606 0.01
Dec 10 12am 568 0.01
  1am 548 0.01
  2am 552 0.01
  3am 537 0.01
  4am 546 0.01
  5am 492 0.01
  6am 520 0.01
  7am 528 0.01
  8am 532 0.01
  9am 525 0.01
  10am 516 0.01
  11am 530 0.01
  12pm 502 0.01
  1pm 494 0.01
  2pm 500 0.01
  3pm 490 0.01
  4pm 479 0.01
  5pm 491 0.01
  6pm 482 0.01
  7pm 461 0.01
  8pm 455 0.01
  9pm 447 0.01
  10pm 465 0.01
  11pm 464 0.01
Dec 11 12am 461 0.01
  1am 458 0.01
  2am 447 0.01
  3am 452 0.01
  4am 451 0.01
  5am 443 0.01
  6am 264 0.01
5m32s
SELECT * FROM accounts WHERE aid=0;
5 0.00
23,387
Day Time Count Av. Duration
Dec 8 11am 635 0.00
  12pm 708 0.00
  1pm 678 0.00
  2pm 673 0.00
  3pm 571 0.01
  4pm 588 0.00
  5pm 555 0.01
  6pm 534 0.00
  7pm 501 0.01
  8pm 516 0.00
  9pm 491 0.01
  10pm 464 0.00
  11pm 461 0.01
Dec 9 12am 434 0.01
  1am 417 0.00
  2am 407 0.00
  3am 387 0.00
  4am 412 0.00
  5am 402 0.00
  6am 392 0.00
  7am 361 0.01
  8am 370 0.00
  9am 357 0.00
  10am 358 0.00
  11am 349 0.00
  12pm 340 0.00
  1pm 326 0.00
  2pm 328 0.01
  3pm 329 0.00
  4pm 321 0.00
  5pm 318 0.01
  6pm 315 0.01
  7pm 316 0.00
  8pm 310 0.01
  9pm 303 0.01
  10pm 307 0.00
  11pm 303 0.01
Dec 10 12am 284 0.00
  1am 274 0.00
  2am 276 0.01
  3am 269 0.01
  4am 273 0.00
  5am 246 0.01
  6am 260 0.01
  7am 264 0.00
  8am 266 0.00
  9am 262 0.00
  10am 258 0.00
  11am 265 0.00
  12pm 251 0.00
  1pm 247 0.01
  2pm 250 0.00
  3pm 245 0.01
  4pm 240 0.00
  5pm 245 0.00
  6pm 241 0.00
  7pm 231 0.01
  8pm 227 0.01
  9pm 224 0.01
  10pm 232 0.00
  11pm 232 0.00
Dec 11 12am 231 0.00
  1am 229 0.00
  2am 223 0.00
  3am 226 0.01
  4am 226 0.00
  5am 221 0.01
  6am 132 0.01
1m38s
SELECT * FROM branches WHERE bid=0;
6 0.00
70,161
Day Time Count Av. Duration
Dec 8 11am 1,905 0.00
  12pm 2,124 0.00
  1pm 2,034 0.00
  2pm 2,019 0.00
  3pm 1,711 0.00
  4pm 1,766 0.00
  5pm 1,665 0.00
  6pm 1,600 0.00
  7pm 1,505 0.00
  8pm 1,548 0.00
  9pm 1,473 0.00
  10pm 1,392 0.00
  11pm 1,383 0.00
Dec 9 12am 1,302 0.00
  1am 1,251 0.00
  2am 1,221 0.00
  3am 1,161 0.00
  4am 1,236 0.00
  5am 1,206 0.00
  6am 1,174 0.00
  7am 1,083 0.00
  8am 1,112 0.00
  9am 1,071 0.00
  10am 1,072 0.00
  11am 1,049 0.00
  12pm 1,018 0.00
  1pm 980 0.00
  2pm 984 0.00
  3pm 987 0.00
  4pm 963 0.00
  5pm 954 0.00
  6pm 943 0.00
  7pm 950 0.00
  8pm 928 0.00
  9pm 911 0.00
  10pm 921 0.00
  11pm 909 0.00
Dec 10 12am 852 0.00
  1am 822 0.00
  2am 828 0.00
  3am 805 0.00
  4am 819 0.00
  5am 738 0.00
  6am 780 0.00
  7am 792 0.00
  8am 798 0.00
  9am 788 0.00
  10am 774 0.00
  11am 795 0.00
  12pm 753 0.00
  1pm 741 0.00
  2pm 750 0.00
  3pm 735 0.00
  4pm 718 0.00
  5pm 737 0.00
  6pm 723 0.00
  7pm 691 0.00
  8pm 683 0.00
  9pm 670 0.00
  10pm 698 0.00
  11pm 696 0.00
Dec 11 12am 691 0.00
  1am 687 0.00
  2am 671 0.00
  3am 678 0.00
  4am 676 0.00
  5am 665 0.00
  6am 396 0.00
1m6s
SELECT * FROM tellers WHERE tid=0;
Report generated by pgFouine 1.0. pgFouine is free software.
Table of contents