Are you registered but unsure how to get started? Or not yet registered but interested in participating? Have challenge specific questions? This webinar is for you! Please join us for this 30-minute webinar with the opportunity to ask questions. Registration is not required, just drop in.
The MIDRC mRALE Mastermind Challenge is organized in the spirit of cooperative scientific progress that benefits the common good and health outcomes for all. Your contributions could help advance the diagnosis, treatment, and prognosis of COVID-19.
The goal of this Challenge is to train an artificial intelligence/machine learning (AI/ML) model in the task of predicting COVID severity in terms of mRALE score [Li et al] from frontal-view portable chest radiographs (CXRs) obtained within 2 days of a positive COVID-19 test. This Challenge provides annotated training data, i.e., chest radiographs and their mRALE scores as assigned by a team of experts. The data for model validation and testing will not be made available for download, however. Instead, you will submit containerized code of your trained model for inference on this Challenge platform against the validation and test datasets. This Challenge uses Docker as a containerization solution.
First and second place teams: MIDRC support to take your method/model through the FDA regulatory process.
Cash prizes through 7th place!
1st Place - $ 15,000
2nd Place - $ 8,000
3rd Place - $ 7,000
4th - 7th Place - $ 5,000 each
See the "Terms and Conditions" for constraints on receiving MIDRC support through regulatory approval and on receiving cash prizes. Also note that many MIDRC investigators and their labs are excluded from competing per our conflict of interest policy.
All participants with valid submissions in the Challenge test phase will receive contributor credit on Challenge manuscripts and acknowledgment at AAPM and RSNA 2023 annual meetings as well as on midrc.org.
We are excited to be conducting this Challenge and hope you will participate! We encourage you to invite your colleagues and friends to create a team. Please make sure to familiarize yourself with the Challenge by navigating through the links (on the left) and tabs (at the top) and read the “Terms and Conditions” before signing up. You will need to agree to these "Terms and Conditions" as part of the sign-up process.
Li et al reference: Matthew D. Li, Nishanth T. Arun, Mishka Gidwani, Ken Chang, Francis Deng, Brent P. Little, Dexter P. Mendoza, Min Lang, Susanna I. Lee, Aileen O’Shea, Anushri Parakh, Praveer Singh, and Jayashree Kalpathy-Cramer, Radiology: Artificial Intelligence 2020 2:4, https://doi.org/10.1148/ryai.2020200079
The Challenge has 3 phases: (1) a training phase (which includes practice submissions so that you can familiarize yourself with the platform and code containerization), (2) a validation phase, and (3) a test phase.
Please click your profile at the top right corner where your screen name is to set the "Team name" in your individual profile settings.
During the Challenge training phase, you are encouraged to use the provided annotated training cohort (see the "Get Data" link under the "Participate" tab) for model development and training on your local hardware. At this time, you also have the opportunity to perform practice submissions. For this purpose, a small set of ‘practice’ chest radiographs in DICOM format are available for download directly from the Challenge platform. Submissions to the Challenge platform during the training phase will perform inference on this very limited number of ‘practice’ DICOM images. This is intended to allow you to troubleshoot general issues with Docker submissions, reading DICOM images, and to verify that your algorithm's output by case is the same locally as on the Challenge platform. This small dataset is not intended for training. Please use this opportunity to "test drive" the submission process and resolve any issues you encounter to minimize potential problems during later phases. Only limited technical assistance will be available after the training phase. There is a maximum of 20 practice submissions per team.
During the Challenge validation phase, you will submit your trained model(s) to the Challenge platform to perform inference and evaluation on the unpublished validation set (which will not be available for download). The validation phase allows you to (1) further familiarize yourself with the containerization and submission process of your code and trained model(s) and (2) to fine-tune your model(s). A Leaderboard will be available during the validation phase to promote friendly competition.There is a maximum of 10 submissions per team in this phase.
During the Challenge test phase, you will submit your most promising model(s) to the Challenge platform for inference and evaluation on the unpublished test set (which will not be available for download). There is a maximum of 3 submissions per team in this phase.
Please go to "Challenge Details" (left) to learn more about this Challenge. The "Tutorials" link on the left provides valuable information on Docker and includes tutorial videos on Docker installation, using Docker, as well as on downloading data from data.midrc.org, and the submission process to this Challenge platform. Please also review the "Terms and Conditions" (left) for additional important information.
Discussion of the Challenge on the Forum ("Forums" tab) is encouraged. The Forum should be used for any questions you may have about this Challenge so that Challenge organizers can help if needed, and other participants can benefit from questions and answers.
Once you are ready to participate, go to the "Participate" tab and log in or register for an account when prompted. You are required to agree to the Challenge "Terms and Conditions" to access the Challenge platform so please read them beforehand (see link on the left).
The task is to predict COVID-19 severity in terms of mRALE score from portable chest radiographs (CXRs) obtained within 2 days of a positive COVID test. The acronym mRALE stands for modified RALE score which, in turn, stands for Radiographic Assessment of Lung Edema. This grading scale was originally validated for use in pulmonary edema assessment in acute respiratory distress syndrome and incorporates the extent and density of alveolar opacities on chest radiographs. The grading system is relevant to COVID-19 patients as the chest radiograph findings tend to involve multifocal alveolar opacities, and many hospitalized COVID-19 patients develop acute respiratory distress syndrome. To obtain an mRALE score, each lung is assigned a score for the extent of involvement by consolidation or ground glass/hazy opacities (0 = "none"; 1 = "≤ 25%"; 2 = "25%–50%"; 3 = "51%–75%"; 4 = ">75%" involvement). Each lung score is then multiplied by an overall density score (1 = "hazy", 2 = "moderate", 3 = "dense"). The sum of scores from each lung is the mRALE score. Thus, a normal chest radiograph receives a score of 0, while a chest radiograph with complete consolidation of both lungs receives the maximum score of 24.
Reference: Matthew D. Li, Nishanth T. Arun, Mishka Gidwani, Ken Chang, Francis Deng, Brent P. Little, Dexter P. Mendoza, Min Lang, Susanna I. Lee, Aileen O’Shea, Anushri Parakh, Praveer Singh, and Jayashree Kalpathy-Cramer, Radiology: Artificial Intelligence 2020 2:4, https://doi.org/10.1148/ryai.2020200079
The CXR exams have been annotated in terms of left lung/right lung extent of involvement and density from which the mRALE score has been calculated. Note that for frontal CXR, the left lung is displayed on the right and vice versa. For completeness, and potential use in model training, the individual left/right lung assessments are included in the annotation file (see "Get Data") with self-explanatory column headers and the encoding for involvement: 0 = "none"; 1 = "≤ 25%"; 2 = "25%–50%"; 3 = "51%–75%"; 4 = ">75%" involvement, and for overall density:1 = "hazy", 2 = "moderate", 3 = "dense".
The estimated mRALE score is the only output your AI/ML model needs to provide. Other output scores are not allowed.
You can find helpful material, including annotations and a file manifest for downloading training data from data.midrc.org, on our mRALE Mastermind Challenge GitHub repo.
The primary performance metric to rank submissions is quadratic-weighted kappa. Submissions will be ranked using the primary performance metric. A statistically significant difference in performance between the winner and runners-up is not required to "win" the Challenge. Only performance on the test set will be used to rank submissions. A secondary performance metric, prediction probability concordance (PK), will be used to break ties, if needed.
The output of your model should be an estimated mRALE score (a single score per CXR image), which is an intereger score between 0 (normal) and 24 (the most severe).
The output of your method should be provided in a single comma-separated CSV file with image name in the first column and the corresponding output mRALE score in the second column.
* Make sure the header and rows are in this specific format:
fileNamePath,score [coming soon]
<dicom-name-1>.dcm,<integer mRALE score between 0 and 24>
<dicom-name-2>.dcm,<integer mRALE score between 0 and 24>
<dicom-name-3>.dcm,<integer mRALE score between 0 and 24>
...
etc.
The system specifications are as follows:
Azure VM Name
|
vCPU
|
RAM (GB)
|
Temp Storage SSD (GB)
|
GPU
|
GPU Memory (GB)
|
Max uncached disk throughput:
IOPS/MBps |
Max NICs
|
Standard_NC6s_v3
|
6
|
112
|
736
|
1
|
16
|
20000/200
|
4
|
Note that internet connectivity is not provided within the Challenge platform. All necessary code, model weights, and library requirements need to be provided in your submission. GPU will only be available during the validation and test phases, not for the practice submissions during the training phase.
You need to supply a zip archive that contains a Dockerfile, all necessary code, and a trained model to allow the Challenge platform to build a Docker Image to run and evaluate your model on the practice cases, validation, or test sets, depending on the Challenge phase, respectively. Example zip archives suitable for submission are provided in the "Starting Kit" (go to the "Participate" tab, then to "Files"). Each trained model needs to be submitted in its own zip archive. It is important to note that all model training and fine-tuning needs to be performed on your own hardware. The Challenge platform only performs inference using trained models submitted in the required format.
There is no performance assessment for the practice submissions using the practice data.The performance of your model(s) will be reported back to you and shown on the Leaderboard in the validation phase. For the test phase, performance will be reported after conclusion of the Challenge.
In the test phase, a description of your model and training data (plain text or Word file) needs to be included in your zip archive submission for your submission to be considered a valid submission, i.e., for its performance to be reported back to you and to be part of the Challenge.
It is advisable to have Docker installed on your local computer so you can check locally how your code runs within a Docker Image. Go to https://docs.docker.com/ to learn more about how to install Docker on your own computer. The videos at the "Tutorials" link (left) provideadditional information.
Docker Images will be built and run on the Challenge platform with Docker version 20.10.13 and above, so, if possible, a local install of Docker should be that version or higher.
It is highly encouraged that you allow MIDRC to make your code and trained model(s) public on the MIDRC GitHub (see "Terms and Conditions").
Challenge data
|
Data available for download
|
Data available on platform for inference
|
Number of CXR exams
|
Training
|
Yes
|
Yes
|
~2,000
|
Practice submission
|
Yes
|
Yes
|
12
|
Validation
|
No
|
No
|
~200
|
Test
|
No
|
No
|
~800
|
Challenge phase
|
Leaderboard
|
GPU available
|
Maximum number of submissions
|
Maximum size of zip archive submissions
|
Maximum submission run time on platform
|
Training
|
N/A
|
N/A
|
999
|
15.0 GB
|
1000 seconds
|
Validation
|
Yes
|
Yes
|
10
|
15.0 GB
|
2500 seconds
|
Test
|
No
|
Yes
|
3
|
15.0 GB
|
5000 seconds
|
All model training and fine-tuning needs to be performed on your own hardware. The Challenge platform submission system should be used for inference only using a trained model during the Docker practice submission period and for the validation and test phases of the Challenge.
The validation and test data will not be made available to participants and both sets contain unpublished data (to be made publicly available in time after conclusion of this Challenge).
It is highly encouraged to practice submitting a Docker archive to the platform during the Challenge training phase for inference on the small set of ‘practice’ cases on the Challenge platform. Technical help will not be available to your team in later phases of the Challenge if your team did not participate in the practice submissions.
CXRs for the Challenge validation and test datasets
For more details see the "Get Data" link under the "Participate" tab.
Within the Challenge platform, Docker submissions will not be allowed to access the internet (e.g., downloading pre-trained ImageNet weights will not be possible). Everything needed to successfully run your model needs to be included in your submitted Docker container.
GPU will be available on the Challenge platform only during the validation and test phases.
Submissions that exit with an error, i.e., submissions that fail, do not count towards the maximum number of submissions allowed.
Please note that not all tutorial videos below have sound at this time.
By participating in this Challenge, each participant agrees to the following:
Participation in this Challenge acknowledges the educational and community-building nature of the Challenge and commits participants to conduct consistent with this spirit for the advancement of the medical imaging research community.
For more background information on the expected conduct of participants, see this article for a discussion of lessons learned from the LUNGx Challenge, which was sponsored by SPIE, AAPM, and NCI.
Anonymous participation is not allowed.
Participants from the same research group, company, or collaboration are required to participate as a team, i.e., form a team within the Challenge platform.
Individual participants should form a single-user team.
Team size is limited to 8 participants.
Participants may only join one team.
Entry by commercial entities is permitted but must be disclosed.
No conflict of interest may exist for any team to be considered in the final ranking as per the MIDRC Grand Challenge Conflict Policy.
All participants must attest that they are not directly affiliated with the labs of any of the Challenge organizers or major contributors.
Registration after the deadline will not be considered for the Challenge (see ‘Important dates’ at the bottom of the “Overview” page).
Participants are strongly encouraged to agree to MIDRC making their code and trained model(s), including weights, publicly available after completion of the Challenge. In order for a participating team to win cash prizes, it is a requirement to allow MIDRC to make the team's code and trained model weights publicly available.
Note: If the top 2 performing teams decide they'd like MIDRC support for going through the FDA regulatory process of their model (see the section on performance evaluation), this will preclude any requirement of making code publicly available and any publication of results by the Challenge organizers will be done in such a way as not to harm any potential commercialization prospects.
Descriptions of participants’ methods and results may become part of presentations, publications, and subsequent analyses derived from the Challenge (with proper attribution to the participants) at the discretion of the organizers. While methods and results may become part of Challenge reports and publications, participants may choose not to disclose their identity and remain anonymous for the purpose of these reports.
Only fully automated methods are acceptable for the Challenge. It is not possible, and not allowed, to submit manual annotations or interactive methods.
Using transfer learning/fine-tuning of models pretrained on general-purpose datasets (e.g., ImageNet) is allowed.
Once participants make a submission within the test phase of the Challenge, they will be considered fully vested in the challenge, so that their performance results will become part of any presentations, publications, or subsequent analyses derived from the Challenge at the discretion of the organizers. Withdrawal at this point is not allowed but participants can choose to have their results reported anonymously in these presentations and publications.
For submissions in the test phase, participants will be required to disclose a description of their methods and training data used. Without this, a submission will be considered invalid. In other words, a description of the method/model (plain text or Word file) needs to be included in your zip archive submission in order for a submission to be considered a valid submission, i.e., for its performance to be reported back and to be part of the Challenge.
Each Challenge phase has a maximum number of submissions allowed per team (see the “Challenge Details” page). Submissions that result in errors flagged by the Challenge platform will be labeled “Failed” and do not count towards the maximum number of submissions allowed. After the maximum number of submissions for a team is reached, the Challenge system will not accept further submissions to the applicable Challenge phase.
Performance on the test dataset, i.e., performance in the test phase of the Challenge, will be used to rank submissions and determine the Challenge placement of participating teams.
The primary performance metric will be used to rank submissions.
Raking of submissions will be performed using the value for the primary performance metric, without taking into account statistical significance of any differences in performance among submissions. Thus, it is not required to demonstrate a statistically significantly better performance than other submissions to "win" the Challenge.
A secondary performance metric will be used to break ties, if needed.
The highest-performing submission of a participating team will determine the team's ranking within the Challenge.
The top 2 performing teams will have the opportunity to receive support from MIDRC through the FDA regulatory process of their method through the evaluation of their method using the MIDRC sequestered (non-public) Data Commons, provided that their best submission substantially, and statistically significantly, outperforms random guessing.
Cash prizes will be awarded to the top 7 teams as outlined on the "Overview" page, provided that these teams agree to MIDRC making their code and trained models public and that their best submission substantially, and statistically significantly, outperforms random guessing. The top 2 teams do not need to make their code/model public if they want to take this code/model through the regulatory process with MIDRC support.
All participants with a valid submission in the test phase will receive contributor credit on Challenge publications, acknowledgement at AAPM and RSNA 2023 annual meetings as well as on midrc.org.
In the validation phase, the performance of your submission will automatically be put on the Leaderboard. There is no Leaderboard in the test phase.
See the "Challenge Details" page under the "Learn the Details" tab for the performance metrics used in this Challenge.
Technical help will be provided by Challenge organizers as much as possible if problems arise during the submission process. However, help to teams in the validation and test phases of the Challenge will be limited and may not always be possible. Teams that did not participate in the practice submissions during the training phase will receive the lowest priority and may not receive any help.
It is imperative to read the “Challenge Logistics” and “Challenge Details” pages (links in the menu on the left) and we also suggest that you visit the “Tutorials” page (link in menu on the left) prior to attempting to make any submissions.
The “Forums” tab should be used to communicate all questions or issues regarding the Challenge.
Start: April 26, 2023, 3 p.m.
Description: Training phase: create models and upload your docker images in preparation for the test phase.
Start: June 10, 2023, 7 p.m.
Description: Validation phase: create models and upload your docker images in preparation for the test phase. Also perform test runs on validation data.
Start: July 1, 2023, 3 p.m.
Description: Test phase
July 10, 2023, 9 p.m.
You must be logged in to participate in competitions.
Sign InName | Version |
---|---|
Analytical | 0.15.0 |
Bootstrapform | 3.2 |
Captcha | 0.4.5 |
Compressor | 1.3 |
Debug toolbar | 1.3.0 |
Django | 1.6.11 |
Django config gen | 1.0.8 |
Django extensions | 1.5.7 |
Django js reverse | 0.9.1 |
Django nose | 1.4.1 |
Django switchuser | 0.6.1 |
Guardian | 1.1.1 |
Haystack | 2.4.0 |
Mptt | 0.5.5 |
Oauth2 provider | 0.6.1 |
Python | 2.7.17 |
Rest framework | 2.3.6 |
South | 1.0.2 |
Storages | 1.3.2 |
Resource | Value |
---|---|
User CPU time | 783.933 msec |
System CPU time | 114.356 msec |
Total CPU time | 898.289 msec |
Elapsed time | 916.240 msec |
Context switches | 4916 voluntary, 6 involuntary |
Timing attribute | Timeline | Milliseconds since navigation start (+length) |
---|
Setting | Value |
---|---|
ABSOLUTE_URL_OVERRIDES | {} |
ACCOUNT_ADAPTER | 'apps.authenz.adapter.CodalabAccountAdapter' |
ACCOUNT_AUTHENTICATION_METHOD | 'username_email' |
ACCOUNT_EMAIL_REQUIRED | True |
ACCOUNT_EMAIL_VERIFICATION | None |
ACCOUNT_LOGOUT_ON_GET | True |
ACCOUNT_SIGNUP_FORM_CLASS | 'apps.authenz.forms.CodalabSignupForm' |
ACCOUNT_USERNAME_REQUIRED | True |
ADMINS | None |
ADMIN_FOR | () |
ALLOWED_HOSTS | ['*', 'midrc-medici.southcentralus.cloudapp.azure.com'] |
ALLOWED_INCLUDE_ROOTS | () |
ANONYMOUS_USER_ID | -1 |
APPEND_SLASH | True |
AUTHENTICATION_BACKENDS | ('django.contrib.auth.backends.ModelBackend',
'allauth.account.auth_backends.AuthenticationBackend',
'guardian.backends.ObjectPermissionBackend') |
AUTH_USER_MODEL | 'authenz.ClUser' |
AWS_ACCESS_KEY_ID | u'********************' |
AWS_QUERYSTRING_AUTH | False |
AWS_S3_CALLING_FORMAT | 'boto.s3.connection.OrdinaryCallingFormat' |
AWS_S3_HOST | 's3-us-west-2.amazonaws.com' |
AWS_S3_SECURE_URLS | 1 |
AWS_SECRET_ACCESS_KEY | u'********************' |
AWS_STORAGE_BUCKET_NAME | None |
AWS_STORAGE_PRIVATE_BUCKET_NAME | None |
AZURE_ACCOUNT_KEY | u'********************' |
AZURE_ACCOUNT_NAME | 'midrccodalabcu' |
AZURE_ACR_TOKEN_NAME | u'********************' |
AZURE_ACR_TOKEN_PASS | u'********************' |
AZURE_BLOB_SERVICE_HOST_BASE | None |
AZURE_CONTAINER | 'public' |
AZURE_CONTAINER_REGISTRY | 'midrcgen3' |
AZURE_TENANT_ID | '563337ca-a517-421a-aae0-1aa5b414fd7f' |
BROKER_POOL_LIMIT | None |
BROKER_URL | 'pyamqp://guest:guest@rabbit:5672//' |
BROKER_USE_SSL | False |
BUNDLE_AZURE_ACCOUNT_KEY | u'********************' |
BUNDLE_AZURE_ACCOUNT_NAME | 'midrccodalabcu' |
BUNDLE_AZURE_CONTAINER | 'bundles' |
BUNDLE_SERVICE_URL | '' |
CACHES | {'default': {'BACKEND': 'django.core.cache.backends.memcached.PyLibMCCache',
'LOCATION': 'memcached:11211'}} |
CACHE_MIDDLEWARE_ALIAS | 'default' |
CACHE_MIDDLEWARE_KEY_PREFIX | u'********************' |
CACHE_MIDDLEWARE_SECONDS | 600 |
CELERYBEAT_SCHEDULE | {'chahub_competition_updates': {'schedule': datetime.timedelta(1),
'task': 'apps.web.tasks.send_chahub_competition_updates'},
'chahub_general_statistics': {'schedule': datetime.timedelta(1),
'task': 'apps.web.tasks.send_chahub_general_stats'},
'chahub_retries': {'schedule': datetime.timedelta(0, 600),
'task': 'apps.web.tasks.do_chahub_retries'},
'phase_migrations': {'schedule': datetime.timedelta(0, 300),
'task': 'apps.web.tasks.do_phase_migrations'},
'retry_mailing_list': {'schedule': datetime.timedelta(0, 3600),
'task': 'apps.newsletter.tasks.retry_mailing_list'}} |
CELERYD_GROUP | 'workeruser' |
CELERYD_MAX_TASKS_PER_CHILD | 100 |
CELERYD_PREFETCH_MULTIPLIER | 1 |
CELERYD_TASK_SOFT_TIME_LIMIT | 180 |
CELERYD_USER | 'workeruser' |
CELERY_ACCEPT_CONTENT | ['json'] |
CELERY_ACKS_LATE | True |
CELERY_RESULT_BACKEND | 'cache+memcached://memcached:11211/' |
CELERY_RESULT_SERIALIZER | 'json' |
CELERY_TASK_SERIALIZER | 'json' |
CELERY_TIMEZONE | 'UTC' |
CHAHUB_API_KEY | u'********************' |
CHAHUB_API_URL | u'********************' |
CHAHUB_PRODUCER_ID | None |
CODALAB_SITE_DOMAIN | 'midrc-medici.southcentralus.cloudapp.azure.com' |
CODALAB_SITE_NAME | 'CodaLab' |
CODALAB_VERSION | '1.5' |
COMMENTS_ALLOW_PROFANITIES | False |
COMPILE_LESS | True |
COMPRESS_CACHE_BACKEND | 'default' |
COMPRESS_CACHE_KEY_FUNCTION | u'********************' |
COMPRESS_CLOSURE_COMPILER_ARGUMENTS | '' |
COMPRESS_CLOSURE_COMPILER_BINARY | 'java -jar compiler.jar' |
COMPRESS_CSSTIDY_ARGUMENTS | '--template=highest' |
COMPRESS_CSSTIDY_BINARY | 'csstidy' |
COMPRESS_CSS_COMPRESSOR | 'compressor.css.CssCompressor' |
COMPRESS_CSS_FILTERS | ['compressor.filters.css_default.CssAbsoluteFilter'] |
COMPRESS_CSS_HASHING_METHOD | 'mtime' |
COMPRESS_DATA_URI_MAX_SIZE | 1024 |
COMPRESS_DEBUG_TOGGLE | 'None' |
COMPRESS_ENABLED | False |
COMPRESS_JS_COMPRESSOR | 'compressor.js.JsCompressor' |
COMPRESS_JS_FILTERS | ['compressor.filters.jsmin.JSMinFilter'] |
COMPRESS_MINT_DELAY | 30 |
COMPRESS_MTIME_DELAY | 10 |
COMPRESS_OFFLINE | False |
COMPRESS_OFFLINE_CONTEXT | {'STATIC_URL': '/static/'} |
COMPRESS_OFFLINE_MANIFEST | 'manifest.json' |
COMPRESS_OFFLINE_TIMEOUT | 31536000 |
COMPRESS_OUTPUT_DIR | 'CACHE' |
COMPRESS_PARSER | 'compressor.parser.AutoSelectParser' |
COMPRESS_PRECOMPILERS | (('text/less', 'lessc {infile} {outfile}'),
('text/typescript', 'tsc {infile} --out {outfile}')) |
COMPRESS_REBUILD_TIMEOUT | 2592000 |
COMPRESS_ROOT | '/app/codalab/static' |
COMPRESS_STORAGE | 'compressor.storage.CompressorFileStorage' |
COMPRESS_TEMPLATE_FILTER_CONTEXT | {'STATIC_URL': '/static/'} |
COMPRESS_URL | '/static/' |
COMPRESS_VERBOSE | False |
COMPRESS_YUI_BINARY | 'java -jar yuicompressor.jar' |
COMPRESS_YUI_CSS_ARGUMENTS | '' |
COMPRESS_YUI_JS_ARGUMENTS | '' |
CONFIGURATION | 'codalab.settings.Dev' |
CONFIG_GEN_GENERATED_DIR | '/app/codalab/config/generated' |
CONFIG_GEN_TEMPLATES_DIR | '/app/codalab/config/templates' |
CSRF_COOKIE_DOMAIN | None |
CSRF_COOKIE_HTTPONLY | False |
CSRF_COOKIE_NAME | 'csrftoken' |
CSRF_COOKIE_PATH | '/' |
CSRF_COOKIE_SECURE | True |
CSRF_FAILURE_VIEW | 'django.views.csrf.csrf_failure' |
CUSTOM_HEADER_LOGO | u'https://midrccodalabcu.blob.core.windows.net/public/main_logo/MIDRC_Logo-_Horizontal_Version_with_a_lighter_gray_1.png' |
DATABASES | {'default': {'ATOMIC_REQUESTS': False,
'AUTOCOMMIT': True,
'CONN_MAX_AGE': 0,
'ENGINE': 'django.db.backends.postgresql_psycopg2',
'HOST': 'postgres',
'NAME': 'codalab_website',
'OPTIONS': {},
'PASSWORD': u'********************',
'PORT': '5432',
'TEST_CHARSET': None,
'TEST_COLLATION': None,
'TEST_MIRROR': None,
'TEST_NAME': None,
'TIME_ZONE': 'UTC',
'USER': 'midrc'}} |
DATABASE_ROUTERS | [] |
DATETIME_FORMAT | 'N j, Y, P' |
DATETIME_INPUT_FORMATS | ('%Y-%m-%d %H:%M:%S',
'%Y-%m-%d %H:%M:%S.%f',
'%Y-%m-%d %H:%M',
'%Y-%m-%d',
'%m/%d/%Y %H:%M:%S',
'%m/%d/%Y %H:%M:%S.%f',
'%m/%d/%Y %H:%M',
'%m/%d/%Y',
'%m/%d/%y %H:%M:%S',
'%m/%d/%y %H:%M:%S.%f',
'%m/%d/%y %H:%M',
'%m/%d/%y') |
DATE_FORMAT | 'N j, Y' |
DATE_INPUT_FORMATS | ('%Y-%m-%d',
'%m/%d/%Y',
'%m/%d/%y',
'%b %d %Y',
'%b %d, %Y',
'%d %b %Y',
'%d %b, %Y',
'%B %d %Y',
'%B %d, %Y',
'%d %B %Y',
'%d %B, %Y') |
DEBUG | 'True' |
DEBUG_PROPAGATE_EXCEPTIONS | False |
DEBUG_TOOLBAR_CONFIG | {'ENABLE_STACKTRACES': True,
'SHOW_TEMPLATE_CONTEXT': True,
'SHOW_TOOLBAR_CALLBACK': <function <lambda> at 0x7f37be09aad0>} |
DECIMAL_SEPARATOR | '.' |
DEFAULT_CHARSET | 'utf-8' |
DEFAULT_CONTENT_TYPE | 'text/html' |
DEFAULT_EXCEPTION_REPORTER_FILTER | 'django.views.debug.SafeExceptionReporterFilter' |
DEFAULT_FILE_STORAGE | 'codalab.azure_storage.AzureStorage' |
DEFAULT_FROM_EMAIL | 'MedICI Challenges <benjamin.bearce@cuanschutz.edu>' |
DEFAULT_INDEX_TABLESPACE | '' |
DEFAULT_TABLESPACE | '' |
DISALLOWED_USER_AGENTS | () |
DJANGO_ROOT | '/app/codalab/codalab' |
DOCKER_DEFAULT_WORKER_IMAGE | 'codalab/codalab-legacy:latest' |
DOCKER_MAX_SIZE_GB | 10.0 |
DOMAIN_NAME | 'localhost' |
EMAIL_BACKEND | 'django.core.mail.backends.smtp.EmailBackend' |
EMAIL_HOST | 'smtp.sendgrid.net' |
EMAIL_HOST_PASSWORD | u'********************' |
EMAIL_HOST_USER | 'apikey' |
EMAIL_PORT | '587' |
EMAIL_SUBJECT_PREFIX | '[Django] ' |
EMAIL_USE_TLS | 'True' |
EXTRA_MIDDLEWARE_CLASSES | ('debug_toolbar.middleware.DebugToolbarMiddleware',) |
FILE_CHARSET | 'utf-8' |
FILE_UPLOAD_HANDLERS | ('django.core.files.uploadhandler.MemoryFileUploadHandler',
'django.core.files.uploadhandler.TemporaryFileUploadHandler') |
FILE_UPLOAD_MAX_MEMORY_SIZE | 2621440 |
FILE_UPLOAD_PERMISSIONS | None |
FILE_UPLOAD_TEMP_DIR | None |
FIRST_DAY_OF_WEEK | 0 |
FIXTURE_DIRS | () |
FLOWER_PORT | '5555' |
FORCE_SCRIPT_NAME | None |
FORMAT_MODULE_PATH | None |
GRAPH_MODELS | {'all_applications': True, 'group_models': True} |
HAYSTACK_CONNECTIONS | {'default': {'ENGINE': 'haystack.backends.simple_backend.SimpleEngine'}} |
IGNORABLE_404_URLS | () |
INSTALLED_APPS | ('django.contrib.auth',
'django.contrib.contenttypes',
'django.contrib.sessions',
'django.contrib.sites',
'django.contrib.messages',
'django.contrib.staticfiles',
'django.contrib.admin',
'django.contrib.humanize',
'analytical',
'rest_framework',
'mptt',
'django_config_gen',
'compressor',
'django_js_reverse',
'guardian',
'captcha',
'bootstrapform',
'storages',
's3direct',
'south',
'django_nose',
'apps.authenz',
'apps.jobs',
'apps.api',
'apps.web',
'apps.health',
'apps.analytics',
'apps.forums',
'apps.coopetitions',
'apps.common',
'apps.chahub',
'apps.queues',
'apps.teams',
'apps.customizer',
'apps.newsletter',
'allauth',
'allauth.account',
'allauth.socialaccount',
'tinymce',
'oauth2_provider',
'haystack',
'django_extensions',
'django_switchuser',
'pin_passcode',
'debug_toolbar') |
INTERNAL_IPS | [u'::1', u'127.0.0.1'] |
IS_DEV | 'True' |
LANGUAGES | (('af', 'Afrikaans'),
('ar', 'Arabic'),
('az', 'Azerbaijani'),
('bg', 'Bulgarian'),
('be', 'Belarusian'),
('bn', 'Bengali'),
('br', 'Breton'),
('bs', 'Bosnian'),
('ca', 'Catalan'),
('cs', 'Czech'),
('cy', 'Welsh'),
('da', 'Danish'),
('de', 'German'),
('el', 'Greek'),
('en', 'English'),
('en-gb', 'British English'),
('eo', 'Esperanto'),
('es', 'Spanish'),
('es-ar', 'Argentinian Spanish'),
('es-mx', 'Mexican Spanish'),
('es-ni', 'Nicaraguan Spanish'),
('es-ve', 'Venezuelan Spanish'),
('et', 'Estonian'),
('eu', 'Basque'),
('fa', 'Persian'),
('fi', 'Finnish'),
('fr', 'French'),
('fy-nl', 'Frisian'),
('ga', 'Irish'),
('gl', 'Galician'),
('he', 'Hebrew'),
('hi', 'Hindi'),
('hr', 'Croatian'),
('hu', 'Hungarian'),
('ia', 'Interlingua'),
('id', 'Indonesian'),
('is', 'Icelandic'),
('it', 'Italian'),
('ja', 'Japanese'),
('ka', 'Georgian'),
('kk', 'Kazakh'),
('km', 'Khmer'),
('kn', 'Kannada'),
('ko', 'Korean'),
('lb', 'Luxembourgish'),
('lt', 'Lithuanian'),
('lv', 'Latvian'),
('mk', 'Macedonian'),
('ml', 'Malayalam'),
('mn', 'Mongolian'),
('my', 'Burmese'),
('nb', 'Norwegian Bokmal'),
('ne', 'Nepali'),
('nl', 'Dutch'),
('nn', 'Norwegian Nynorsk'),
('os', 'Ossetic'),
('pa', 'Punjabi'),
('pl', 'Polish'),
('pt', 'Portuguese'),
('pt-br', 'Brazilian Portuguese'),
('ro', 'Romanian'),
('ru', 'Russian'),
('sk', 'Slovak'),
('sl', 'Slovenian'),
('sq', 'Albanian'),
('sr', 'Serbian'),
('sr-latn', 'Serbian Latin'),
('sv', 'Swedish'),
('sw', 'Swahili'),
('ta', 'Tamil'),
('te', 'Telugu'),
('th', 'Thai'),
('tr', 'Turkish'),
('tt', 'Tatar'),
('udm', 'Udmurt'),
('uk', 'Ukrainian'),
('ur', 'Urdu'),
('vi', 'Vietnamese'),
('zh-cn', 'Simplified Chinese'),
('zh-tw', 'Traditional Chinese')) |
LANGUAGES_BIDI | ('he', 'ar', 'fa', 'ur') |
LANGUAGE_CODE | 'en-us' |
LANGUAGE_COOKIE_NAME | 'django_language' |
LOCALE_PATHS | () |
LOCAL_ACE_EDITOR | False |
LOCAL_MATHJAX | False |
LOGGING | {'disable_existing_loggers': False,
'filters': {'require_debug_false': {'()': 'django.utils.log.RequireDebugFalse'}},
'formatters': {'simple': {'format': '%(asctime)s %(levelname)s %(message)s'}},
'handlers': {'console': {'class': 'logging.StreamHandler',
'formatter': 'simple',
'level': 'DEBUG',
'stream': <open file '<stdout>', mode 'w' at 0x7f37c03671e0>},
'mail_admins': {'class': 'django.utils.log.AdminEmailHandler',
'filters': ['require_debug_false'],
'level': 'ERROR'}},
'loggers': {'apps': {'handlers': ['console'], 'level': 'INFO'},
'codalab': {'handlers': ['console'], 'level': 'INFO'},
'codalabtools': {'handlers': ['console'], 'level': 'INFO'},
'django': {'handlers': ['console'],
'level': 'INFO',
'propagate': True},
'django.request': {'handlers': ['mail_admins'],
'level': 'ERROR',
'propagate': True}},
'version': 1} |
LOGGING_CONFIG | 'django.utils.log.dictConfig' |
LOGIN_REDIRECT_URL | '/' |
LOGIN_URL | '/accounts/login/' |
LOGOUT_URL | '/accounts/logout/' |
MAILCHIMP_API_KEY | u'********************' |
MAILCHIMP_API_URL | u'********************' |
MAILCHIMP_DATA_CENTER | None |
MAILCHIMP_EMAIL_LIST_ID_ALL | None |
MAILCHIMP_EMAIL_LIST_ID_NEWSLETTER | None |
MAILCHIMP_MEMBERS_ENDPOINT_ALL | None |
MAILCHIMP_MEMBERS_ENDPOINT_NEWSLETTER | None |
MAINTENANCE_MODE | 0 |
MANAGERS | None |
MEDIA_ROOT | '/app/codalab/media' |
MEDIA_URL | '/media/' |
MEMCACHED_PORT | '11211' |
MESSAGE_STORAGE | 'django.contrib.messages.storage.fallback.FallbackStorage' |
MIDDLEWARE_CLASSES | ('django_switchuser.middleware.SuStateMiddleware',
'apps.web.middleware.SingleCompetitionMiddleware',
'django.middleware.common.CommonMiddleware',
'django.contrib.sessions.middleware.SessionMiddleware',
'django.middleware.csrf.CsrfViewMiddleware',
'django.contrib.auth.middleware.AuthenticationMiddleware',
'django.contrib.messages.middleware.MessageMiddleware',
'debug_toolbar.middleware.DebugToolbarMiddleware') |
MONTH_DAY_FORMAT | 'F j' |
NUMBER_GROUPING | 0 |
OAUTH2_PROVIDER | {'ACCESS_TOKEN_EXPIRE_SECONDS': u'********************',
'OAUTH2_VALIDATOR_CLASS': 'apps.authenz.oauth.Validator'} |
OPTIONAL_APPS | ('debug_toolbar',) |
PASSWORD_HASHERS | u'********************' |
PASSWORD_RESET_TIMEOUT_DAYS | u'********************' |
PORT | '8000' |
PREPEND_WWW | False |
PROFANITIES_LIST | u'********************' |
PROJECT_APP_DIR | '/app/codalab/codalab' |
PROJECT_DIR | '/app/codalab' |
PYTEST_FORCE_CHAHUB | False |
RABBITMQ_DEFAULT_PASS | u'********************' |
RABBITMQ_DEFAULT_USER | 'guest' |
RABBITMQ_HOST | 'rabbit' |
RABBITMQ_MANAGEMENT_PORT | '15672' |
RABBITMQ_PORT | '5672' |
REST_FRAMEWORK | {'DEFAULT_RENDERER_CLASSES': ('rest_framework.renderers.JSONRenderer',
'rest_framework.renderers.BrowsableAPIRenderer')} |
ROOT_DIR | '/app' |
ROOT_URLCONF | 'codalab.urls' |
S3DIRECT_DESTINATIONS | {'competitions': {'allowed': ['application/zip',
'application/octet-stream',
'application/x-zip-compressed'],
'auth': <function <lambda> at 0x7f37be09a850>,
'bucket': None,
'key': <function <lambda> at 0x7f37be09a7d0>},
'submissions': {'allowed': ['application/zip',
'application/octet-stream',
'application/x-zip-compressed'],
'auth': <function <lambda> at 0x7f37be09a950>,
'bucket': None,
'key': <function <lambda> at 0x7f37be09a8d0>}} |
S3DIRECT_REGION | 'us-west-2' |
SECRET_KEY | u'********************' |
SECURE_PROXY_SSL_HEADER | ('HTTP_X_FORWARDED_PROTO', 'https') |
SEND_BROKEN_LINK_EMAILS | False |
SERVER_EMAIL | 'benjamin.bearce@cuanschutz.edu' |
SERVER_NAME | 'midrc-medici.southcentralus.cloudapp.azure.com' |
SESSION_CACHE_ALIAS | 'default' |
SESSION_COOKIE_AGE | 1209600 |
SESSION_COOKIE_DOMAIN | None |
SESSION_COOKIE_HTTPONLY | True |
SESSION_COOKIE_NAME | 'sessionid' |
SESSION_COOKIE_PATH | '/' |
SESSION_COOKIE_SECURE | True |
SESSION_ENGINE | 'django.contrib.sessions.backends.cached_db' |
SESSION_EXPIRE_AT_BROWSER_CLOSE | False |
SESSION_FILE_PATH | None |
SESSION_SAVE_EVERY_REQUEST | False |
SESSION_SERIALIZER | 'django.contrib.sessions.serializers.JSONSerializer' |
SETTINGS_DIR | '/app/codalab/codalab/settings' |
SETTINGS_MODULE | 'codalab.settings' |
SHORT_DATETIME_FORMAT | 'm/d/Y P' |
SHORT_DATE_FORMAT | 'm/d/Y' |
SIGNING_BACKEND | 'django.core.signing.TimestampSigner' |
SINGLE_COMPETITION_VIEW_PK | 9 |
SITE_ID | 1 |
SITE_ROOT | '/app/codalab' |
SOCIAL_AUTH_CHAHUB_BASE_URL | None |
SOURCE_GIT_URL | 'https://github.com/codalab/codalab.git' |
SOUTH_MIGRATION_MODULES | {'captcha': 'captcha.south_migrations'} |
SSL_CERTIFICATE | '/app/certs/fullchain.pem' |
SSL_CERTIFICATE_KEY | u'********************' |
SSL_PORT | '443' |
STARTUP_ENV | {'CONFIG_HTTP_PORT': '8000',
'CONFIG_SERVER_NAME': 'midrc-medici.southcentralus.cloudapp.azure.com',
'DJANGO_CONFIGURATION': 'Dev',
'DJANGO_SETTINGS_MODULE': 'codalab.settings',
'NEW_RELIC_CONFIG_FILE': '/app/codalab/newrelic.ini'} |
STATICFILES_DIRS | () |
STATICFILES_FINDERS | ('django.contrib.staticfiles.finders.AppDirectoriesFinder',
'django.contrib.staticfiles.finders.FileSystemFinder',
'compressor.finders.CompressorFinder') |
STATICFILES_STORAGE | 'django.contrib.staticfiles.storage.StaticFilesStorage' |
STATIC_ROOT | '/app/codalab/static' |
STATIC_URL | '/static/' |
TEMPLATE_CONTEXT_PROCESSORS | ('django.contrib.auth.context_processors.auth',
'django.core.context_processors.debug',
'django.core.context_processors.i18n',
'django.core.context_processors.media',
'django.core.context_processors.static',
'django.core.context_processors.tz',
'django.contrib.messages.context_processors.messages',
'django_switchuser.context_processors.su_state',
'allauth.account.context_processors.account',
'allauth.socialaccount.context_processors.socialaccount',
'codalab.context_processors.app_version_proc',
'django.core.context_processors.request',
'codalab.context_processors.common_settings') |
TEMPLATE_DEBUG | 'True' |
TEMPLATE_DIRS | ('/app/codalab/templates',) |
TEMPLATE_LOADERS | ('django.template.loaders.filesystem.Loader',
'django.template.loaders.app_directories.Loader') |
TEMPLATE_STRING_IF_INVALID | '' |
TEST_DATA_PATH | '/app/codalab/test_data' |
TEST_RUNNER | 'django_nose.NoseTestSuiteRunner' |
THOUSAND_SEPARATOR | ',' |
TIME_FORMAT | 'P' |
TIME_INPUT_FORMATS | ('%H:%M:%S', '%H:%M:%S.%f', '%H:%M') |
TIME_ZONE | 'UTC' |
TRANSACTIONS_MANAGED | False |
USE_AWS | False |
USE_ETAGS | False |
USE_I18N | True |
USE_L10N | True |
USE_THOUSAND_SEPARATOR | False |
USE_TZ | True |
USE_X_FORWARDED_HOST | False |
VIRTUAL_ENV | None |
WSGI_APPLICATION | 'codalab.wsgi.application' |
X_FRAME_OPTIONS | 'SAMEORIGIN' |
YEAR_MONTH_FORMAT | 'F Y' |
Key | Value |
---|---|
Accept | text/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8 |
Accept-Encoding | br,gzip |
Accept-Language | en-US,en;q=0.5 |
Connection | close |
Host | midrc-medici.southcentralus.cloudapp.azure.com |
User-Agent | CCBot/2.0 (https://commoncrawl.org/faq/) |
X-Forwarded-For | 44.192.79.149 |
X-Forwarded-Proto | https |
X-Real-Ip | 44.192.79.149 |
Key | Value |
---|---|
Content-Type | text/html; charset=utf-8 |
Since the WSGI environ inherits the environment of the server, only a significant subset is shown below.
Key | Value |
---|---|
PATH_INFO | / |
QUERY_STRING | |
REMOTE_ADDR | 172.18.0.9 |
REQUEST_METHOD | GET |
SCRIPT_NAME | |
SERVER_NAME | 172.18.0.6 |
SERVER_PORT | 8000 |
SERVER_PROTOCOL | HTTP/1.0 |
SERVER_SOFTWARE | gunicorn/19.7.0 |
View function | Arguments | Keyword arguments | URL name |
---|---|---|---|
apps.web.views.HomePageView |
() |
{} |
home |
Query | Timeline | Time (ms) | Action | ||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
+ |
SELECT ••• "web_competition"."id", "web_competition"."chahub_timestamp", "web_competition"."chahub_data_hash", "web_competition"."chahub_needs_retry", "web_competition"."queue_id", "web_competition"."title", "web_competition"."description", "web_competition"."url_redirect", "web_competition"."image", "web_competition"."image_url_base", "web_competition"."has_registration", "web_competition"."start_date", "web_competition"."end_date", "web_competition"."creator_id", "web_competition"."modified_by_id", "web_competition"."last_modified", "web_competition"."published", "web_competition"."last_phase_migration", "web_competition"."is_migrating", "web_competition"."force_submission_to_leaderboard", "web_competition"."disallow_leaderboard_modifying", "web_competition"."secret_key", "web_competition"."enable_docker_submission", "web_competition"."enable_medical_image_viewer", "web_competition"."enable_detailed_results", "web_competition"."original_yaml_file", "web_competition"."show_datasets_from_yaml", "web_competition"."reward", "web_competition"."is_migrating_delayed", "web_competition"."allow_teams", "web_competition"."enable_per_submission_metadata", "web_competition"."allow_public_submissions", "web_competition"."enable_forum", "web_competition"."anonymous_leaderboard", "web_competition"."enable_teams", "web_competition"."require_team_approval", "web_competition"."hide_top_three", "web_competition"."hide_chart", "web_competition"."allow_organizer_teams", "web_competition"."competition_docker_image", "web_competition"."deleted" FROM "web_competition" WHERE ("web_competition"."deleted" = false AND "web_competition"."id" = 9 )
|
3.96348333744% |
1.80 | ||||||||||||||||
Connection: default /usr/local/bin/gunicorn in <module>(8) sys.exit(run()) /usr/local/lib/python2.7/site-packages/gunicorn/app/wsgiapp.py in run(74) WSGIApplication("%(prog)s [OPTIONS] [APP_MODULE]").run() /usr/local/lib/python2.7/site-packages/gunicorn/app/base.py in run(203) super(Application, self).run() /usr/local/lib/python2.7/site-packages/gunicorn/app/base.py in run(72) Arbiter(self).run() /usr/local/lib/python2.7/site-packages/gunicorn/arbiter.py in run(202) self.manage_workers() /usr/local/lib/python2.7/site-packages/gunicorn/arbiter.py in manage_workers(544) self.spawn_workers() /usr/local/lib/python2.7/site-packages/gunicorn/arbiter.py in spawn_workers(611) self.spawn_worker() /usr/local/lib/python2.7/site-packages/gunicorn/arbiter.py in spawn_worker(578) worker.init_process() /usr/local/lib/python2.7/site-packages/gunicorn/workers/base.py in init_process(131) self.run() /usr/local/lib/python2.7/site-packages/gunicorn/workers/sync.py in run(124) self.run_for_one(timeout) /usr/local/lib/python2.7/site-packages/gunicorn/workers/sync.py in run_for_one(68) self.accept(listener) /usr/local/lib/python2.7/site-packages/gunicorn/workers/sync.py in accept(30) self.handle(listener, client, addr) /usr/local/lib/python2.7/site-packages/gunicorn/workers/sync.py in handle(135) self.handle_request(listener, req, client, addr) /usr/local/lib/python2.7/site-packages/gunicorn/workers/sync.py in handle_request(176) respiter = self.wsgi(environ, resp.start_response) /app/codalab/apps/web/views.py in get(114) competition = models.Competition.objects.get(pk=settings.SINGLE_COMPETITION_VIEW_PK) |
|||||||||||||||||||
+ |
SELECT ••• "web_competition"."id", "web_competition"."chahub_timestamp", "web_competition"."chahub_data_hash", "web_competition"."chahub_needs_retry", "web_competition"."queue_id", "web_competition"."title", "web_competition"."description", "web_competition"."url_redirect", "web_competition"."image", "web_competition"."image_url_base", "web_competition"."has_registration", "web_competition"."start_date", "web_competition"."end_date", "web_competition"."creator_id", "web_competition"."modified_by_id", "web_competition"."last_modified", "web_competition"."published", "web_competition"."last_phase_migration", "web_competition"."is_migrating", "web_competition"."force_submission_to_leaderboard", "web_competition"."disallow_leaderboard_modifying", "web_competition"."secret_key", "web_competition"."enable_docker_submission", "web_competition"."enable_medical_image_viewer", "web_competition"."enable_detailed_results", "web_competition"."original_yaml_file", "web_competition"."show_datasets_from_yaml", "web_competition"."reward", "web_competition"."is_migrating_delayed", "web_competition"."allow_teams", "web_competition"."enable_per_submission_metadata", "web_competition"."allow_public_submissions", "web_competition"."enable_forum", "web_competition"."anonymous_leaderboard", "web_competition"."enable_teams", "web_competition"."require_team_approval", "web_competition"."hide_top_three", "web_competition"."hide_chart", "web_competition"."allow_organizer_teams", "web_competition"."competition_docker_image", "web_competition"."deleted" FROM "web_competition" WHERE ("web_competition"."deleted" = false AND "web_competition"."id" = 9 )
|
1.1167768071% |
0.51 | ||||||||||||||||
Connection: default /usr/local/bin/gunicorn in <module>(8) sys.exit(run()) /usr/local/lib/python2.7/site-packages/gunicorn/app/wsgiapp.py in run(74) WSGIApplication("%(prog)s [OPTIONS] [APP_MODULE]").run() /usr/local/lib/python2.7/site-packages/gunicorn/app/base.py in run(203) super(Application, self).run() /usr/local/lib/python2.7/site-packages/gunicorn/app/base.py in run(72) Arbiter(self).run() /usr/local/lib/python2.7/site-packages/gunicorn/arbiter.py in run(202) self.manage_workers() /usr/local/lib/python2.7/site-packages/gunicorn/arbiter.py in manage_workers(544) self.spawn_workers() /usr/local/lib/python2.7/site-packages/gunicorn/arbiter.py in spawn_workers(611) self.spawn_worker() /usr/local/lib/python2.7/site-packages/gunicorn/arbiter.py in spawn_worker(578) worker.init_process() /usr/local/lib/python2.7/site-packages/gunicorn/workers/base.py in init_process(131) self.run() /usr/local/lib/python2.7/site-packages/gunicorn/workers/sync.py in run(124) self.run_for_one(timeout) /usr/local/lib/python2.7/site-packages/gunicorn/workers/sync.py in run_for_one(68) self.accept(listener) /usr/local/lib/python2.7/site-packages/gunicorn/workers/sync.py in accept(30) self.handle(listener, client, addr) /usr/local/lib/python2.7/site-packages/gunicorn/workers/sync.py in handle(135) self.handle_request(listener, req, client, addr) /usr/local/lib/python2.7/site-packages/gunicorn/workers/sync.py in handle_request(176) respiter = self.wsgi(environ, resp.start_response) /app/codalab/apps/web/views.py in get(127) return CompetitionDetailView.as_view()(*args, **kwargs) /app/codalab/apps/web/views.py in get(516) competition = self.get_object() |
|||||||||||||||||||
+ |
SELECT ••• "authenz_cluser"."id", "authenz_cluser"."password", "authenz_cluser"."last_login", "authenz_cluser"."is_superuser", "authenz_cluser"."username", "authenz_cluser"."first_name", "authenz_cluser"."last_name", "authenz_cluser"."email", "authenz_cluser"."is_staff", "authenz_cluser"."is_active", "authenz_cluser"."date_joined", "authenz_cluser"."chahub_timestamp", "authenz_cluser"."chahub_data_hash", "authenz_cluser"."chahub_needs_retry", "authenz_cluser"."participation_status_updates", "authenz_cluser"."organizer_status_updates", "authenz_cluser"."organizer_direct_message_updates", "authenz_cluser"."email_on_submission_finished_successfully", "authenz_cluser"."allow_forum_notifications", "authenz_cluser"."allow_admin_status_updates", "authenz_cluser"."newsletter_opt_in", "authenz_cluser"."organization_or_affiliation", "authenz_cluser"."team_name", "authenz_cluser"."team_members", "authenz_cluser"."method_name", "authenz_cluser"."method_description", "authenz_cluser"."project_url", "authenz_cluser"."publication_url", "authenz_cluser"."bibtex", "authenz_cluser"."contact_email", "authenz_cluser"."rabbitmq_queue_limit", "authenz_cluser"."rabbitmq_username", "authenz_cluser"."rabbitmq_password" FROM "authenz_cluser" WHERE "authenz_cluser"."id" = 1
|
2.26447329116% |
1.03 | ||||||||||||||||
Connection: default /usr/local/bin/gunicorn in <module>(8) sys.exit(run()) /usr/local/lib/python2.7/site-packages/gunicorn/app/wsgiapp.py in run(74) WSGIApplication("%(prog)s [OPTIONS] [APP_MODULE]").run() /usr/local/lib/python2.7/site-packages/gunicorn/app/base.py in run(203) super(Application, self).run() /usr/local/lib/python2.7/site-packages/gunicorn/app/base.py in run(72) Arbiter(self).run() /usr/local/lib/python2.7/site-packages/gunicorn/arbiter.py in run(202) self.manage_workers() /usr/local/lib/python2.7/site-packages/gunicorn/arbiter.py in manage_workers(544) self.spawn_workers() /usr/local/lib/python2.7/site-packages/gunicorn/arbiter.py in spawn_workers(611) self.spawn_worker() /usr/local/lib/python2.7/site-packages/gunicorn/arbiter.py in spawn_worker(578) worker.init_process() /usr/local/lib/python2.7/site-packages/gunicorn/workers/base.py in init_process(131) self.run() /usr/local/lib/python2.7/site-packages/gunicorn/workers/sync.py in run(124) self.run_for_one(timeout) /usr/local/lib/python2.7/site-packages/gunicorn/workers/sync.py in run_for_one(68) self.accept(listener) /usr/local/lib/python2.7/site-packages/gunicorn/workers/sync.py in accept(30) self.handle(listener, client, addr) /usr/local/lib/python2.7/site-packages/gunicorn/workers/sync.py in handle(135) self.handle_request(listener, req, client, addr) /usr/local/lib/python2.7/site-packages/gunicorn/workers/sync.py in handle_request(176) respiter = self.wsgi(environ, resp.start_response) /app/codalab/apps/web/views.py in get(127) return CompetitionDetailView.as_view()(*args, **kwargs) /app/codalab/apps/web/views.py in get(518) if competition.creator != request.user and request.user not in competition.admins.all(): |
|||||||||||||||||||
+ |
SELECT ••• "authenz_cluser"."id", "authenz_cluser"."password", "authenz_cluser"."last_login", "authenz_cluser"."is_superuser", "authenz_cluser"."username", "authenz_cluser"."first_name", "authenz_cluser"."last_name", "authenz_cluser"."email", "authenz_cluser"."is_staff", "authenz_cluser"."is_active", "authenz_cluser"."date_joined", "authenz_cluser"."chahub_timestamp", "authenz_cluser"."chahub_data_hash", "authenz_cluser"."chahub_needs_retry", "authenz_cluser"."participation_status_updates", "authenz_cluser"."organizer_status_updates", "authenz_cluser"."organizer_direct_message_updates", "authenz_cluser"."email_on_submission_finished_successfully", "authenz_cluser"."allow_forum_notifications", "authenz_cluser"."allow_admin_status_updates", "authenz_cluser"."newsletter_opt_in", "authenz_cluser"."organization_or_affiliation", "authenz_cluser"."team_name", "authenz_cluser"."team_members", "authenz_cluser"."method_name", "authenz_cluser"."method_description", "authenz_cluser"."project_url", "authenz_cluser"."publication_url", "authenz_cluser"."bibtex", "authenz_cluser"."contact_email", "authenz_cluser"."rabbitmq_queue_limit", "authenz_cluser"."rabbitmq_username", "authenz_cluser"."rabbitmq_password" FROM "authenz_cluser" INNER JOIN "web_competition_admins" ON ( "authenz_cluser"."id" = "web_competition_admins"."cluser_id" ) WHERE "web_competition_admins"."competition_id" = 9
|
1.97833526363% |
0.90 | ||||||||||||||||
Connection: default /usr/local/bin/gunicorn in <module>(8) sys.exit(run()) /usr/local/lib/python2.7/site-packages/gunicorn/app/wsgiapp.py in run(74) WSGIApplication("%(prog)s [OPTIONS] [APP_MODULE]").run() /usr/local/lib/python2.7/site-packages/gunicorn/app/base.py in run(203) super(Application, self).run() /usr/local/lib/python2.7/site-packages/gunicorn/app/base.py in run(72) Arbiter(self).run() /usr/local/lib/python2.7/site-packages/gunicorn/arbiter.py in run(202) self.manage_workers() /usr/local/lib/python2.7/site-packages/gunicorn/arbiter.py in manage_workers(544) self.spawn_workers() /usr/local/lib/python2.7/site-packages/gunicorn/arbiter.py in spawn_workers(611) self.spawn_worker() /usr/local/lib/python2.7/site-packages/gunicorn/arbiter.py in spawn_worker(578) worker.init_process() /usr/local/lib/python2.7/site-packages/gunicorn/workers/base.py in init_process(131) self.run() /usr/local/lib/python2.7/site-packages/gunicorn/workers/sync.py in run(124) self.run_for_one(timeout) /usr/local/lib/python2.7/site-packages/gunicorn/workers/sync.py in run_for_one(68) self.accept(listener) /usr/local/lib/python2.7/site-packages/gunicorn/workers/sync.py in accept(30) self.handle(listener, client, addr) /usr/local/lib/python2.7/site-packages/gunicorn/workers/sync.py in handle(135) self.handle_request(listener, req, client, addr) /usr/local/lib/python2.7/site-packages/gunicorn/workers/sync.py in handle_request(176) respiter = self.wsgi(environ, resp.start_response) /app/codalab/apps/web/views.py in get(127) return CompetitionDetailView.as_view()(*args, **kwargs) /app/codalab/apps/web/views.py in get(518) if competition.creator != request.user and request.user not in competition.admins.all(): |
|||||||||||||||||||
+ |
SELECT ••• (1) AS "a" FROM "web_competitionparticipant" WHERE ("web_competitionparticipant"."deleted" = false AND "web_competitionparticipant"."competition_id" = 9 AND "web_competitionparticipant"."user_id" = -1 ) LIMIT 1
|
1.47942793357% |
0.67 | ||||||||||||||||
Connection: default /usr/local/bin/gunicorn in <module>(8) sys.exit(run()) /usr/local/lib/python2.7/site-packages/gunicorn/app/wsgiapp.py in run(74) WSGIApplication("%(prog)s [OPTIONS] [APP_MODULE]").run() /usr/local/lib/python2.7/site-packages/gunicorn/app/base.py in run(203) super(Application, self).run() /usr/local/lib/python2.7/site-packages/gunicorn/app/base.py in run(72) Arbiter(self).run() /usr/local/lib/python2.7/site-packages/gunicorn/arbiter.py in run(202) self.manage_workers() /usr/local/lib/python2.7/site-packages/gunicorn/arbiter.py in manage_workers(544) self.spawn_workers() /usr/local/lib/python2.7/site-packages/gunicorn/arbiter.py in spawn_workers(611) self.spawn_worker() /usr/local/lib/python2.7/site-packages/gunicorn/arbiter.py in spawn_worker(578) worker.init_process() /usr/local/lib/python2.7/site-packages/gunicorn/workers/base.py in init_process(131) self.run() /usr/local/lib/python2.7/site-packages/gunicorn/workers/sync.py in run(124) self.run_for_one(timeout) /usr/local/lib/python2.7/site-packages/gunicorn/workers/sync.py in run_for_one(68) self.accept(listener) /usr/local/lib/python2.7/site-packages/gunicorn/workers/sync.py in accept(30) self.handle(listener, client, addr) /usr/local/lib/python2.7/site-packages/gunicorn/workers/sync.py in handle(135) self.handle_request(listener, req, client, addr) /usr/local/lib/python2.7/site-packages/gunicorn/workers/sync.py in handle_request(176) respiter = self.wsgi(environ, resp.start_response) /app/codalab/apps/web/views.py in get(127) return CompetitionDetailView.as_view()(*args, **kwargs) /app/codalab/apps/web/views.py in get(521) if not competition.participants.filter(user=user_pk).exists(): |
|||||||||||||||||||
+ |
SELECT ••• "forums_forum"."id", "forums_forum"."competition_id" FROM "forums_forum" WHERE "forums_forum"."competition_id" = 9
|
1.01301246744% |
0.46 | ||||||||||||||||
Connection: default /usr/local/bin/gunicorn in <module>(8) sys.exit(run()) /usr/local/lib/python2.7/site-packages/gunicorn/app/wsgiapp.py in run(74) WSGIApplication("%(prog)s [OPTIONS] [APP_MODULE]").run() /usr/local/lib/python2.7/site-packages/gunicorn/app/base.py in run(203) super(Application, self).run() /usr/local/lib/python2.7/site-packages/gunicorn/app/base.py in run(72) Arbiter(self).run() /usr/local/lib/python2.7/site-packages/gunicorn/arbiter.py in run(202) self.manage_workers() /usr/local/lib/python2.7/site-packages/gunicorn/arbiter.py in manage_workers(544) self.spawn_workers() /usr/local/lib/python2.7/site-packages/gunicorn/arbiter.py in spawn_workers(611) self.spawn_worker() /usr/local/lib/python2.7/site-packages/gunicorn/arbiter.py in spawn_worker(578) worker.init_process() /usr/local/lib/python2.7/site-packages/gunicorn/workers/base.py in init_process(131) self.run() /usr/local/lib/python2.7/site-packages/gunicorn/workers/sync.py in run(124) self.run_for_one(timeout) /usr/local/lib/python2.7/site-packages/gunicorn/workers/sync.py in run_for_one(68) self.accept(listener) /usr/local/lib/python2.7/site-packages/gunicorn/workers/sync.py in accept(30) self.handle(listener, client, addr) /usr/local/lib/python2.7/site-packages/gunicorn/workers/sync.py in handle(135) self.handle_request(listener, req, client, addr) /usr/local/lib/python2.7/site-packages/gunicorn/workers/sync.py in handle_request(176) respiter = self.wsgi(environ, resp.start_response) /app/codalab/apps/web/views.py in get(127) return CompetitionDetailView.as_view()(*args, **kwargs) /app/codalab/apps/web/views.py in get(526) if not hasattr(competition, 'forum'): |
|||||||||||||||||||
+ |
SELECT ••• "web_competition"."id", "web_competition"."chahub_timestamp", "web_competition"."chahub_data_hash", "web_competition"."chahub_needs_retry", "web_competition"."queue_id", "web_competition"."title", "web_competition"."description", "web_competition"."url_redirect", "web_competition"."image", "web_competition"."image_url_base", "web_competition"."has_registration", "web_competition"."start_date", "web_competition"."end_date", "web_competition"."creator_id", "web_competition"."modified_by_id", "web_competition"."last_modified", "web_competition"."published", "web_competition"."last_phase_migration", "web_competition"."is_migrating", "web_competition"."force_submission_to_leaderboard", "web_competition"."disallow_leaderboard_modifying", "web_competition"."secret_key", "web_competition"."enable_docker_submission", "web_competition"."enable_medical_image_viewer", "web_competition"."enable_detailed_results", "web_competition"."original_yaml_file", "web_competition"."show_datasets_from_yaml", "web_competition"."reward", "web_competition"."is_migrating_delayed", "web_competition"."allow_teams", "web_competition"."enable_per_submission_metadata", "web_competition"."allow_public_submissions", "web_competition"."enable_forum", "web_competition"."anonymous_leaderboard", "web_competition"."enable_teams", "web_competition"."require_team_approval", "web_competition"."hide_top_three", "web_competition"."hide_chart", "web_competition"."allow_organizer_teams", "web_competition"."competition_docker_image", "web_competition"."deleted" FROM "web_competition" WHERE ("web_competition"."deleted" = false AND "web_competition"."id" = 9 )
|
1.09895868817% |
0.50 | ||||||||||||||||
Connection: default /usr/local/bin/gunicorn in <module>(8) sys.exit(run()) /usr/local/lib/python2.7/site-packages/gunicorn/app/wsgiapp.py in run(74) WSGIApplication("%(prog)s [OPTIONS] [APP_MODULE]").run() /usr/local/lib/python2.7/site-packages/gunicorn/app/base.py in run(203) super(Application, self).run() /usr/local/lib/python2.7/site-packages/gunicorn/app/base.py in run(72) Arbiter(self).run() /usr/local/lib/python2.7/site-packages/gunicorn/arbiter.py in run(202) self.manage_workers() /usr/local/lib/python2.7/site-packages/gunicorn/arbiter.py in manage_workers(544) self.spawn_workers() /usr/local/lib/python2.7/site-packages/gunicorn/arbiter.py in spawn_workers(611) self.spawn_worker() /usr/local/lib/python2.7/site-packages/gunicorn/arbiter.py in spawn_worker(578) worker.init_process() /usr/local/lib/python2.7/site-packages/gunicorn/workers/base.py in init_process(131) self.run() /usr/local/lib/python2.7/site-packages/gunicorn/workers/sync.py in run(124) self.run_for_one(timeout) /usr/local/lib/python2.7/site-packages/gunicorn/workers/sync.py in run_for_one(68) self.accept(listener) /usr/local/lib/python2.7/site-packages/gunicorn/workers/sync.py in accept(30) self.handle(listener, client, addr) /usr/local/lib/python2.7/site-packages/gunicorn/workers/sync.py in handle(135) self.handle_request(listener, req, client, addr) /usr/local/lib/python2.7/site-packages/gunicorn/workers/sync.py in handle_request(176) respiter = self.wsgi(environ, resp.start_response) /app/codalab/apps/web/views.py in get(127) return CompetitionDetailView.as_view()(*args, **kwargs) /app/codalab/apps/web/views.py in get(528) return super(CompetitionDetailView, self).get(request, *args, **kwargs) |
|||||||||||||||||||
+ |
SELECT ••• "web_contentcategory"."id", "web_contentcategory"."parent_id", "web_contentcategory"."name", "web_contentcategory"."codename", "web_contentcategory"."visibility_id", "web_contentcategory"."is_menu", "web_contentcategory"."content_limit", "web_contentcategory"."lft", "web_contentcategory"."rght", "web_contentcategory"."tree_id", "web_contentcategory"."level" FROM "web_contentcategory" ORDER BY "web_contentcategory"."tree_id" ASC, "web_contentcategory"."lft" ASC
|
1.86618592683% |
0.85 | ||||||||||||||||
Connection: default /usr/local/bin/gunicorn in <module>(8) sys.exit(run()) /usr/local/lib/python2.7/site-packages/gunicorn/app/wsgiapp.py in run(74) WSGIApplication("%(prog)s [OPTIONS] [APP_MODULE]").run() /usr/local/lib/python2.7/site-packages/gunicorn/app/base.py in run(203) super(Application, self).run() /usr/local/lib/python2.7/site-packages/gunicorn/app/base.py in run(72) Arbiter(self).run() /usr/local/lib/python2.7/site-packages/gunicorn/arbiter.py in run(202) self.manage_workers() /usr/local/lib/python2.7/site-packages/gunicorn/arbiter.py in manage_workers(544) self.spawn_workers() /usr/local/lib/python2.7/site-packages/gunicorn/arbiter.py in spawn_workers(611) self.spawn_worker() /usr/local/lib/python2.7/site-packages/gunicorn/arbiter.py in spawn_worker(578) worker.init_process() /usr/local/lib/python2.7/site-packages/gunicorn/workers/base.py in init_process(131) self.run() /usr/local/lib/python2.7/site-packages/gunicorn/workers/sync.py in run(124) self.run_for_one(timeout) /usr/local/lib/python2.7/site-packages/gunicorn/workers/sync.py in run_for_one(68) self.accept(listener) /usr/local/lib/python2.7/site-packages/gunicorn/workers/sync.py in accept(30) self.handle(listener, client, addr) /usr/local/lib/python2.7/site-packages/gunicorn/workers/sync.py in handle(135) self.handle_request(listener, req, client, addr) /usr/local/lib/python2.7/site-packages/gunicorn/workers/sync.py in handle_request(176) respiter = self.wsgi(environ, resp.start_response) /app/codalab/apps/web/views.py in get(127) return CompetitionDetailView.as_view()(*args, **kwargs) /app/codalab/apps/web/views.py in get(528) return super(CompetitionDetailView, self).get(request, *args, **kwargs) /app/codalab/apps/web/views.py in get_context_data(538) for category in models.ContentCategory.objects.all(): |
|||||||||||||||||||
+ |
SELECT ••• "web_pagecontainer"."id", "web_pagecontainer"."name", "web_pagecontainer"."content_type_id", "web_pagecontainer"."object_id" FROM "web_pagecontainer" WHERE ("web_pagecontainer"."object_id" = 9 AND "web_pagecontainer"."content_type_id" = 22 )
|
1.2289261439% |
0.56 | ||||||||||||||||
Connection: default /usr/local/bin/gunicorn in <module>(8) sys.exit(run()) /usr/local/lib/python2.7/site-packages/gunicorn/app/wsgiapp.py in run(74) WSGIApplication("%(prog)s [OPTIONS] [APP_MODULE]").run() /usr/local/lib/python2.7/site-packages/gunicorn/app/base.py in run(203) super(Application, self).run() /usr/local/lib/python2.7/site-packages/gunicorn/app/base.py in run(72) Arbiter(self).run() /usr/local/lib/python2.7/site-packages/gunicorn/arbiter.py in run(202) self.manage_workers() /usr/local/lib/python2.7/site-packages/gunicorn/arbiter.py in manage_workers(544) self.spawn_workers() /usr/local/lib/python2.7/site-packages/gunicorn/arbiter.py in spawn_workers(611) self.spawn_worker() /usr/local/lib/python2.7/site-packages/gunicorn/arbiter.py in spawn_worker(578) worker.init_process() /usr/local/lib/python2.7/site-packages/gunicorn/workers/base.py in init_process(131) self.run() /usr/local/lib/python2.7/site-packages/gunicorn/workers/sync.py in run(124) self.run_for_one(timeout) /usr/local/lib/python2.7/site-packages/gunicorn/workers/sync.py in run_for_one(68) self.accept(listener) /usr/local/lib/python2.7/site-packages/gunicorn/workers/sync.py in accept(30) self.handle(listener, client, addr) /usr/local/lib/python2.7/site-packages/gunicorn/workers/sync.py in handle(135) self.handle_request(listener, req, client, addr) /usr/local/lib/python2.7/site-packages/gunicorn/workers/sync.py in handle_request(176) respiter = self.wsgi(environ, resp.start_response) /app/codalab/apps/web/views.py in get(127) return CompetitionDetailView.as_view()(*args, **kwargs) /app/codalab/apps/web/views.py in get(528) return super(CompetitionDetailView, self).get(request, *args, **kwargs) /app/codalab/apps/web/views.py in get_context_data(539) pagecontent = context['object'].pagecontent /app/codalab/apps/web/models.py in pagecontent(304) items = list(self.pagecontainers.all()) |
|||||||||||||||||||
+ |
SELECT ••• "web_page"."id", "web_page"."category_id", "web_page"."defaults_id", "web_page"."codename", "web_page"."container_id", "web_page"."title", "web_page"."label", "web_page"."rank", "web_page"."visibility", "web_page"."markup", "web_page"."html", "web_page"."competition_id" FROM "web_page" WHERE ("web_page"."container_id" = 9 AND "web_page"."category_id" = 1 ) ORDER BY "web_page"."category_id" ASC, "web_page"."rank" ASC
|
3.65114219383% |
1.66 | ||||||||||||||||
Connection: default /usr/local/bin/gunicorn in <module>(8) sys.exit(run()) /usr/local/lib/python2.7/site-packages/gunicorn/app/wsgiapp.py in run(74) WSGIApplication("%(prog)s [OPTIONS] [APP_MODULE]").run() /usr/local/lib/python2.7/site-packages/gunicorn/app/base.py in run(203) super(Application, self).run() /usr/local/lib/python2.7/site-packages/gunicorn/app/base.py in run(72) Arbiter(self).run() /usr/local/lib/python2.7/site-packages/gunicorn/arbiter.py in run(202) self.manage_workers() /usr/local/lib/python2.7/site-packages/gunicorn/arbiter.py in manage_workers(544) self.spawn_workers() /usr/local/lib/python2.7/site-packages/gunicorn/arbiter.py in spawn_workers(611) self.spawn_worker() /usr/local/lib/python2.7/site-packages/gunicorn/arbiter.py in spawn_worker(578) worker.init_process() /usr/local/lib/python2.7/site-packages/gunicorn/workers/base.py in init_process(131) self.run() /usr/local/lib/python2.7/site-packages/gunicorn/workers/sync.py in run(124) self.run_for_one(timeout) /usr/local/lib/python2.7/site-packages/gunicorn/workers/sync.py in run_for_one(68) self.accept(listener) /usr/local/lib/python2.7/site-packages/gunicorn/workers/sync.py in accept(30) self.handle(listener, client, addr) /usr/local/lib/python2.7/site-packages/gunicorn/workers/sync.py in handle(135) self.handle_request(listener, req, client, addr) /usr/local/lib/python2.7/site-packages/gunicorn/workers/sync.py in handle_request(176) respiter = self.wsgi(environ, resp.start_response) /app/codalab/apps/web/views.py in get(127) return CompetitionDetailView.as_view()(*args, **kwargs) /app/codalab/apps/web/views.py in get(528) return super(CompetitionDetailView, self).get(request, *args, **kwargs) /app/codalab/apps/web/views.py in get_context_data(541) tc = [x for x in pagecontent.pages.filter(category=category)] |
|||||||||||||||||||
+ |
SELECT ••• "web_pagecontainer"."id", "web_pagecontainer"."name", "web_pagecontainer"."content_type_id", "web_pagecontainer"."object_id" FROM "web_pagecontainer" WHERE ("web_pagecontainer"."object_id" = 9 AND "web_pagecontainer"."content_type_id" = 22 )
|
0.611056666859% |
0.28 | ||||||||||||||||
Connection: default /usr/local/bin/gunicorn in <module>(8) sys.exit(run()) /usr/local/lib/python2.7/site-packages/gunicorn/app/wsgiapp.py in run(74) WSGIApplication("%(prog)s [OPTIONS] [APP_MODULE]").run() /usr/local/lib/python2.7/site-packages/gunicorn/app/base.py in run(203) super(Application, self).run() /usr/local/lib/python2.7/site-packages/gunicorn/app/base.py in run(72) Arbiter(self).run() /usr/local/lib/python2.7/site-packages/gunicorn/arbiter.py in run(202) self.manage_workers() /usr/local/lib/python2.7/site-packages/gunicorn/arbiter.py in manage_workers(544) self.spawn_workers() /usr/local/lib/python2.7/site-packages/gunicorn/arbiter.py in spawn_workers(611) self.spawn_worker() /usr/local/lib/python2.7/site-packages/gunicorn/arbiter.py in spawn_worker(578) worker.init_process() /usr/local/lib/python2.7/site-packages/gunicorn/workers/base.py in init_process(131) self.run() /usr/local/lib/python2.7/site-packages/gunicorn/workers/sync.py in run(124) self.run_for_one(timeout) /usr/local/lib/python2.7/site-packages/gunicorn/workers/sync.py in run_for_one(68) self.accept(listener) /usr/local/lib/python2.7/site-packages/gunicorn/workers/sync.py in accept(30) self.handle(listener, client, addr) /usr/local/lib/python2.7/site-packages/gunicorn/workers/sync.py in handle(135) self.handle_request(listener, req, client, addr) /usr/local/lib/python2.7/site-packages/gunicorn/workers/sync.py in handle_request(176) respiter = self.wsgi(environ, resp.start_response) /app/codalab/apps/web/views.py in get(127) return CompetitionDetailView.as_view()(*args, **kwargs) /app/codalab/apps/web/views.py in get(528) return super(CompetitionDetailView, self).get(request, *args, **kwargs) /app/codalab/apps/web/views.py in get_context_data(539) pagecontent = context['object'].pagecontent /app/codalab/apps/web/models.py in pagecontent(304) items = list(self.pagecontainers.all()) |
|||||||||||||||||||
+ |
SELECT ••• "web_page"."id", "web_page"."category_id", "web_page"."defaults_id", "web_page"."codename", "web_page"."container_id", "web_page"."title", "web_page"."label", "web_page"."rank", "web_page"."visibility", "web_page"."markup", "web_page"."html", "web_page"."competition_id" FROM "web_page" WHERE ("web_page"."container_id" = 9 AND "web_page"."category_id" = 2 ) ORDER BY "web_page"."category_id" ASC, "web_page"."rank" ASC
|
1.18438084657% |
0.54 | ||||||||||||||||
Connection: default /usr/local/bin/gunicorn in <module>(8) sys.exit(run()) /usr/local/lib/python2.7/site-packages/gunicorn/app/wsgiapp.py in run(74) WSGIApplication("%(prog)s [OPTIONS] [APP_MODULE]").run() /usr/local/lib/python2.7/site-packages/gunicorn/app/base.py in run(203) super(Application, self).run() /usr/local/lib/python2.7/site-packages/gunicorn/app/base.py in run(72) Arbiter(self).run() /usr/local/lib/python2.7/site-packages/gunicorn/arbiter.py in run(202) self.manage_workers() /usr/local/lib/python2.7/site-packages/gunicorn/arbiter.py in manage_workers(544) self.spawn_workers() /usr/local/lib/python2.7/site-packages/gunicorn/arbiter.py in spawn_workers(611) self.spawn_worker() /usr/local/lib/python2.7/site-packages/gunicorn/arbiter.py in spawn_worker(578) worker.init_process() /usr/local/lib/python2.7/site-packages/gunicorn/workers/base.py in init_process(131) self.run() /usr/local/lib/python2.7/site-packages/gunicorn/workers/sync.py in run(124) self.run_for_one(timeout) /usr/local/lib/python2.7/site-packages/gunicorn/workers/sync.py in run_for_one(68) self.accept(listener) /usr/local/lib/python2.7/site-packages/gunicorn/workers/sync.py in accept(30) self.handle(listener, client, addr) /usr/local/lib/python2.7/site-packages/gunicorn/workers/sync.py in handle(135) self.handle_request(listener, req, client, addr) /usr/local/lib/python2.7/site-packages/gunicorn/workers/sync.py in handle_request(176) respiter = self.wsgi(environ, resp.start_response) /app/codalab/apps/web/views.py in get(127) return CompetitionDetailView.as_view()(*args, **kwargs) /app/codalab/apps/web/views.py in get(528) return super(CompetitionDetailView, self).get(request, *args, **kwargs) /app/codalab/apps/web/views.py in get_context_data(541) tc = [x for x in pagecontent.pages.filter(category=category)] |
|||||||||||||||||||
+ |
SELECT ••• "web_pagecontainer"."id", "web_pagecontainer"."name", "web_pagecontainer"."content_type_id", "web_pagecontainer"."object_id" FROM "web_pagecontainer" WHERE ("web_pagecontainer"."object_id" = 9 AND "web_pagecontainer"."content_type_id" = 22 )
|
0.580661052212% |
0.26 | ||||||||||||||||
Connection: default /usr/local/bin/gunicorn in <module>(8) sys.exit(run()) /usr/local/lib/python2.7/site-packages/gunicorn/app/wsgiapp.py in run(74) WSGIApplication("%(prog)s [OPTIONS] [APP_MODULE]").run() /usr/local/lib/python2.7/site-packages/gunicorn/app/base.py in run(203) super(Application, self).run() /usr/local/lib/python2.7/site-packages/gunicorn/app/base.py in run(72) Arbiter(self).run() /usr/local/lib/python2.7/site-packages/gunicorn/arbiter.py in run(202) self.manage_workers() /usr/local/lib/python2.7/site-packages/gunicorn/arbiter.py in manage_workers(544) self.spawn_workers() /usr/local/lib/python2.7/site-packages/gunicorn/arbiter.py in spawn_workers(611) self.spawn_worker() /usr/local/lib/python2.7/site-packages/gunicorn/arbiter.py in spawn_worker(578) worker.init_process() /usr/local/lib/python2.7/site-packages/gunicorn/workers/base.py in init_process(131) self.run() /usr/local/lib/python2.7/site-packages/gunicorn/workers/sync.py in run(124) self.run_for_one(timeout) /usr/local/lib/python2.7/site-packages/gunicorn/workers/sync.py in run_for_one(68) self.accept(listener) /usr/local/lib/python2.7/site-packages/gunicorn/workers/sync.py in accept(30) self.handle(listener, client, addr) /usr/local/lib/python2.7/site-packages/gunicorn/workers/sync.py in handle(135) self.handle_request(listener, req, client, addr) /usr/local/lib/python2.7/site-packages/gunicorn/workers/sync.py in handle_request(176) respiter = self.wsgi(environ, resp.start_response) /app/codalab/apps/web/views.py in get(127) return CompetitionDetailView.as_view()(*args, **kwargs) /app/codalab/apps/web/views.py in get(528) return super(CompetitionDetailView, self).get(request, *args, **kwargs) /app/codalab/apps/web/views.py in get_context_data(539) pagecontent = context['object'].pagecontent /app/codalab/apps/web/models.py in pagecontent(304) items = list(self.pagecontainers.all()) |
|||||||||||||||||||
+ |
SELECT ••• "web_page"."id", "web_page"."category_id", "web_page"."defaults_id", "web_page"."codename", "web_page"."container_id", "web_page"."title", "web_page"."label", "web_page"."rank", "web_page"."visibility", "web_page"."markup", "web_page"."html", "web_page"."competition_id" FROM "web_page" WHERE ("web_page"."container_id" = 9 AND "web_page"."category_id" = 3 ) ORDER BY "web_page"."category_id" ASC, "web_page"."rank" ASC
|
0.947504677256% |
0.43 | ||||||||||||||||
Connection: default /usr/local/bin/gunicorn in <module>(8) sys.exit(run()) /usr/local/lib/python2.7/site-packages/gunicorn/app/wsgiapp.py in run(74) WSGIApplication("%(prog)s [OPTIONS] [APP_MODULE]").run() /usr/local/lib/python2.7/site-packages/gunicorn/app/base.py in run(203) super(Application, self).run() /usr/local/lib/python2.7/site-packages/gunicorn/app/base.py in run(72) Arbiter(self).run() /usr/local/lib/python2.7/site-packages/gunicorn/arbiter.py in run(202) self.manage_workers() /usr/local/lib/python2.7/site-packages/gunicorn/arbiter.py in manage_workers(544) self.spawn_workers() /usr/local/lib/python2.7/site-packages/gunicorn/arbiter.py in spawn_workers(611) self.spawn_worker() /usr/local/lib/python2.7/site-packages/gunicorn/arbiter.py in spawn_worker(578) worker.init_process() /usr/local/lib/python2.7/site-packages/gunicorn/workers/base.py in init_process(131) self.run() /usr/local/lib/python2.7/site-packages/gunicorn/workers/sync.py in run(124) self.run_for_one(timeout) /usr/local/lib/python2.7/site-packages/gunicorn/workers/sync.py in run_for_one(68) self.accept(listener) /usr/local/lib/python2.7/site-packages/gunicorn/workers/sync.py in accept(30) self.handle(listener, client, addr) /usr/local/lib/python2.7/site-packages/gunicorn/workers/sync.py in handle(135) self.handle_request(listener, req, client, addr) /usr/local/lib/python2.7/site-packages/gunicorn/workers/sync.py in handle_request(176) respiter = self.wsgi(environ, resp.start_response) /app/codalab/apps/web/views.py in get(127) return CompetitionDetailView.as_view()(*args, **kwargs) /app/codalab/apps/web/views.py in get(528) return super(CompetitionDetailView, self).get(request, *args, **kwargs) /app/codalab/apps/web/views.py in get_context_data(541) tc = [x for x in pagecontent.pages.filter(category=category)] |
|||||||||||||||||||
+ |
SELECT ••• "web_competitionphase"."id", "web_competitionphase"."competition_id", "web_competitionphase"."description", "web_competitionphase"."phasenumber", "web_competitionphase"."label", "web_competitionphase"."start_date", "web_competitionphase"."max_submissions", "web_competitionphase"."max_submissions_per_day", "web_competitionphase"."is_scoring_only", "web_competitionphase"."scoring_program", "web_competitionphase"."reference_data", "web_competitionphase"."input_data", "web_competitionphase"."leaderboard_management_mode", "web_competitionphase"."force_best_submission_to_leaderboard", "web_competitionphase"."auto_migration", "web_competitionphase"."is_migrated", "web_competitionphase"."execution_time_limit", "web_competitionphase"."color", "web_competitionphase"."input_data_organizer_dataset_id", "web_competitionphase"."reference_data_organizer_dataset_id", "web_competitionphase"."scoring_program_organizer_dataset_id", "web_competitionphase"."phase_never_ends", "web_competitionphase"."scoring_program_docker_image", "web_competitionphase"."default_docker_image", "web_competitionphase"."disable_custom_docker_image", "web_competitionphase"."starting_kit", "web_competitionphase"."starting_kit_organizer_dataset_id", "web_competitionphase"."public_data", "web_competitionphase"."public_data_organizer_dataset_id", "web_competitionphase"."ingestion_program", "web_competitionphase"."ingestion_program_docker_image", "web_competitionphase"."ingestion_program_organizer_dataset_id" FROM "web_competitionphase" WHERE "web_competitionphase"."competition_id" = 9 ORDER BY "web_competitionphase"."start_date" ASC, "web_competitionphase"."phasenumber" ASC
|
2.50344570976% |
1.14 | ||||||||||||||||
Connection: default /usr/local/bin/gunicorn in <module>(8) sys.exit(run()) /usr/local/lib/python2.7/site-packages/gunicorn/app/wsgiapp.py in run(74) WSGIApplication("%(prog)s [OPTIONS] [APP_MODULE]").run() /usr/local/lib/python2.7/site-packages/gunicorn/app/base.py in run(203) super(Application, self).run() /usr/local/lib/python2.7/site-packages/gunicorn/app/base.py in run(72) Arbiter(self).run() /usr/local/lib/python2.7/site-packages/gunicorn/arbiter.py in run(202) self.manage_workers() /usr/local/lib/python2.7/site-packages/gunicorn/arbiter.py in manage_workers(544) self.spawn_workers() /usr/local/lib/python2.7/site-packages/gunicorn/arbiter.py in spawn_workers(611) self.spawn_worker() /usr/local/lib/python2.7/site-packages/gunicorn/arbiter.py in spawn_worker(578) worker.init_process() /usr/local/lib/python2.7/site-packages/gunicorn/workers/base.py in init_process(131) self.run() /usr/local/lib/python2.7/site-packages/gunicorn/workers/sync.py in run(124) self.run_for_one(timeout) /usr/local/lib/python2.7/site-packages/gunicorn/workers/sync.py in run_for_one(68) self.accept(listener) /usr/local/lib/python2.7/site-packages/gunicorn/workers/sync.py in accept(30) self.handle(listener, client, addr) /usr/local/lib/python2.7/site-packages/gunicorn/workers/sync.py in handle(135) self.handle_request(listener, req, client, addr) /usr/local/lib/python2.7/site-packages/gunicorn/workers/sync.py in handle_request(176) respiter = self.wsgi(environ, resp.start_response) /app/codalab/apps/web/views.py in get(127) return CompetitionDetailView.as_view()(*args, **kwargs) /app/codalab/apps/web/views.py in get(528) return super(CompetitionDetailView, self).get(request, *args, **kwargs) /app/codalab/apps/web/views.py in get_context_data(550) context["first_phase"], context["previous_phase"], context['active_phase'], context["next_phase"] = get_first_previous_active_and_next_phases(competition) /app/codalab/apps/web/models.py in get_first_previous_active_and_next_phases(2491) phase_iterator = iter(all_phases) |
|||||||||||||||||||
+ |
SELECT ••• "web_submissionscoredef"."id", "web_submissionscoredef"."competition_id", "web_submissionscoredef"."key", "web_submissionscoredef"."label", "web_submissionscoredef"."sorting", "web_submissionscoredef"."numeric_format", "web_submissionscoredef"."show_rank", "web_submissionscoredef"."selection_default", "web_submissionscoredef"."computed", "web_submissionscoredef"."ordering" FROM "web_submissionscoredef" WHERE "web_submissionscoredef"."competition_id" = 9 ORDER BY "web_submissionscoredef"."ordering" ASC LIMIT 1
|
1.53445447733% |
0.70 | ||||||||||||||||
Connection: default /usr/local/bin/gunicorn in <module>(8) sys.exit(run()) /usr/local/lib/python2.7/site-packages/gunicorn/app/wsgiapp.py in run(74) WSGIApplication("%(prog)s [OPTIONS] [APP_MODULE]").run() /usr/local/lib/python2.7/site-packages/gunicorn/app/base.py in run(203) super(Application, self).run() /usr/local/lib/python2.7/site-packages/gunicorn/app/base.py in run(72) Arbiter(self).run() /usr/local/lib/python2.7/site-packages/gunicorn/arbiter.py in run(202) self.manage_workers() /usr/local/lib/python2.7/site-packages/gunicorn/arbiter.py in manage_workers(544) self.spawn_workers() /usr/local/lib/python2.7/site-packages/gunicorn/arbiter.py in spawn_workers(611) self.spawn_worker() /usr/local/lib/python2.7/site-packages/gunicorn/arbiter.py in spawn_worker(578) worker.init_process() /usr/local/lib/python2.7/site-packages/gunicorn/workers/base.py in init_process(131) self.run() /usr/local/lib/python2.7/site-packages/gunicorn/workers/sync.py in run(124) self.run_for_one(timeout) /usr/local/lib/python2.7/site-packages/gunicorn/workers/sync.py in run_for_one(68) self.accept(listener) /usr/local/lib/python2.7/site-packages/gunicorn/workers/sync.py in accept(30) self.handle(listener, client, addr) /usr/local/lib/python2.7/site-packages/gunicorn/workers/sync.py in handle(135) self.handle_request(listener, req, client, addr) /usr/local/lib/python2.7/site-packages/gunicorn/workers/sync.py in handle_request(176) respiter = self.wsgi(environ, resp.start_response) /app/codalab/apps/web/views.py in get(127) return CompetitionDetailView.as_view()(*args, **kwargs) /app/codalab/apps/web/views.py in get(528) return super(CompetitionDetailView, self).get(request, *args, **kwargs) /app/codalab/apps/web/views.py in get_context_data(554) score_def = SubmissionScoreDef.objects.filter(competition=competition).order_by('ordering').first() |
|||||||||||||||||||
+ |
SELECT ••• (DATE_TRUNC('day', submitted_at)) AS "day", COUNT("web_submissionscore"."id") AS "count", MAX("web_submissionscore"."value") AS "high_score" FROM "web_submissionscore" INNER JOIN "web_competitionsubmission" ON ( "web_submissionscore"."result_id" = "web_competitionsubmission"."id" ) INNER JOIN "web_competitionphase" ON ( "web_competitionsubmission"."phase_id" = "web_competitionphase"."id" ) WHERE ("web_submissionscore"."scoredef_id" = 10 AND "web_competitionphase"."competition_id" = 9 ) GROUP BY (DATE_TRUNC('day', submitted_at))
|
4.0819214221% |
1.86 | ||||||||||||||||
Connection: default /usr/local/bin/gunicorn in <module>(8) sys.exit(run()) /usr/local/lib/python2.7/site-packages/gunicorn/app/wsgiapp.py in run(74) WSGIApplication("%(prog)s [OPTIONS] [APP_MODULE]").run() /usr/local/lib/python2.7/site-packages/gunicorn/app/base.py in run(203) super(Application, self).run() /usr/local/lib/python2.7/site-packages/gunicorn/app/base.py in run(72) Arbiter(self).run() /usr/local/lib/python2.7/site-packages/gunicorn/arbiter.py in run(202) self.manage_workers() /usr/local/lib/python2.7/site-packages/gunicorn/arbiter.py in manage_workers(544) self.spawn_workers() /usr/local/lib/python2.7/site-packages/gunicorn/arbiter.py in spawn_workers(611) self.spawn_worker() /usr/local/lib/python2.7/site-packages/gunicorn/arbiter.py in spawn_worker(578) worker.init_process() /usr/local/lib/python2.7/site-packages/gunicorn/workers/base.py in init_process(131) self.run() /usr/local/lib/python2.7/site-packages/gunicorn/workers/sync.py in run(124) self.run_for_one(timeout) /usr/local/lib/python2.7/site-packages/gunicorn/workers/sync.py in run_for_one(68) self.accept(listener) /usr/local/lib/python2.7/site-packages/gunicorn/workers/sync.py in accept(30) self.handle(listener, client, addr) /usr/local/lib/python2.7/site-packages/gunicorn/workers/sync.py in handle(135) self.handle_request(listener, req, client, addr) /usr/local/lib/python2.7/site-packages/gunicorn/workers/sync.py in handle_request(176) respiter = self.wsgi(environ, resp.start_response) /app/codalab/apps/web/views.py in get(127) return CompetitionDetailView.as_view()(*args, **kwargs) /app/codalab/apps/web/views.py in get(528) return super(CompetitionDetailView, self).get(request, *args, **kwargs) /app/codalab/apps/web/views.py in get_context_data(566) for s in qs], |
|||||||||||||||||||
+ |
SELECT ••• "web_phaseleaderboard"."id", "web_phaseleaderboard"."phase_id" FROM "web_phaseleaderboard" WHERE "web_phaseleaderboard"."phase_id" = 18
|
1.14717242174% |
0.52 | ||||||||||||||||
Connection: default /usr/local/bin/gunicorn in <module>(8) sys.exit(run()) /usr/local/lib/python2.7/site-packages/gunicorn/app/wsgiapp.py in run(74) WSGIApplication("%(prog)s [OPTIONS] [APP_MODULE]").run() /usr/local/lib/python2.7/site-packages/gunicorn/app/base.py in run(203) super(Application, self).run() /usr/local/lib/python2.7/site-packages/gunicorn/app/base.py in run(72) Arbiter(self).run() /usr/local/lib/python2.7/site-packages/gunicorn/arbiter.py in run(202) self.manage_workers() /usr/local/lib/python2.7/site-packages/gunicorn/arbiter.py in manage_workers(544) self.spawn_workers() /usr/local/lib/python2.7/site-packages/gunicorn/arbiter.py in spawn_workers(611) self.spawn_worker() /usr/local/lib/python2.7/site-packages/gunicorn/arbiter.py in spawn_worker(578) worker.init_process() /usr/local/lib/python2.7/site-packages/gunicorn/workers/base.py in init_process(131) self.run() /usr/local/lib/python2.7/site-packages/gunicorn/workers/sync.py in run(124) self.run_for_one(timeout) /usr/local/lib/python2.7/site-packages/gunicorn/workers/sync.py in run_for_one(68) self.accept(listener) /usr/local/lib/python2.7/site-packages/gunicorn/workers/sync.py in accept(30) self.handle(listener, client, addr) /usr/local/lib/python2.7/site-packages/gunicorn/workers/sync.py in handle(135) self.handle_request(listener, req, client, addr) /usr/local/lib/python2.7/site-packages/gunicorn/workers/sync.py in handle_request(176) respiter = self.wsgi(environ, resp.start_response) /app/codalab/apps/web/views.py in get(127) return CompetitionDetailView.as_view()(*args, **kwargs) /app/codalab/apps/web/views.py in get(528) return super(CompetitionDetailView, self).get(request, *args, **kwargs) /app/codalab/apps/web/views.py in get_context_data(576) scores = context['active_phase'].scores() /app/codalab/apps/web/models.py in scores(1060) lb, created = PhaseLeaderBoard.objects.get_or_create(phase=self) |
|||||||||||||||||||
+ |
SELECT ••• "web_phaseleaderboardentry"."id", "web_phaseleaderboardentry"."board_id", "web_phaseleaderboardentry"."result_id" FROM "web_phaseleaderboardentry" WHERE "web_phaseleaderboardentry"."board_id" = 11
|
1.01982527762% |
0.46 | ||||||||||||||||
Connection: default /usr/local/bin/gunicorn in <module>(8) sys.exit(run()) /usr/local/lib/python2.7/site-packages/gunicorn/app/wsgiapp.py in run(74) WSGIApplication("%(prog)s [OPTIONS] [APP_MODULE]").run() /usr/local/lib/python2.7/site-packages/gunicorn/app/base.py in run(203) super(Application, self).run() /usr/local/lib/python2.7/site-packages/gunicorn/app/base.py in run(72) Arbiter(self).run() /usr/local/lib/python2.7/site-packages/gunicorn/arbiter.py in run(202) self.manage_workers() /usr/local/lib/python2.7/site-packages/gunicorn/arbiter.py in manage_workers(544) self.spawn_workers() /usr/local/lib/python2.7/site-packages/gunicorn/arbiter.py in spawn_workers(611) self.spawn_worker() /usr/local/lib/python2.7/site-packages/gunicorn/arbiter.py in spawn_worker(578) worker.init_process() /usr/local/lib/python2.7/site-packages/gunicorn/workers/base.py in init_process(131) self.run() /usr/local/lib/python2.7/site-packages/gunicorn/workers/sync.py in run(124) self.run_for_one(timeout) /usr/local/lib/python2.7/site-packages/gunicorn/workers/sync.py in run_for_one(68) self.accept(listener) /usr/local/lib/python2.7/site-packages/gunicorn/workers/sync.py in accept(30) self.handle(listener, client, addr) /usr/local/lib/python2.7/site-packages/gunicorn/workers/sync.py in handle(135) self.handle_request(listener, req, client, addr) /usr/local/lib/python2.7/site-packages/gunicorn/workers/sync.py in handle_request(176) respiter = self.wsgi(environ, resp.start_response) /app/codalab/apps/web/views.py in get(127) return CompetitionDetailView.as_view()(*args, **kwargs) /app/codalab/apps/web/views.py in get(528) return super(CompetitionDetailView, self).get(request, *args, **kwargs) /app/codalab/apps/web/views.py in get_context_data(576) scores = context['active_phase'].scores() /app/codalab/apps/web/models.py in scores(1070) submissions = [entry.result for entry in qs] |
|||||||||||||||||||
+ |
SELECT ••• "web_competitionsubmission"."id", "web_competitionsubmission"."chahub_timestamp", "web_competitionsubmission"."chahub_data_hash", "web_competitionsubmission"."chahub_needs_retry", "web_competitionsubmission"."participant_id", "web_competitionsubmission"."phase_id", "web_competitionsubmission"."secret", "web_competitionsubmission"."docker_image", "web_competitionsubmission"."file", "web_competitionsubmission"."s3_file", "web_competitionsubmission"."file_url_base", "web_competitionsubmission"."readable_filename", "web_competitionsubmission"."description", "web_competitionsubmission"."inputfile", "web_competitionsubmission"."runfile", "web_competitionsubmission"."submitted_at", "web_competitionsubmission"."started_at", "web_competitionsubmission"."completed_at", "web_competitionsubmission"."execution_key", "web_competitionsubmission"."status_id", "web_competitionsubmission"."status_details", "web_competitionsubmission"."submission_number", "web_competitionsubmission"."output_file", "web_competitionsubmission"."private_output_file", "web_competitionsubmission"."stdout_file", "web_competitionsubmission"."stderr_file", "web_competitionsubmission"."history_file", "web_competitionsubmission"."scores_file", "web_competitionsubmission"."coopetition_file", "web_competitionsubmission"."detailed_results_file", "web_competitionsubmission"."docker_results_file", "web_competitionsubmission"."prediction_runfile", "web_competitionsubmission"."prediction_output_file", "web_competitionsubmission"."exception_details", "web_competitionsubmission"."prediction_stdout_file", "web_competitionsubmission"."prediction_stderr_file", "web_competitionsubmission"."ingestion_program_stdout_file", "web_competitionsubmission"."ingestion_program_stderr_file", "web_competitionsubmission"."method_name", "web_competitionsubmission"."method_description", "web_competitionsubmission"."project_url", "web_competitionsubmission"."publication_url", "web_competitionsubmission"."bibtex", "web_competitionsubmission"."organization_or_affiliation", "web_competitionsubmission"."team_name", "web_competitionsubmission"."is_public", "web_competitionsubmission"."when_made_public", "web_competitionsubmission"."when_unmade_public", "web_competitionsubmission"."download_count", "web_competitionsubmission"."like_count", "web_competitionsubmission"."dislike_count", "web_competitionsubmission"."is_migrated", "web_competitionsubmission"."team_id", "web_competitionsubmission"."queue_name" FROM "web_competitionsubmission" WHERE "web_competitionsubmission"."id" = 478
|
2.01135118988% |
0.92 | ||||||||||||||||
Connection: default /usr/local/bin/gunicorn in <module>(8) sys.exit(run()) /usr/local/lib/python2.7/site-packages/gunicorn/app/wsgiapp.py in run(74) WSGIApplication("%(prog)s [OPTIONS] [APP_MODULE]").run() /usr/local/lib/python2.7/site-packages/gunicorn/app/base.py in run(203) super(Application, self).run() /usr/local/lib/python2.7/site-packages/gunicorn/app/base.py in run(72) Arbiter(self).run() /usr/local/lib/python2.7/site-packages/gunicorn/arbiter.py in run(202) self.manage_workers() /usr/local/lib/python2.7/site-packages/gunicorn/arbiter.py in manage_workers(544) self.spawn_workers() /usr/local/lib/python2.7/site-packages/gunicorn/arbiter.py in spawn_workers(611) self.spawn_worker() /usr/local/lib/python2.7/site-packages/gunicorn/arbiter.py in spawn_worker(578) worker.init_process() /usr/local/lib/python2.7/site-packages/gunicorn/workers/base.py in init_process(131) self.run() /usr/local/lib/python2.7/site-packages/gunicorn/workers/sync.py in run(124) self.run_for_one(timeout) /usr/local/lib/python2.7/site-packages/gunicorn/workers/sync.py in run_for_one(68) self.accept(listener) /usr/local/lib/python2.7/site-packages/gunicorn/workers/sync.py in accept(30) self.handle(listener, client, addr) /usr/local/lib/python2.7/site-packages/gunicorn/workers/sync.py in handle(135) self.handle_request(listener, req, client, addr) /usr/local/lib/python2.7/site-packages/gunicorn/workers/sync.py in handle_request(176) respiter = self.wsgi(environ, resp.start_response) /app/codalab/apps/web/views.py in get(127) return CompetitionDetailView.as_view()(*args, **kwargs) /app/codalab/apps/web/views.py in get(528) return super(CompetitionDetailView, self).get(request, *args, **kwargs) /app/codalab/apps/web/views.py in get_context_data(576) scores = context['active_phase'].scores() /app/codalab/apps/web/models.py in scores(1070) submissions = [entry.result for entry in qs] |
|||||||||||||||||||
+ |
SELECT ••• "web_competitionsubmission"."id", "web_competitionsubmission"."chahub_timestamp", "web_competitionsubmission"."chahub_data_hash", "web_competitionsubmission"."chahub_needs_retry", "web_competitionsubmission"."participant_id", "web_competitionsubmission"."phase_id", "web_competitionsubmission"."secret", "web_competitionsubmission"."docker_image", "web_competitionsubmission"."file", "web_competitionsubmission"."s3_file", "web_competitionsubmission"."file_url_base", "web_competitionsubmission"."readable_filename", "web_competitionsubmission"."description", "web_competitionsubmission"."inputfile", "web_competitionsubmission"."runfile", "web_competitionsubmission"."submitted_at", "web_competitionsubmission"."started_at", "web_competitionsubmission"."completed_at", "web_competitionsubmission"."execution_key", "web_competitionsubmission"."status_id", "web_competitionsubmission"."status_details", "web_competitionsubmission"."submission_number", "web_competitionsubmission"."output_file", "web_competitionsubmission"."private_output_file", "web_competitionsubmission"."stdout_file", "web_competitionsubmission"."stderr_file", "web_competitionsubmission"."history_file", "web_competitionsubmission"."scores_file", "web_competitionsubmission"."coopetition_file", "web_competitionsubmission"."detailed_results_file", "web_competitionsubmission"."docker_results_file", "web_competitionsubmission"."prediction_runfile", "web_competitionsubmission"."prediction_output_file", "web_competitionsubmission"."exception_details", "web_competitionsubmission"."prediction_stdout_file", "web_competitionsubmission"."prediction_stderr_file", "web_competitionsubmission"."ingestion_program_stdout_file", "web_competitionsubmission"."ingestion_program_stderr_file", "web_competitionsubmission"."method_name", "web_competitionsubmission"."method_description", "web_competitionsubmission"."project_url", "web_competitionsubmission"."publication_url", "web_competitionsubmission"."bibtex", "web_competitionsubmission"."organization_or_affiliation", "web_competitionsubmission"."team_name", "web_competitionsubmission"."is_public", "web_competitionsubmission"."when_made_public", "web_competitionsubmission"."when_unmade_public", "web_competitionsubmission"."download_count", "web_competitionsubmission"."like_count", "web_competitionsubmission"."dislike_count", "web_competitionsubmission"."is_migrated", "web_competitionsubmission"."team_id", "web_competitionsubmission"."queue_name" FROM "web_competitionsubmission" WHERE "web_competitionsubmission"."id" = 505
|
1.24412395122% |
0.57 | ||||||||||||||||
Connection: default /usr/local/bin/gunicorn in <module>(8) sys.exit(run()) /usr/local/lib/python2.7/site-packages/gunicorn/app/wsgiapp.py in run(74) WSGIApplication("%(prog)s [OPTIONS] [APP_MODULE]").run() /usr/local/lib/python2.7/site-packages/gunicorn/app/base.py in run(203) super(Application, self).run() /usr/local/lib/python2.7/site-packages/gunicorn/app/base.py in run(72) Arbiter(self).run() /usr/local/lib/python2.7/site-packages/gunicorn/arbiter.py in run(202) self.manage_workers() /usr/local/lib/python2.7/site-packages/gunicorn/arbiter.py in manage_workers(544) self.spawn_workers() /usr/local/lib/python2.7/site-packages/gunicorn/arbiter.py in spawn_workers(611) self.spawn_worker() /usr/local/lib/python2.7/site-packages/gunicorn/arbiter.py in spawn_worker(578) worker.init_process() /usr/local/lib/python2.7/site-packages/gunicorn/workers/base.py in init_process(131) self.run() /usr/local/lib/python2.7/site-packages/gunicorn/workers/sync.py in run(124) self.run_for_one(timeout) /usr/local/lib/python2.7/site-packages/gunicorn/workers/sync.py in run_for_one(68) self.accept(listener) /usr/local/lib/python2.7/site-packages/gunicorn/workers/sync.py in accept(30) self.handle(listener, client, addr) /usr/local/lib/python2.7/site-packages/gunicorn/workers/sync.py in handle(135) self.handle_request(listener, req, client, addr) /usr/local/lib/python2.7/site-packages/gunicorn/workers/sync.py in handle_request(176) respiter = self.wsgi(environ, resp.start_response) /app/codalab/apps/web/views.py in get(127) return CompetitionDetailView.as_view()(*args, **kwargs) /app/codalab/apps/web/views.py in get(528) return super(CompetitionDetailView, self).get(request, *args, **kwargs) /app/codalab/apps/web/views.py in get_context_data(576) scores = context['active_phase'].scores() /app/codalab/apps/web/models.py in scores(1070) submissions = [entry.result for entry in qs] |
|||||||||||||||||||
+ |
SELECT ••• "web_competitionsubmission"."id", "web_competitionsubmission"."chahub_timestamp", "web_competitionsubmission"."chahub_data_hash", "web_competitionsubmission"."chahub_needs_retry", "web_competitionsubmission"."participant_id", "web_competitionsubmission"."phase_id", "web_competitionsubmission"."secret", "web_competitionsubmission"."docker_image", "web_competitionsubmission"."file", "web_competitionsubmission"."s3_file", "web_competitionsubmission"."file_url_base", "web_competitionsubmission"."readable_filename", "web_competitionsubmission"."description", "web_competitionsubmission"."inputfile", "web_competitionsubmission"."runfile", "web_competitionsubmission"."submitted_at", "web_competitionsubmission"."started_at", "web_competitionsubmission"."completed_at", "web_competitionsubmission"."execution_key", "web_competitionsubmission"."status_id", "web_competitionsubmission"."status_details", "web_competitionsubmission"."submission_number", "web_competitionsubmission"."output_file", "web_competitionsubmission"."private_output_file", "web_competitionsubmission"."stdout_file", "web_competitionsubmission"."stderr_file", "web_competitionsubmission"."history_file", "web_competitionsubmission"."scores_file", "web_competitionsubmission"."coopetition_file", "web_competitionsubmission"."detailed_results_file", "web_competitionsubmission"."docker_results_file", "web_competitionsubmission"."prediction_runfile", "web_competitionsubmission"."prediction_output_file", "web_competitionsubmission"."exception_details", "web_competitionsubmission"."prediction_stdout_file", "web_competitionsubmission"."prediction_stderr_file", "web_competitionsubmission"."ingestion_program_stdout_file", "web_competitionsubmission"."ingestion_program_stderr_file", "web_competitionsubmission"."method_name", "web_competitionsubmission"."method_description", "web_competitionsubmission"."project_url", "web_competitionsubmission"."publication_url", "web_competitionsubmission"."bibtex", "web_competitionsubmission"."organization_or_affiliation", "web_competitionsubmission"."team_name", "web_competitionsubmission"."is_public", "web_competitionsubmission"."when_made_public", "web_competitionsubmission"."when_unmade_public", "web_competitionsubmission"."download_count", "web_competitionsubmission"."like_count", "web_competitionsubmission"."dislike_count", "web_competitionsubmission"."is_migrated", "web_competitionsubmission"."team_id", "web_competitionsubmission"."queue_name" FROM "web_competitionsubmission" WHERE "web_competitionsubmission"."id" = 506
|
1.24622020051% |
0.57 | ||||||||||||||||
Connection: default /usr/local/bin/gunicorn in <module>(8) sys.exit(run()) /usr/local/lib/python2.7/site-packages/gunicorn/app/wsgiapp.py in run(74) WSGIApplication("%(prog)s [OPTIONS] [APP_MODULE]").run() /usr/local/lib/python2.7/site-packages/gunicorn/app/base.py in run(203) super(Application, self).run() /usr/local/lib/python2.7/site-packages/gunicorn/app/base.py in run(72) Arbiter(self).run() /usr/local/lib/python2.7/site-packages/gunicorn/arbiter.py in run(202) self.manage_workers() /usr/local/lib/python2.7/site-packages/gunicorn/arbiter.py in manage_workers(544) self.spawn_workers() /usr/local/lib/python2.7/site-packages/gunicorn/arbiter.py in spawn_workers(611) self.spawn_worker() /usr/local/lib/python2.7/site-packages/gunicorn/arbiter.py in spawn_worker(578) worker.init_process() /usr/local/lib/python2.7/site-packages/gunicorn/workers/base.py in init_process(131) self.run() /usr/local/lib/python2.7/site-packages/gunicorn/workers/sync.py in run(124) self.run_for_one(timeout) /usr/local/lib/python2.7/site-packages/gunicorn/workers/sync.py in run_for_one(68) self.accept(listener) /usr/local/lib/python2.7/site-packages/gunicorn/workers/sync.py in accept(30) self.handle(listener, client, addr) /usr/local/lib/python2.7/site-packages/gunicorn/workers/sync.py in handle(135) self.handle_request(listener, req, client, addr) /usr/local/lib/python2.7/site-packages/gunicorn/workers/sync.py in handle_request(176) respiter = self.wsgi(environ, resp.start_response) /app/codalab/apps/web/views.py in get(127) return CompetitionDetailView.as_view()(*args, **kwargs) /app/codalab/apps/web/views.py in get(528) return super(CompetitionDetailView, self).get(request, *args, **kwargs) /app/codalab/apps/web/views.py in get_context_data(576) scores = context['active_phase'].scores() /app/codalab/apps/web/models.py in scores(1070) submissions = [entry.result for entry in qs] |
|||||||||||||||||||
+ |
SELECT ••• "web_competitionsubmission"."id", "web_competitionsubmission"."chahub_timestamp", "web_competitionsubmission"."chahub_data_hash", "web_competitionsubmission"."chahub_needs_retry", "web_competitionsubmission"."participant_id", "web_competitionsubmission"."phase_id", "web_competitionsubmission"."secret", "web_competitionsubmission"."docker_image", "web_competitionsubmission"."file", "web_competitionsubmission"."s3_file", "web_competitionsubmission"."file_url_base", "web_competitionsubmission"."readable_filename", "web_competitionsubmission"."description", "web_competitionsubmission"."inputfile", "web_competitionsubmission"."runfile", "web_competitionsubmission"."submitted_at", "web_competitionsubmission"."started_at", "web_competitionsubmission"."completed_at", "web_competitionsubmission"."execution_key", "web_competitionsubmission"."status_id", "web_competitionsubmission"."status_details", "web_competitionsubmission"."submission_number", "web_competitionsubmission"."output_file", "web_competitionsubmission"."private_output_file", "web_competitionsubmission"."stdout_file", "web_competitionsubmission"."stderr_file", "web_competitionsubmission"."history_file", "web_competitionsubmission"."scores_file", "web_competitionsubmission"."coopetition_file", "web_competitionsubmission"."detailed_results_file", "web_competitionsubmission"."docker_results_file", "web_competitionsubmission"."prediction_runfile", "web_competitionsubmission"."prediction_output_file", "web_competitionsubmission"."exception_details", "web_competitionsubmission"."prediction_stdout_file", "web_competitionsubmission"."prediction_stderr_file", "web_competitionsubmission"."ingestion_program_stdout_file", "web_competitionsubmission"."ingestion_program_stderr_file", "web_competitionsubmission"."method_name", "web_competitionsubmission"."method_description", "web_competitionsubmission"."project_url", "web_competitionsubmission"."publication_url", "web_competitionsubmission"."bibtex", "web_competitionsubmission"."organization_or_affiliation", "web_competitionsubmission"."team_name", "web_competitionsubmission"."is_public", "web_competitionsubmission"."when_made_public", "web_competitionsubmission"."when_unmade_public", "web_competitionsubmission"."download_count", "web_competitionsubmission"."like_count", "web_competitionsubmission"."dislike_count", "web_competitionsubmission"."is_migrated", "web_competitionsubmission"."team_id", "web_competitionsubmission"."queue_name" FROM "web_competitionsubmission" WHERE "web_competitionsubmission"."id" = 515
|
1.29286174712% |
0.59 | ||||||||||||||||
Connection: default /usr/local/bin/gunicorn in <module>(8) sys.exit(run()) /usr/local/lib/python2.7/site-packages/gunicorn/app/wsgiapp.py in run(74) WSGIApplication("%(prog)s [OPTIONS] [APP_MODULE]").run() /usr/local/lib/python2.7/site-packages/gunicorn/app/base.py in run(203) super(Application, self).run() /usr/local/lib/python2.7/site-packages/gunicorn/app/base.py in run(72) Arbiter(self).run() /usr/local/lib/python2.7/site-packages/gunicorn/arbiter.py in run(202) self.manage_workers() /usr/local/lib/python2.7/site-packages/gunicorn/arbiter.py in manage_workers(544) self.spawn_workers() /usr/local/lib/python2.7/site-packages/gunicorn/arbiter.py in spawn_workers(611) self.spawn_worker() /usr/local/lib/python2.7/site-packages/gunicorn/arbiter.py in spawn_worker(578) worker.init_process() /usr/local/lib/python2.7/site-packages/gunicorn/workers/base.py in init_process(131) self.run() /usr/local/lib/python2.7/site-packages/gunicorn/workers/sync.py in run(124) self.run_for_one(timeout) /usr/local/lib/python2.7/site-packages/gunicorn/workers/sync.py in run_for_one(68) self.accept(listener) /usr/local/lib/python2.7/site-packages/gunicorn/workers/sync.py in accept(30) self.handle(listener, client, addr) /usr/local/lib/python2.7/site-packages/gunicorn/workers/sync.py in handle(135) self.handle_request(listener, req, client, addr) /usr/local/lib/python2.7/site-packages/gunicorn/workers/sync.py in handle_request(176) respiter = self.wsgi(environ, resp.start_response) /app/codalab/apps/web/views.py in get(127) return CompetitionDetailView.as_view()(*args, **kwargs) /app/codalab/apps/web/views.py in get(528) return super(CompetitionDetailView, self).get(request, *args, **kwargs) /app/codalab/apps/web/views.py in get_context_data(576) scores = context['active_phase'].scores() /app/codalab/apps/web/models.py in scores(1070) submissions = [entry.result for entry in qs] |
|||||||||||||||||||
+ |
SELECT ••• "web_competitionsubmission"."id", "web_competitionsubmission"."chahub_timestamp", "web_competitionsubmission"."chahub_data_hash", "web_competitionsubmission"."chahub_needs_retry", "web_competitionsubmission"."participant_id", "web_competitionsubmission"."phase_id", "web_competitionsubmission"."secret", "web_competitionsubmission"."docker_image", "web_competitionsubmission"."file", "web_competitionsubmission"."s3_file", "web_competitionsubmission"."file_url_base", "web_competitionsubmission"."readable_filename", "web_competitionsubmission"."description", "web_competitionsubmission"."inputfile", "web_competitionsubmission"."runfile", "web_competitionsubmission"."submitted_at", "web_competitionsubmission"."started_at", "web_competitionsubmission"."completed_at", "web_competitionsubmission"."execution_key", "web_competitionsubmission"."status_id", "web_competitionsubmission"."status_details", "web_competitionsubmission"."submission_number", "web_competitionsubmission"."output_file", "web_competitionsubmission"."private_output_file", "web_competitionsubmission"."stdout_file", "web_competitionsubmission"."stderr_file", "web_competitionsubmission"."history_file", "web_competitionsubmission"."scores_file", "web_competitionsubmission"."coopetition_file", "web_competitionsubmission"."detailed_results_file", "web_competitionsubmission"."docker_results_file", "web_competitionsubmission"."prediction_runfile", "web_competitionsubmission"."prediction_output_file", "web_competitionsubmission"."exception_details", "web_competitionsubmission"."prediction_stdout_file", "web_competitionsubmission"."prediction_stderr_file", "web_competitionsubmission"."ingestion_program_stdout_file", "web_competitionsubmission"."ingestion_program_stderr_file", "web_competitionsubmission"."method_name", "web_competitionsubmission"."method_description", "web_competitionsubmission"."project_url", "web_competitionsubmission"."publication_url", "web_competitionsubmission"."bibtex", "web_competitionsubmission"."organization_or_affiliation", "web_competitionsubmission"."team_name", "web_competitionsubmission"."is_public", "web_competitionsubmission"."when_made_public", "web_competitionsubmission"."when_unmade_public", "web_competitionsubmission"."download_count", "web_competitionsubmission"."like_count", "web_competitionsubmission"."dislike_count", "web_competitionsubmission"."is_migrated", "web_competitionsubmission"."team_id", "web_competitionsubmission"."queue_name" FROM "web_competitionsubmission" WHERE "web_competitionsubmission"."id" = 524
|
1.17809209871% |
0.54 | ||||||||||||||||
Connection: default /usr/local/bin/gunicorn in <module>(8) sys.exit(run()) /usr/local/lib/python2.7/site-packages/gunicorn/app/wsgiapp.py in run(74) WSGIApplication("%(prog)s [OPTIONS] [APP_MODULE]").run() /usr/local/lib/python2.7/site-packages/gunicorn/app/base.py in run(203) super(Application, self).run() /usr/local/lib/python2.7/site-packages/gunicorn/app/base.py in run(72) Arbiter(self).run() /usr/local/lib/python2.7/site-packages/gunicorn/arbiter.py in run(202) self.manage_workers() /usr/local/lib/python2.7/site-packages/gunicorn/arbiter.py in manage_workers(544) self.spawn_workers() /usr/local/lib/python2.7/site-packages/gunicorn/arbiter.py in spawn_workers(611) self.spawn_worker() /usr/local/lib/python2.7/site-packages/gunicorn/arbiter.py in spawn_worker(578) worker.init_process() /usr/local/lib/python2.7/site-packages/gunicorn/workers/base.py in init_process(131) self.run() /usr/local/lib/python2.7/site-packages/gunicorn/workers/sync.py in run(124) self.run_for_one(timeout) /usr/local/lib/python2.7/site-packages/gunicorn/workers/sync.py in run_for_one(68) self.accept(listener) /usr/local/lib/python2.7/site-packages/gunicorn/workers/sync.py in accept(30) self.handle(listener, client, addr) /usr/local/lib/python2.7/site-packages/gunicorn/workers/sync.py in handle(135) self.handle_request(listener, req, client, addr) /usr/local/lib/python2.7/site-packages/gunicorn/workers/sync.py in handle_request(176) respiter = self.wsgi(environ, resp.start_response) /app/codalab/apps/web/views.py in get(127) return CompetitionDetailView.as_view()(*args, **kwargs) /app/codalab/apps/web/views.py in get(528) return super(CompetitionDetailView, self).get(request, *args, **kwargs) /app/codalab/apps/web/views.py in get_context_data(576) scores = context['active_phase'].scores() /app/codalab/apps/web/models.py in scores(1070) submissions = [entry.result for entry in qs] |
|||||||||||||||||||
+ |
SELECT ••• "web_competitionsubmission"."id", "web_competitionsubmission"."chahub_timestamp", "web_competitionsubmission"."chahub_data_hash", "web_competitionsubmission"."chahub_needs_retry", "web_competitionsubmission"."participant_id", "web_competitionsubmission"."phase_id", "web_competitionsubmission"."secret", "web_competitionsubmission"."docker_image", "web_competitionsubmission"."file", "web_competitionsubmission"."s3_file", "web_competitionsubmission"."file_url_base", "web_competitionsubmission"."readable_filename", "web_competitionsubmission"."description", "web_competitionsubmission"."inputfile", "web_competitionsubmission"."runfile", "web_competitionsubmission"."submitted_at", "web_competitionsubmission"."started_at", "web_competitionsubmission"."completed_at", "web_competitionsubmission"."execution_key", "web_competitionsubmission"."status_id", "web_competitionsubmission"."status_details", "web_competitionsubmission"."submission_number", "web_competitionsubmission"."output_file", "web_competitionsubmission"."private_output_file", "web_competitionsubmission"."stdout_file", "web_competitionsubmission"."stderr_file", "web_competitionsubmission"."history_file", "web_competitionsubmission"."scores_file", "web_competitionsubmission"."coopetition_file", "web_competitionsubmission"."detailed_results_file", "web_competitionsubmission"."docker_results_file", "web_competitionsubmission"."prediction_runfile", "web_competitionsubmission"."prediction_output_file", "web_competitionsubmission"."exception_details", "web_competitionsubmission"."prediction_stdout_file", "web_competitionsubmission"."prediction_stderr_file", "web_competitionsubmission"."ingestion_program_stdout_file", "web_competitionsubmission"."ingestion_program_stderr_file", "web_competitionsubmission"."method_name", "web_competitionsubmission"."method_description", "web_competitionsubmission"."project_url", "web_competitionsubmission"."publication_url", "web_competitionsubmission"."bibtex", "web_competitionsubmission"."organization_or_affiliation", "web_competitionsubmission"."team_name", "web_competitionsubmission"."is_public", "web_competitionsubmission"."when_made_public", "web_competitionsubmission"."when_unmade_public", "web_competitionsubmission"."download_count", "web_competitionsubmission"."like_count", "web_competitionsubmission"."dislike_count", "web_competitionsubmission"."is_migrated", "web_competitionsubmission"."team_id", "web_competitionsubmission"."queue_name" FROM "web_competitionsubmission" WHERE "web_competitionsubmission"."id" = 527
|
1.20691552639% |
0.55 | ||||||||||||||||
Connection: default /usr/local/bin/gunicorn in <module>(8) sys.exit(run()) /usr/local/lib/python2.7/site-packages/gunicorn/app/wsgiapp.py in run(74) WSGIApplication("%(prog)s [OPTIONS] [APP_MODULE]").run() /usr/local/lib/python2.7/site-packages/gunicorn/app/base.py in run(203) super(Application, self).run() /usr/local/lib/python2.7/site-packages/gunicorn/app/base.py in run(72) Arbiter(self).run() /usr/local/lib/python2.7/site-packages/gunicorn/arbiter.py in run(202) self.manage_workers() /usr/local/lib/python2.7/site-packages/gunicorn/arbiter.py in manage_workers(544) self.spawn_workers() /usr/local/lib/python2.7/site-packages/gunicorn/arbiter.py in spawn_workers(611) self.spawn_worker() /usr/local/lib/python2.7/site-packages/gunicorn/arbiter.py in spawn_worker(578) worker.init_process() /usr/local/lib/python2.7/site-packages/gunicorn/workers/base.py in init_process(131) self.run() /usr/local/lib/python2.7/site-packages/gunicorn/workers/sync.py in run(124) self.run_for_one(timeout) /usr/local/lib/python2.7/site-packages/gunicorn/workers/sync.py in run_for_one(68) self.accept(listener) /usr/local/lib/python2.7/site-packages/gunicorn/workers/sync.py in accept(30) self.handle(listener, client, addr) /usr/local/lib/python2.7/site-packages/gunicorn/workers/sync.py in handle(135) self.handle_request(listener, req, client, addr) /usr/local/lib/python2.7/site-packages/gunicorn/workers/sync.py in handle_request(176) respiter = self.wsgi(environ, resp.start_response) /app/codalab/apps/web/views.py in get(127) return CompetitionDetailView.as_view()(*args, **kwargs) /app/codalab/apps/web/views.py in get(528) return super(CompetitionDetailView, self).get(request, *args, **kwargs) /app/codalab/apps/web/views.py in get_context_data(576) scores = context['active_phase'].scores() /app/codalab/apps/web/models.py in scores(1070) submissions = [entry.result for entry in qs] |
|||||||||||||||||||
+ |
SELECT ••• "web_competitionsubmission"."id", "web_competitionsubmission"."chahub_timestamp", "web_competitionsubmission"."chahub_data_hash", "web_competitionsubmission"."chahub_needs_retry", "web_competitionsubmission"."participant_id", "web_competitionsubmission"."phase_id", "web_competitionsubmission"."secret", "web_competitionsubmission"."docker_image", "web_competitionsubmission"."file", "web_competitionsubmission"."s3_file", "web_competitionsubmission"."file_url_base", "web_competitionsubmission"."readable_filename", "web_competitionsubmission"."description", "web_competitionsubmission"."inputfile", "web_competitionsubmission"."runfile", "web_competitionsubmission"."submitted_at", "web_competitionsubmission"."started_at", "web_competitionsubmission"."completed_at", "web_competitionsubmission"."execution_key", "web_competitionsubmission"."status_id", "web_competitionsubmission"."status_details", "web_competitionsubmission"."submission_number", "web_competitionsubmission"."output_file", "web_competitionsubmission"."private_output_file", "web_competitionsubmission"."stdout_file", "web_competitionsubmission"."stderr_file", "web_competitionsubmission"."history_file", "web_competitionsubmission"."scores_file", "web_competitionsubmission"."coopetition_file", "web_competitionsubmission"."detailed_results_file", "web_competitionsubmission"."docker_results_file", "web_competitionsubmission"."prediction_runfile", "web_competitionsubmission"."prediction_output_file", "web_competitionsubmission"."exception_details", "web_competitionsubmission"."prediction_stdout_file", "web_competitionsubmission"."prediction_stderr_file", "web_competitionsubmission"."ingestion_program_stdout_file", "web_competitionsubmission"."ingestion_program_stderr_file", "web_competitionsubmission"."method_name", "web_competitionsubmission"."method_description", "web_competitionsubmission"."project_url", "web_competitionsubmission"."publication_url", "web_competitionsubmission"."bibtex", "web_competitionsubmission"."organization_or_affiliation", "web_competitionsubmission"."team_name", "web_competitionsubmission"."is_public", "web_competitionsubmission"."when_made_public", "web_competitionsubmission"."when_unmade_public", "web_competitionsubmission"."download_count", "web_competitionsubmission"."like_count", "web_competitionsubmission"."dislike_count", "web_competitionsubmission"."is_migrated", "web_competitionsubmission"."team_id", "web_competitionsubmission"."queue_name" FROM "web_competitionsubmission" WHERE "web_competitionsubmission"."id" = 531
|
1.32744986034% |
0.60 | ||||||||||||||||
Connection: default /usr/local/bin/gunicorn in <module>(8) sys.exit(run()) /usr/local/lib/python2.7/site-packages/gunicorn/app/wsgiapp.py in run(74) WSGIApplication("%(prog)s [OPTIONS] [APP_MODULE]").run() /usr/local/lib/python2.7/site-packages/gunicorn/app/base.py in run(203) super(Application, self).run() /usr/local/lib/python2.7/site-packages/gunicorn/app/base.py in run(72) Arbiter(self).run() /usr/local/lib/python2.7/site-packages/gunicorn/arbiter.py in run(202) self.manage_workers() /usr/local/lib/python2.7/site-packages/gunicorn/arbiter.py in manage_workers(544) self.spawn_workers() /usr/local/lib/python2.7/site-packages/gunicorn/arbiter.py in spawn_workers(611) self.spawn_worker() /usr/local/lib/python2.7/site-packages/gunicorn/arbiter.py in spawn_worker(578) worker.init_process() /usr/local/lib/python2.7/site-packages/gunicorn/workers/base.py in init_process(131) self.run() /usr/local/lib/python2.7/site-packages/gunicorn/workers/sync.py in run(124) self.run_for_one(timeout) /usr/local/lib/python2.7/site-packages/gunicorn/workers/sync.py in run_for_one(68) self.accept(listener) /usr/local/lib/python2.7/site-packages/gunicorn/workers/sync.py in accept(30) self.handle(listener, client, addr) /usr/local/lib/python2.7/site-packages/gunicorn/workers/sync.py in handle(135) self.handle_request(listener, req, client, addr) /usr/local/lib/python2.7/site-packages/gunicorn/workers/sync.py in handle_request(176) respiter = self.wsgi(environ, resp.start_response) /app/codalab/apps/web/views.py in get(127) return CompetitionDetailView.as_view()(*args, **kwargs) /app/codalab/apps/web/views.py in get(528) return super(CompetitionDetailView, self).get(request, *args, **kwargs) /app/codalab/apps/web/views.py in get_context_data(576) scores = context['active_phase'].scores() /app/codalab/apps/web/models.py in scores(1070) submissions = [entry.result for entry in qs] |
|||||||||||||||||||
+ |
SELECT ••• "web_competitionsubmission"."id", "web_competitionsubmission"."chahub_timestamp", "web_competitionsubmission"."chahub_data_hash", "web_competitionsubmission"."chahub_needs_retry", "web_competitionsubmission"."participant_id", "web_competitionsubmission"."phase_id", "web_competitionsubmission"."secret", "web_competitionsubmission"."docker_image", "web_competitionsubmission"."file", "web_competitionsubmission"."s3_file", "web_competitionsubmission"."file_url_base", "web_competitionsubmission"."readable_filename", "web_competitionsubmission"."description", "web_competitionsubmission"."inputfile", "web_competitionsubmission"."runfile", "web_competitionsubmission"."submitted_at", "web_competitionsubmission"."started_at", "web_competitionsubmission"."completed_at", "web_competitionsubmission"."execution_key", "web_competitionsubmission"."status_id", "web_competitionsubmission"."status_details", "web_competitionsubmission"."submission_number", "web_competitionsubmission"."output_file", "web_competitionsubmission"."private_output_file", "web_competitionsubmission"."stdout_file", "web_competitionsubmission"."stderr_file", "web_competitionsubmission"."history_file", "web_competitionsubmission"."scores_file", "web_competitionsubmission"."coopetition_file", "web_competitionsubmission"."detailed_results_file", "web_competitionsubmission"."docker_results_file", "web_competitionsubmission"."prediction_runfile", "web_competitionsubmission"."prediction_output_file", "web_competitionsubmission"."exception_details", "web_competitionsubmission"."prediction_stdout_file", "web_competitionsubmission"."prediction_stderr_file", "web_competitionsubmission"."ingestion_program_stdout_file", "web_competitionsubmission"."ingestion_program_stderr_file", "web_competitionsubmission"."method_name", "web_competitionsubmission"."method_description", "web_competitionsubmission"."project_url", "web_competitionsubmission"."publication_url", "web_competitionsubmission"."bibtex", "web_competitionsubmission"."organization_or_affiliation", "web_competitionsubmission"."team_name", "web_competitionsubmission"."is_public", "web_competitionsubmission"."when_made_public", "web_competitionsubmission"."when_unmade_public", "web_competitionsubmission"."download_count", "web_competitionsubmission"."like_count", "web_competitionsubmission"."dislike_count", "web_competitionsubmission"."is_migrated", "web_competitionsubmission"."team_id", "web_competitionsubmission"."queue_name" FROM "web_competitionsubmission" WHERE "web_competitionsubmission"."id" = 533
|
1.08585713013% |
0.49 | ||||||||||||||||
Connection: default /usr/local/bin/gunicorn in <module>(8) sys.exit(run()) /usr/local/lib/python2.7/site-packages/gunicorn/app/wsgiapp.py in run(74) WSGIApplication("%(prog)s [OPTIONS] [APP_MODULE]").run() /usr/local/lib/python2.7/site-packages/gunicorn/app/base.py in run(203) super(Application, self).run() /usr/local/lib/python2.7/site-packages/gunicorn/app/base.py in run(72) Arbiter(self).run() /usr/local/lib/python2.7/site-packages/gunicorn/arbiter.py in run(202) self.manage_workers() /usr/local/lib/python2.7/site-packages/gunicorn/arbiter.py in manage_workers(544) self.spawn_workers() /usr/local/lib/python2.7/site-packages/gunicorn/arbiter.py in spawn_workers(611) self.spawn_worker() /usr/local/lib/python2.7/site-packages/gunicorn/arbiter.py in spawn_worker(578) worker.init_process() /usr/local/lib/python2.7/site-packages/gunicorn/workers/base.py in init_process(131) self.run() /usr/local/lib/python2.7/site-packages/gunicorn/workers/sync.py in run(124) self.run_for_one(timeout) /usr/local/lib/python2.7/site-packages/gunicorn/workers/sync.py in run_for_one(68) self.accept(listener) /usr/local/lib/python2.7/site-packages/gunicorn/workers/sync.py in accept(30) self.handle(listener, client, addr) /usr/local/lib/python2.7/site-packages/gunicorn/workers/sync.py in handle(135) self.handle_request(listener, req, client, addr) /usr/local/lib/python2.7/site-packages/gunicorn/workers/sync.py in handle_request(176) respiter = self.wsgi(environ, resp.start_response) /app/codalab/apps/web/views.py in get(127) return CompetitionDetailView.as_view()(*args, **kwargs) /app/codalab/apps/web/views.py in get(528) return super(CompetitionDetailView, self).get(request, *args, **kwargs) /app/codalab/apps/web/views.py in get_context_data(576) scores = context['active_phase'].scores() /app/codalab/apps/web/models.py in scores(1070) submissions = [entry.result for entry in qs] |
|||||||||||||||||||
+ |
SELECT ••• "web_submissionresultgroup"."id", "web_submissionresultgroup"."competition_id", "web_submissionresultgroup"."key", "web_submissionresultgroup"."label", "web_submissionresultgroup"."ordering" FROM "web_submissionresultgroup" INNER JOIN "web_submissionresultgroupphase" ON ( "web_submissionresultgroup"."id" = "web_submissionresultgroupphase"."group_id" ) WHERE "web_submissionresultgroupphase"."phase_id" IN (18) ORDER BY "web_submissionresultgroup"."ordering" ASC
|
1.67699942877% |
0.76 | ||||||||||||||||
Connection: default /usr/local/bin/gunicorn in <module>(8) sys.exit(run()) /usr/local/lib/python2.7/site-packages/gunicorn/app/wsgiapp.py in run(74) WSGIApplication("%(prog)s [OPTIONS] [APP_MODULE]").run() /usr/local/lib/python2.7/site-packages/gunicorn/app/base.py in run(203) super(Application, self).run() /usr/local/lib/python2.7/site-packages/gunicorn/app/base.py in run(72) Arbiter(self).run() /usr/local/lib/python2.7/site-packages/gunicorn/arbiter.py in run(202) self.manage_workers() /usr/local/lib/python2.7/site-packages/gunicorn/arbiter.py in manage_workers(544) self.spawn_workers() /usr/local/lib/python2.7/site-packages/gunicorn/arbiter.py in spawn_workers(611) self.spawn_worker() /usr/local/lib/python2.7/site-packages/gunicorn/arbiter.py in spawn_worker(578) worker.init_process() /usr/local/lib/python2.7/site-packages/gunicorn/workers/base.py in init_process(131) self.run() /usr/local/lib/python2.7/site-packages/gunicorn/workers/sync.py in run(124) self.run_for_one(timeout) /usr/local/lib/python2.7/site-packages/gunicorn/workers/sync.py in run_for_one(68) self.accept(listener) /usr/local/lib/python2.7/site-packages/gunicorn/workers/sync.py in accept(30) self.handle(listener, client, addr) /usr/local/lib/python2.7/site-packages/gunicorn/workers/sync.py in handle(135) self.handle_request(listener, req, client, addr) /usr/local/lib/python2.7/site-packages/gunicorn/workers/sync.py in handle_request(176) respiter = self.wsgi(environ, resp.start_response) /app/codalab/apps/web/views.py in get(127) return CompetitionDetailView.as_view()(*args, **kwargs) /app/codalab/apps/web/views.py in get(528) return super(CompetitionDetailView, self).get(request, *args, **kwargs) /app/codalab/apps/web/views.py in get_context_data(576) scores = context['active_phase'].scores() /app/codalab/apps/web/models.py in scores(1075) for count, g in enumerate(SubmissionResultGroup.objects.filter(phases__in=[self]).order_by('ordering')): |
|||||||||||||||||||
+ |
SELECT ••• "web_competitionparticipant"."id", "web_competitionparticipant"."user_id", "web_competitionparticipant"."competition_id", "web_competitionparticipant"."status_id", "web_competitionparticipant"."reason", "web_competitionparticipant"."trained_models_shared", "web_competitionparticipant"."deleted" FROM "web_competitionparticipant" WHERE "web_competitionparticipant"."id" = 88
|
0.92759030904% |
0.42 | ||||||||||||||||
Connection: default /usr/local/bin/gunicorn in <module>(8) sys.exit(run()) /usr/local/lib/python2.7/site-packages/gunicorn/app/wsgiapp.py in run(74) WSGIApplication("%(prog)s [OPTIONS] [APP_MODULE]").run() /usr/local/lib/python2.7/site-packages/gunicorn/app/base.py in run(203) super(Application, self).run() /usr/local/lib/python2.7/site-packages/gunicorn/app/base.py in run(72) Arbiter(self).run() /usr/local/lib/python2.7/site-packages/gunicorn/arbiter.py in run(202) self.manage_workers() /usr/local/lib/python2.7/site-packages/gunicorn/arbiter.py in manage_workers(544) self.spawn_workers() /usr/local/lib/python2.7/site-packages/gunicorn/arbiter.py in spawn_workers(611) self.spawn_worker() /usr/local/lib/python2.7/site-packages/gunicorn/arbiter.py in spawn_worker(578) worker.init_process() /usr/local/lib/python2.7/site-packages/gunicorn/workers/base.py in init_process(131) self.run() /usr/local/lib/python2.7/site-packages/gunicorn/workers/sync.py in run(124) self.run_for_one(timeout) /usr/local/lib/python2.7/site-packages/gunicorn/workers/sync.py in run_for_one(68) self.accept(listener) /usr/local/lib/python2.7/site-packages/gunicorn/workers/sync.py in accept(30) self.handle(listener, client, addr) /usr/local/lib/python2.7/site-packages/gunicorn/workers/sync.py in handle(135) self.handle_request(listener, req, client, addr) /usr/local/lib/python2.7/site-packages/gunicorn/workers/sync.py in handle_request(176) respiter = self.wsgi(environ, resp.start_response) /app/codalab/apps/web/views.py in get(127) return CompetitionDetailView.as_view()(*args, **kwargs) /app/codalab/apps/web/views.py in get(528) return super(CompetitionDetailView, self).get(request, *args, **kwargs) /app/codalab/apps/web/views.py in get_context_data(576) scores = context['active_phase'].scores() /app/codalab/apps/web/models.py in scores(1082) user = submission.participant.user |
|||||||||||||||||||
+ |
SELECT ••• "authenz_cluser"."id", "authenz_cluser"."password", "authenz_cluser"."last_login", "authenz_cluser"."is_superuser", "authenz_cluser"."username", "authenz_cluser"."first_name", "authenz_cluser"."last_name", "authenz_cluser"."email", "authenz_cluser"."is_staff", "authenz_cluser"."is_active", "authenz_cluser"."date_joined", "authenz_cluser"."chahub_timestamp", "authenz_cluser"."chahub_data_hash", "authenz_cluser"."chahub_needs_retry", "authenz_cluser"."participation_status_updates", "authenz_cluser"."organizer_status_updates", "authenz_cluser"."organizer_direct_message_updates", "authenz_cluser"."email_on_submission_finished_successfully", "authenz_cluser"."allow_forum_notifications", "authenz_cluser"."allow_admin_status_updates", "authenz_cluser"."newsletter_opt_in", "authenz_cluser"."organization_or_affiliation", "authenz_cluser"."team_name", "authenz_cluser"."team_members", "authenz_cluser"."method_name", "authenz_cluser"."method_description", "authenz_cluser"."project_url", "authenz_cluser"."publication_url", "authenz_cluser"."bibtex", "authenz_cluser"."contact_email", "authenz_cluser"."rabbitmq_queue_limit", "authenz_cluser"."rabbitmq_username", "authenz_cluser"."rabbitmq_password" FROM "authenz_cluser" WHERE "authenz_cluser"."id" = 6
|
1.05755776477% |
0.48 | ||||||||||||||||
Connection: default /usr/local/bin/gunicorn in <module>(8) sys.exit(run()) /usr/local/lib/python2.7/site-packages/gunicorn/app/wsgiapp.py in run(74) WSGIApplication("%(prog)s [OPTIONS] [APP_MODULE]").run() /usr/local/lib/python2.7/site-packages/gunicorn/app/base.py in run(203) super(Application, self).run() /usr/local/lib/python2.7/site-packages/gunicorn/app/base.py in run(72) Arbiter(self).run() /usr/local/lib/python2.7/site-packages/gunicorn/arbiter.py in run(202) self.manage_workers() /usr/local/lib/python2.7/site-packages/gunicorn/arbiter.py in manage_workers(544) self.spawn_workers() /usr/local/lib/python2.7/site-packages/gunicorn/arbiter.py in spawn_workers(611) self.spawn_worker() /usr/local/lib/python2.7/site-packages/gunicorn/arbiter.py in spawn_worker(578) worker.init_process() /usr/local/lib/python2.7/site-packages/gunicorn/workers/base.py in init_process(131) self.run() /usr/local/lib/python2.7/site-packages/gunicorn/workers/sync.py in run(124) self.run_for_one(timeout) /usr/local/lib/python2.7/site-packages/gunicorn/workers/sync.py in run_for_one(68) self.accept(listener) /usr/local/lib/python2.7/site-packages/gunicorn/workers/sync.py in accept(30) self.handle(listener, client, addr) /usr/local/lib/python2.7/site-packages/gunicorn/workers/sync.py in handle(135) self.handle_request(listener, req, client, addr) /usr/local/lib/python2.7/site-packages/gunicorn/workers/sync.py in handle_request(176) respiter = self.wsgi(environ, resp.start_response) /app/codalab/apps/web/views.py in get(127) return CompetitionDetailView.as_view()(*args, **kwargs) /app/codalab/apps/web/views.py in get(528) return super(CompetitionDetailView, self).get(request, *args, **kwargs) /app/codalab/apps/web/views.py in get_context_data(576) scores = context['active_phase'].scores() /app/codalab/apps/web/models.py in scores(1082) user = submission.participant.user |
|||||||||||||||||||
+ |
SELECT ••• "teams_teammembership"."id", "teams_teammembership"."user_id", "teams_teammembership"."team_id", "teams_teammembership"."is_invitation", "teams_teammembership"."is_request", "teams_teammembership"."start_date", "teams_teammembership"."end_date", "teams_teammembership"."message", "teams_teammembership"."status_id", "teams_teammembership"."reason" FROM "teams_teammembership" INNER JOIN "teams_teammembershipstatus" ON ( "teams_teammembership"."status_id" = "teams_teammembershipstatus"."id" ) INNER JOIN "teams_team" ON ( "teams_teammembership"."team_id" = "teams_team"."id" ) WHERE ("teams_teammembershipstatus"."codename" = 'approved' AND "teams_team"."competition_id" = 9 AND "teams_teammembership"."user_id" = 6 )
|
3.49287537274% |
1.59 | ||||||||||||||||
Connection: default /usr/local/bin/gunicorn in <module>(8) sys.exit(run()) /usr/local/lib/python2.7/site-packages/gunicorn/app/wsgiapp.py in run(74) WSGIApplication("%(prog)s [OPTIONS] [APP_MODULE]").run() /usr/local/lib/python2.7/site-packages/gunicorn/app/base.py in run(203) super(Application, self).run() /usr/local/lib/python2.7/site-packages/gunicorn/app/base.py in run(72) Arbiter(self).run() /usr/local/lib/python2.7/site-packages/gunicorn/arbiter.py in run(202) self.manage_workers() /usr/local/lib/python2.7/site-packages/gunicorn/arbiter.py in manage_workers(544) self.spawn_workers() /usr/local/lib/python2.7/site-packages/gunicorn/arbiter.py in spawn_workers(611) self.spawn_worker() /usr/local/lib/python2.7/site-packages/gunicorn/arbiter.py in spawn_worker(578) worker.init_process() /usr/local/lib/python2.7/site-packages/gunicorn/workers/base.py in init_process(131) self.run() /usr/local/lib/python2.7/site-packages/gunicorn/workers/sync.py in run(124) self.run_for_one(timeout) /usr/local/lib/python2.7/site-packages/gunicorn/workers/sync.py in run_for_one(68) self.accept(listener) /usr/local/lib/python2.7/site-packages/gunicorn/workers/sync.py in accept(30) self.handle(listener, client, addr) /usr/local/lib/python2.7/site-packages/gunicorn/workers/sync.py in handle(135) self.handle_request(listener, req, client, addr) /usr/local/lib/python2.7/site-packages/gunicorn/workers/sync.py in handle_request(176) respiter = self.wsgi(environ, resp.start_response) /app/codalab/apps/web/views.py in get(127) return CompetitionDetailView.as_view()(*args, **kwargs) /app/codalab/apps/web/views.py in get(528) return super(CompetitionDetailView, self).get(request, *args, **kwargs) /app/codalab/apps/web/views.py in get_context_data(576) scores = context['active_phase'].scores() /app/codalab/apps/web/models.py in scores(1087) team__competition=self.competition |
|||||||||||||||||||
+ |
SELECT ••• "web_competitionparticipant"."id", "web_competitionparticipant"."user_id", "web_competitionparticipant"."competition_id", "web_competitionparticipant"."status_id", "web_competitionparticipant"."reason", "web_competitionparticipant"."trained_models_shared", "web_competitionparticipant"."deleted" FROM "web_competitionparticipant" WHERE "web_competitionparticipant"."id" = 78
|
0.802339414203% |
0.37 | ||||||||||||||||
Connection: default /usr/local/bin/gunicorn in <module>(8) sys.exit(run()) /usr/local/lib/python2.7/site-packages/gunicorn/app/wsgiapp.py in run(74) WSGIApplication("%(prog)s [OPTIONS] [APP_MODULE]").run() /usr/local/lib/python2.7/site-packages/gunicorn/app/base.py in run(203) super(Application, self).run() /usr/local/lib/python2.7/site-packages/gunicorn/app/base.py in run(72) Arbiter(self).run() /usr/local/lib/python2.7/site-packages/gunicorn/arbiter.py in run(202) self.manage_workers() /usr/local/lib/python2.7/site-packages/gunicorn/arbiter.py in manage_workers(544) self.spawn_workers() /usr/local/lib/python2.7/site-packages/gunicorn/arbiter.py in spawn_workers(611) self.spawn_worker() /usr/local/lib/python2.7/site-packages/gunicorn/arbiter.py in spawn_worker(578) worker.init_process() /usr/local/lib/python2.7/site-packages/gunicorn/workers/base.py in init_process(131) self.run() /usr/local/lib/python2.7/site-packages/gunicorn/workers/sync.py in run(124) self.run_for_one(timeout) /usr/local/lib/python2.7/site-packages/gunicorn/workers/sync.py in run_for_one(68) self.accept(listener) /usr/local/lib/python2.7/site-packages/gunicorn/workers/sync.py in accept(30) self.handle(listener, client, addr) /usr/local/lib/python2.7/site-packages/gunicorn/workers/sync.py in handle(135) self.handle_request(listener, req, client, addr) /usr/local/lib/python2.7/site-packages/gunicorn/workers/sync.py in handle_request(176) respiter = self.wsgi(environ, resp.start_response) /app/codalab/apps/web/views.py in get(127) return CompetitionDetailView.as_view()(*args, **kwargs) /app/codalab/apps/web/views.py in get(528) return super(CompetitionDetailView, self).get(request, *args, **kwargs) /app/codalab/apps/web/views.py in get_context_data(576) scores = context['active_phase'].scores() /app/codalab/apps/web/models.py in scores(1082) user = submission.participant.user |
|||||||||||||||||||
+ |
SELECT ••• "authenz_cluser"."id", "authenz_cluser"."password", "authenz_cluser"."last_login", "authenz_cluser"."is_superuser", "authenz_cluser"."username", "authenz_cluser"."first_name", "authenz_cluser"."last_name", "authenz_cluser"."email", "authenz_cluser"."is_staff", "authenz_cluser"."is_active", "authenz_cluser"."date_joined", "authenz_cluser"."chahub_timestamp", "authenz_cluser"."chahub_data_hash", "authenz_cluser"."chahub_needs_retry", "authenz_cluser"."participation_status_updates", "authenz_cluser"."organizer_status_updates", "authenz_cluser"."organizer_direct_message_updates", "authenz_cluser"."email_on_submission_finished_successfully", "authenz_cluser"."allow_forum_notifications", "authenz_cluser"."allow_admin_status_updates", "authenz_cluser"."newsletter_opt_in", "authenz_cluser"."organization_or_affiliation", "authenz_cluser"."team_name", "authenz_cluser"."team_members", "authenz_cluser"."method_name", "authenz_cluser"."method_description", "authenz_cluser"."project_url", "authenz_cluser"."publication_url", "authenz_cluser"."bibtex", "authenz_cluser"."contact_email", "authenz_cluser"."rabbitmq_queue_limit", "authenz_cluser"."rabbitmq_username", "authenz_cluser"."rabbitmq_password" FROM "authenz_cluser" WHERE "authenz_cluser"."id" = 2
|
1.07065932281% |
0.49 | ||||||||||||||||
Connection: default /usr/local/bin/gunicorn in <module>(8) sys.exit(run()) /usr/local/lib/python2.7/site-packages/gunicorn/app/wsgiapp.py in run(74) WSGIApplication("%(prog)s [OPTIONS] [APP_MODULE]").run() /usr/local/lib/python2.7/site-packages/gunicorn/app/base.py in run(203) super(Application, self).run() /usr/local/lib/python2.7/site-packages/gunicorn/app/base.py in run(72) Arbiter(self).run() /usr/local/lib/python2.7/site-packages/gunicorn/arbiter.py in run(202) self.manage_workers() /usr/local/lib/python2.7/site-packages/gunicorn/arbiter.py in manage_workers(544) self.spawn_workers() /usr/local/lib/python2.7/site-packages/gunicorn/arbiter.py in spawn_workers(611) self.spawn_worker() /usr/local/lib/python2.7/site-packages/gunicorn/arbiter.py in spawn_worker(578) worker.init_process() /usr/local/lib/python2.7/site-packages/gunicorn/workers/base.py in init_process(131) self.run() /usr/local/lib/python2.7/site-packages/gunicorn/workers/sync.py in run(124) self.run_for_one(timeout) /usr/local/lib/python2.7/site-packages/gunicorn/workers/sync.py in run_for_one(68) self.accept(listener) /usr/local/lib/python2.7/site-packages/gunicorn/workers/sync.py in accept(30) self.handle(listener, client, addr) /usr/local/lib/python2.7/site-packages/gunicorn/workers/sync.py in handle(135) self.handle_request(listener, req, client, addr) /usr/local/lib/python2.7/site-packages/gunicorn/workers/sync.py in handle_request(176) respiter = self.wsgi(environ, resp.start_response) /app/codalab/apps/web/views.py in get(127) return CompetitionDetailView.as_view()(*args, **kwargs) /app/codalab/apps/web/views.py in get(528) return super(CompetitionDetailView, self).get(request, *args, **kwargs) /app/codalab/apps/web/views.py in get_context_data(576) scores = context['active_phase'].scores() /app/codalab/apps/web/models.py in scores(1082) user = submission.participant.user |
|||||||||||||||||||
+ |
SELECT ••• "teams_teammembership"."id", "teams_teammembership"."user_id", "teams_teammembership"."team_id", "teams_teammembership"."is_invitation", "teams_teammembership"."is_request", "teams_teammembership"."start_date", "teams_teammembership"."end_date", "teams_teammembership"."message", "teams_teammembership"."status_id", "teams_teammembership"."reason" FROM "teams_teammembership" INNER JOIN "teams_teammembershipstatus" ON ( "teams_teammembership"."status_id" = "teams_teammembershipstatus"."id" ) INNER JOIN "teams_team" ON ( "teams_teammembership"."team_id" = "teams_team"."id" ) WHERE ("teams_teammembershipstatus"."codename" = 'approved' AND "teams_team"."competition_id" = 9 AND "teams_teammembership"."user_id" = 2 )
|
1.24412395122% |
0.57 | ||||||||||||||||
Connection: default /usr/local/bin/gunicorn in <module>(8) sys.exit(run()) /usr/local/lib/python2.7/site-packages/gunicorn/app/wsgiapp.py in run(74) WSGIApplication("%(prog)s [OPTIONS] [APP_MODULE]").run() /usr/local/lib/python2.7/site-packages/gunicorn/app/base.py in run(203) super(Application, self).run() /usr/local/lib/python2.7/site-packages/gunicorn/app/base.py in run(72) Arbiter(self).run() /usr/local/lib/python2.7/site-packages/gunicorn/arbiter.py in run(202) self.manage_workers() /usr/local/lib/python2.7/site-packages/gunicorn/arbiter.py in manage_workers(544) self.spawn_workers() /usr/local/lib/python2.7/site-packages/gunicorn/arbiter.py in spawn_workers(611) self.spawn_worker() /usr/local/lib/python2.7/site-packages/gunicorn/arbiter.py in spawn_worker(578) worker.init_process() /usr/local/lib/python2.7/site-packages/gunicorn/workers/base.py in init_process(131) self.run() /usr/local/lib/python2.7/site-packages/gunicorn/workers/sync.py in run(124) self.run_for_one(timeout) /usr/local/lib/python2.7/site-packages/gunicorn/workers/sync.py in run_for_one(68) self.accept(listener) /usr/local/lib/python2.7/site-packages/gunicorn/workers/sync.py in accept(30) self.handle(listener, client, addr) /usr/local/lib/python2.7/site-packages/gunicorn/workers/sync.py in handle(135) self.handle_request(listener, req, client, addr) /usr/local/lib/python2.7/site-packages/gunicorn/workers/sync.py in handle_request(176) respiter = self.wsgi(environ, resp.start_response) /app/codalab/apps/web/views.py in get(127) return CompetitionDetailView.as_view()(*args, **kwargs) /app/codalab/apps/web/views.py in get(528) return super(CompetitionDetailView, self).get(request, *args, **kwargs) /app/codalab/apps/web/views.py in get_context_data(576) scores = context['active_phase'].scores() /app/codalab/apps/web/models.py in scores(1087) team__competition=self.competition |
|||||||||||||||||||
+ |
SELECT ••• "web_competitionparticipant"."id", "web_competitionparticipant"."user_id", "web_competitionparticipant"."competition_id", "web_competitionparticipant"."status_id", "web_competitionparticipant"."reason", "web_competitionparticipant"."trained_models_shared", "web_competitionparticipant"."deleted" FROM "web_competitionparticipant" WHERE "web_competitionparticipant"."id" = 84
|
0.663986961329% |
0.30 | ||||||||||||||||
Connection: default /usr/local/bin/gunicorn in <module>(8) sys.exit(run()) /usr/local/lib/python2.7/site-packages/gunicorn/app/wsgiapp.py in run(74) WSGIApplication("%(prog)s [OPTIONS] [APP_MODULE]").run() /usr/local/lib/python2.7/site-packages/gunicorn/app/base.py in run(203) super(Application, self).run() /usr/local/lib/python2.7/site-packages/gunicorn/app/base.py in run(72) Arbiter(self).run() /usr/local/lib/python2.7/site-packages/gunicorn/arbiter.py in run(202) self.manage_workers() /usr/local/lib/python2.7/site-packages/gunicorn/arbiter.py in manage_workers(544) self.spawn_workers() /usr/local/lib/python2.7/site-packages/gunicorn/arbiter.py in spawn_workers(611) self.spawn_worker() /usr/local/lib/python2.7/site-packages/gunicorn/arbiter.py in spawn_worker(578) worker.init_process() /usr/local/lib/python2.7/site-packages/gunicorn/workers/base.py in init_process(131) self.run() /usr/local/lib/python2.7/site-packages/gunicorn/workers/sync.py in run(124) self.run_for_one(timeout) /usr/local/lib/python2.7/site-packages/gunicorn/workers/sync.py in run_for_one(68) self.accept(listener) /usr/local/lib/python2.7/site-packages/gunicorn/workers/sync.py in accept(30) self.handle(listener, client, addr) /usr/local/lib/python2.7/site-packages/gunicorn/workers/sync.py in handle(135) self.handle_request(listener, req, client, addr) /usr/local/lib/python2.7/site-packages/gunicorn/workers/sync.py in handle_request(176) respiter = self.wsgi(environ, resp.start_response) /app/codalab/apps/web/views.py in get(127) return CompetitionDetailView.as_view()(*args, **kwargs) /app/codalab/apps/web/views.py in get(528) return super(CompetitionDetailView, self).get(request, *args, **kwargs) /app/codalab/apps/web/views.py in get_context_data(576) scores = context['active_phase'].scores() /app/codalab/apps/web/models.py in scores(1082) user = submission.participant.user |
|||||||||||||||||||
+ |
SELECT ••• "authenz_cluser"."id", "authenz_cluser"."password", "authenz_cluser"."last_login", "authenz_cluser"."is_superuser", "authenz_cluser"."username", "authenz_cluser"."first_name", "authenz_cluser"."last_name", "authenz_cluser"."email", "authenz_cluser"."is_staff", "authenz_cluser"."is_active", "authenz_cluser"."date_joined", "authenz_cluser"."chahub_timestamp", "authenz_cluser"."chahub_data_hash", "authenz_cluser"."chahub_needs_retry", "authenz_cluser"."participation_status_updates", "authenz_cluser"."organizer_status_updates", "authenz_cluser"."organizer_direct_message_updates", "authenz_cluser"."email_on_submission_finished_successfully", "authenz_cluser"."allow_forum_notifications", "authenz_cluser"."allow_admin_status_updates", "authenz_cluser"."newsletter_opt_in", "authenz_cluser"."organization_or_affiliation", "authenz_cluser"."team_name", "authenz_cluser"."team_members", "authenz_cluser"."method_name", "authenz_cluser"."method_description", "authenz_cluser"."project_url", "authenz_cluser"."publication_url", "authenz_cluser"."bibtex", "authenz_cluser"."contact_email", "authenz_cluser"."rabbitmq_queue_limit", "authenz_cluser"."rabbitmq_username", "authenz_cluser"."rabbitmq_password" FROM "authenz_cluser" WHERE "authenz_cluser"."id" = 75
|
1.05755776477% |
0.48 | ||||||||||||||||
Connection: default /usr/local/bin/gunicorn in <module>(8) sys.exit(run()) /usr/local/lib/python2.7/site-packages/gunicorn/app/wsgiapp.py in run(74) WSGIApplication("%(prog)s [OPTIONS] [APP_MODULE]").run() /usr/local/lib/python2.7/site-packages/gunicorn/app/base.py in run(203) super(Application, self).run() /usr/local/lib/python2.7/site-packages/gunicorn/app/base.py in run(72) Arbiter(self).run() /usr/local/lib/python2.7/site-packages/gunicorn/arbiter.py in run(202) self.manage_workers() /usr/local/lib/python2.7/site-packages/gunicorn/arbiter.py in manage_workers(544) self.spawn_workers() /usr/local/lib/python2.7/site-packages/gunicorn/arbiter.py in spawn_workers(611) self.spawn_worker() /usr/local/lib/python2.7/site-packages/gunicorn/arbiter.py in spawn_worker(578) worker.init_process() /usr/local/lib/python2.7/site-packages/gunicorn/workers/base.py in init_process(131) self.run() /usr/local/lib/python2.7/site-packages/gunicorn/workers/sync.py in run(124) self.run_for_one(timeout) /usr/local/lib/python2.7/site-packages/gunicorn/workers/sync.py in run_for_one(68) self.accept(listener) /usr/local/lib/python2.7/site-packages/gunicorn/workers/sync.py in accept(30) self.handle(listener, client, addr) /usr/local/lib/python2.7/site-packages/gunicorn/workers/sync.py in handle(135) self.handle_request(listener, req, client, addr) /usr/local/lib/python2.7/site-packages/gunicorn/workers/sync.py in handle_request(176) respiter = self.wsgi(environ, resp.start_response) /app/codalab/apps/web/views.py in get(127) return CompetitionDetailView.as_view()(*args, **kwargs) /app/codalab/apps/web/views.py in get(528) return super(CompetitionDetailView, self).get(request, *args, **kwargs) /app/codalab/apps/web/views.py in get_context_data(576) scores = context['active_phase'].scores() /app/codalab/apps/web/models.py in scores(1082) user = submission.participant.user |
|||||||||||||||||||
+ |
SELECT ••• "teams_teammembership"."id", "teams_teammembership"."user_id", "teams_teammembership"."team_id", "teams_teammembership"."is_invitation", "teams_teammembership"."is_request", "teams_teammembership"."start_date", "teams_teammembership"."end_date", "teams_teammembership"."message", "teams_teammembership"."status_id", "teams_teammembership"."reason" FROM "teams_teammembership" INNER JOIN "teams_teammembershipstatus" ON ( "teams_teammembership"."status_id" = "teams_teammembershipstatus"."id" ) INNER JOIN "teams_team" ON ( "teams_teammembership"."team_id" = "teams_team"."id" ) WHERE ("teams_teammembershipstatus"."codename" = 'approved' AND "teams_team"."competition_id" = 9 AND "teams_teammembership"."user_id" = 75 )
|
1.17389960014% |
0.53 | ||||||||||||||||
Connection: default /usr/local/bin/gunicorn in <module>(8) sys.exit(run()) /usr/local/lib/python2.7/site-packages/gunicorn/app/wsgiapp.py in run(74) WSGIApplication("%(prog)s [OPTIONS] [APP_MODULE]").run() /usr/local/lib/python2.7/site-packages/gunicorn/app/base.py in run(203) super(Application, self).run() /usr/local/lib/python2.7/site-packages/gunicorn/app/base.py in run(72) Arbiter(self).run() /usr/local/lib/python2.7/site-packages/gunicorn/arbiter.py in run(202) self.manage_workers() /usr/local/lib/python2.7/site-packages/gunicorn/arbiter.py in manage_workers(544) self.spawn_workers() /usr/local/lib/python2.7/site-packages/gunicorn/arbiter.py in spawn_workers(611) self.spawn_worker() /usr/local/lib/python2.7/site-packages/gunicorn/arbiter.py in spawn_worker(578) worker.init_process() /usr/local/lib/python2.7/site-packages/gunicorn/workers/base.py in init_process(131) self.run() /usr/local/lib/python2.7/site-packages/gunicorn/workers/sync.py in run(124) self.run_for_one(timeout) /usr/local/lib/python2.7/site-packages/gunicorn/workers/sync.py in run_for_one(68) self.accept(listener) /usr/local/lib/python2.7/site-packages/gunicorn/workers/sync.py in accept(30) self.handle(listener, client, addr) /usr/local/lib/python2.7/site-packages/gunicorn/workers/sync.py in handle(135) self.handle_request(listener, req, client, addr) /usr/local/lib/python2.7/site-packages/gunicorn/workers/sync.py in handle_request(176) respiter = self.wsgi(environ, resp.start_response) /app/codalab/apps/web/views.py in get(127) return CompetitionDetailView.as_view()(*args, **kwargs) /app/codalab/apps/web/views.py in get(528) return super(CompetitionDetailView, self).get(request, *args, **kwargs) /app/codalab/apps/web/views.py in get_context_data(576) scores = context['active_phase'].scores() /app/codalab/apps/web/models.py in scores(1087) team__competition=self.competition |
|||||||||||||||||||
+ |
SELECT ••• "web_competitionparticipant"."id", "web_competitionparticipant"."user_id", "web_competitionparticipant"."competition_id", "web_competitionparticipant"."status_id", "web_competitionparticipant"."reason", "web_competitionparticipant"."trained_models_shared", "web_competitionparticipant"."deleted" FROM "web_competitionparticipant" WHERE "web_competitionparticipant"."id" = 132
|
0.899290943679% |
0.41 | ||||||||||||||||
Connection: default /usr/local/bin/gunicorn in <module>(8) sys.exit(run()) /usr/local/lib/python2.7/site-packages/gunicorn/app/wsgiapp.py in run(74) WSGIApplication("%(prog)s [OPTIONS] [APP_MODULE]").run() /usr/local/lib/python2.7/site-packages/gunicorn/app/base.py in run(203) super(Application, self).run() /usr/local/lib/python2.7/site-packages/gunicorn/app/base.py in run(72) Arbiter(self).run() /usr/local/lib/python2.7/site-packages/gunicorn/arbiter.py in run(202) self.manage_workers() /usr/local/lib/python2.7/site-packages/gunicorn/arbiter.py in manage_workers(544) self.spawn_workers() /usr/local/lib/python2.7/site-packages/gunicorn/arbiter.py in spawn_workers(611) self.spawn_worker() /usr/local/lib/python2.7/site-packages/gunicorn/arbiter.py in spawn_worker(578) worker.init_process() /usr/local/lib/python2.7/site-packages/gunicorn/workers/base.py in init_process(131) self.run() /usr/local/lib/python2.7/site-packages/gunicorn/workers/sync.py in run(124) self.run_for_one(timeout) /usr/local/lib/python2.7/site-packages/gunicorn/workers/sync.py in run_for_one(68) self.accept(listener) /usr/local/lib/python2.7/site-packages/gunicorn/workers/sync.py in accept(30) self.handle(listener, client, addr) /usr/local/lib/python2.7/site-packages/gunicorn/workers/sync.py in handle(135) self.handle_request(listener, req, client, addr) /usr/local/lib/python2.7/site-packages/gunicorn/workers/sync.py in handle_request(176) respiter = self.wsgi(environ, resp.start_response) /app/codalab/apps/web/views.py in get(127) return CompetitionDetailView.as_view()(*args, **kwargs) /app/codalab/apps/web/views.py in get(528) return super(CompetitionDetailView, self).get(request, *args, **kwargs) /app/codalab/apps/web/views.py in get_context_data(576) scores = context['active_phase'].scores() /app/codalab/apps/web/models.py in scores(1082) user = submission.participant.user |
|||||||||||||||||||
+ |
SELECT ••• "authenz_cluser"."id", "authenz_cluser"."password", "authenz_cluser"."last_login", "authenz_cluser"."is_superuser", "authenz_cluser"."username", "authenz_cluser"."first_name", "authenz_cluser"."last_name", "authenz_cluser"."email", "authenz_cluser"."is_staff", "authenz_cluser"."is_active", "authenz_cluser"."date_joined", "authenz_cluser"."chahub_timestamp", "authenz_cluser"."chahub_data_hash", "authenz_cluser"."chahub_needs_retry", "authenz_cluser"."participation_status_updates", "authenz_cluser"."organizer_status_updates", "authenz_cluser"."organizer_direct_message_updates", "authenz_cluser"."email_on_submission_finished_successfully", "authenz_cluser"."allow_forum_notifications", "authenz_cluser"."allow_admin_status_updates", "authenz_cluser"."newsletter_opt_in", "authenz_cluser"."organization_or_affiliation", "authenz_cluser"."team_name", "authenz_cluser"."team_members", "authenz_cluser"."method_name", "authenz_cluser"."method_description", "authenz_cluser"."project_url", "authenz_cluser"."publication_url", "authenz_cluser"."bibtex", "authenz_cluser"."contact_email", "authenz_cluser"."rabbitmq_queue_limit", "authenz_cluser"."rabbitmq_username", "authenz_cluser"."rabbitmq_password" FROM "authenz_cluser" WHERE "authenz_cluser"."id" = 127
|
1.16027397978% |
0.53 | ||||||||||||||||
Connection: default /usr/local/bin/gunicorn in <module>(8) sys.exit(run()) /usr/local/lib/python2.7/site-packages/gunicorn/app/wsgiapp.py in run(74) WSGIApplication("%(prog)s [OPTIONS] [APP_MODULE]").run() /usr/local/lib/python2.7/site-packages/gunicorn/app/base.py in run(203) super(Application, self).run() /usr/local/lib/python2.7/site-packages/gunicorn/app/base.py in run(72) Arbiter(self).run() /usr/local/lib/python2.7/site-packages/gunicorn/arbiter.py in run(202) self.manage_workers() /usr/local/lib/python2.7/site-packages/gunicorn/arbiter.py in manage_workers(544) self.spawn_workers() /usr/local/lib/python2.7/site-packages/gunicorn/arbiter.py in spawn_workers(611) self.spawn_worker() /usr/local/lib/python2.7/site-packages/gunicorn/arbiter.py in spawn_worker(578) worker.init_process() /usr/local/lib/python2.7/site-packages/gunicorn/workers/base.py in init_process(131) self.run() /usr/local/lib/python2.7/site-packages/gunicorn/workers/sync.py in run(124) self.run_for_one(timeout) /usr/local/lib/python2.7/site-packages/gunicorn/workers/sync.py in run_for_one(68) self.accept(listener) /usr/local/lib/python2.7/site-packages/gunicorn/workers/sync.py in accept(30) self.handle(listener, client, addr) /usr/local/lib/python2.7/site-packages/gunicorn/workers/sync.py in handle(135) self.handle_request(listener, req, client, addr) /usr/local/lib/python2.7/site-packages/gunicorn/workers/sync.py in handle_request(176) respiter = self.wsgi(environ, resp.start_response) /app/codalab/apps/web/views.py in get(127) return CompetitionDetailView.as_view()(*args, **kwargs) /app/codalab/apps/web/views.py in get(528) return super(CompetitionDetailView, self).get(request, *args, **kwargs) /app/codalab/apps/web/views.py in get_context_data(576) scores = context['active_phase'].scores() /app/codalab/apps/web/models.py in scores(1082) user = submission.participant.user |
|||||||||||||||||||
+ |
SELECT ••• "teams_teammembership"."id", "teams_teammembership"."user_id", "teams_teammembership"."team_id", "teams_teammembership"."is_invitation", "teams_teammembership"."is_request", "teams_teammembership"."start_date", "teams_teammembership"."end_date", "teams_teammembership"."message", "teams_teammembership"."status_id", "teams_teammembership"."reason" FROM "teams_teammembership" INNER JOIN "teams_teammembershipstatus" ON ( "teams_teammembership"."status_id" = "teams_teammembershipstatus"."id" ) INNER JOIN "teams_team" ON ( "teams_teammembership"."team_id" = "teams_team"."id" ) WHERE ("teams_teammembershipstatus"."codename" = 'approved' AND "teams_team"."competition_id" = 9 AND "teams_teammembership"."user_id" = 127 )
|
1.2949579964% |
0.59 | ||||||||||||||||
Connection: default /usr/local/bin/gunicorn in <module>(8) sys.exit(run()) /usr/local/lib/python2.7/site-packages/gunicorn/app/wsgiapp.py in run(74) WSGIApplication("%(prog)s [OPTIONS] [APP_MODULE]").run() /usr/local/lib/python2.7/site-packages/gunicorn/app/base.py in run(203) super(Application, self).run() /usr/local/lib/python2.7/site-packages/gunicorn/app/base.py in run(72) Arbiter(self).run() /usr/local/lib/python2.7/site-packages/gunicorn/arbiter.py in run(202) self.manage_workers() /usr/local/lib/python2.7/site-packages/gunicorn/arbiter.py in manage_workers(544) self.spawn_workers() /usr/local/lib/python2.7/site-packages/gunicorn/arbiter.py in spawn_workers(611) self.spawn_worker() /usr/local/lib/python2.7/site-packages/gunicorn/arbiter.py in spawn_worker(578) worker.init_process() /usr/local/lib/python2.7/site-packages/gunicorn/workers/base.py in init_process(131) self.run() /usr/local/lib/python2.7/site-packages/gunicorn/workers/sync.py in run(124) self.run_for_one(timeout) /usr/local/lib/python2.7/site-packages/gunicorn/workers/sync.py in run_for_one(68) self.accept(listener) /usr/local/lib/python2.7/site-packages/gunicorn/workers/sync.py in accept(30) self.handle(listener, client, addr) /usr/local/lib/python2.7/site-packages/gunicorn/workers/sync.py in handle(135) self.handle_request(listener, req, client, addr) /usr/local/lib/python2.7/site-packages/gunicorn/workers/sync.py in handle_request(176) respiter = self.wsgi(environ, resp.start_response) /app/codalab/apps/web/views.py in get(127) return CompetitionDetailView.as_view()(*args, **kwargs) /app/codalab/apps/web/views.py in get(528) return super(CompetitionDetailView, self).get(request, *args, **kwargs) /app/codalab/apps/web/views.py in get_context_data(576) scores = context['active_phase'].scores() /app/codalab/apps/web/models.py in scores(1087) team__competition=self.competition |
|||||||||||||||||||
+ |
SELECT ••• "web_competitionparticipant"."id", "web_competitionparticipant"."user_id", "web_competitionparticipant"."competition_id", "web_competitionparticipant"."status_id", "web_competitionparticipant"."reason", "web_competitionparticipant"."trained_models_shared", "web_competitionparticipant"."deleted" FROM "web_competitionparticipant" WHERE "web_competitionparticipant"."id" = 85
|
0.670275709187% |
0.30 | ||||||||||||||||
Connection: default /usr/local/bin/gunicorn in <module>(8) sys.exit(run()) /usr/local/lib/python2.7/site-packages/gunicorn/app/wsgiapp.py in run(74) WSGIApplication("%(prog)s [OPTIONS] [APP_MODULE]").run() /usr/local/lib/python2.7/site-packages/gunicorn/app/base.py in run(203) super(Application, self).run() /usr/local/lib/python2.7/site-packages/gunicorn/app/base.py in run(72) Arbiter(self).run() /usr/local/lib/python2.7/site-packages/gunicorn/arbiter.py in run(202) self.manage_workers() /usr/local/lib/python2.7/site-packages/gunicorn/arbiter.py in manage_workers(544) self.spawn_workers() /usr/local/lib/python2.7/site-packages/gunicorn/arbiter.py in spawn_workers(611) self.spawn_worker() /usr/local/lib/python2.7/site-packages/gunicorn/arbiter.py in spawn_worker(578) worker.init_process() /usr/local/lib/python2.7/site-packages/gunicorn/workers/base.py in init_process(131) self.run() /usr/local/lib/python2.7/site-packages/gunicorn/workers/sync.py in run(124) self.run_for_one(timeout) /usr/local/lib/python2.7/site-packages/gunicorn/workers/sync.py in run_for_one(68) self.accept(listener) /usr/local/lib/python2.7/site-packages/gunicorn/workers/sync.py in accept(30) self.handle(listener, client, addr) /usr/local/lib/python2.7/site-packages/gunicorn/workers/sync.py in handle(135) self.handle_request(listener, req, client, addr) /usr/local/lib/python2.7/site-packages/gunicorn/workers/sync.py in handle_request(176) respiter = self.wsgi(environ, resp.start_response) /app/codalab/apps/web/views.py in get(127) return CompetitionDetailView.as_view()(*args, **kwargs) /app/codalab/apps/web/views.py in get(528) return super(CompetitionDetailView, self).get(request, *args, **kwargs) /app/codalab/apps/web/views.py in get_context_data(576) scores = context['active_phase'].scores() /app/codalab/apps/web/models.py in scores(1082) user = submission.participant.user |
|||||||||||||||||||
+ |
SELECT ••• "authenz_cluser"."id", "authenz_cluser"."password", "authenz_cluser"."last_login", "authenz_cluser"."is_superuser", "authenz_cluser"."username", "authenz_cluser"."first_name", "authenz_cluser"."last_name", "authenz_cluser"."email", "authenz_cluser"."is_staff", "authenz_cluser"."is_active", "authenz_cluser"."date_joined", "authenz_cluser"."chahub_timestamp", "authenz_cluser"."chahub_data_hash", "authenz_cluser"."chahub_needs_retry", "authenz_cluser"."participation_status_updates", "authenz_cluser"."organizer_status_updates", "authenz_cluser"."organizer_direct_message_updates", "authenz_cluser"."email_on_submission_finished_successfully", "authenz_cluser"."allow_forum_notifications", "authenz_cluser"."allow_admin_status_updates", "authenz_cluser"."newsletter_opt_in", "authenz_cluser"."organization_or_affiliation", "authenz_cluser"."team_name", "authenz_cluser"."team_members", "authenz_cluser"."method_name", "authenz_cluser"."method_description", "authenz_cluser"."project_url", "authenz_cluser"."publication_url", "authenz_cluser"."bibtex", "authenz_cluser"."contact_email", "authenz_cluser"."rabbitmq_queue_limit", "authenz_cluser"."rabbitmq_username", "authenz_cluser"."rabbitmq_password" FROM "authenz_cluser" WHERE "authenz_cluser"."id" = 54
|
1.0266380878% |
0.47 | ||||||||||||||||
Connection: default /usr/local/bin/gunicorn in <module>(8) sys.exit(run()) /usr/local/lib/python2.7/site-packages/gunicorn/app/wsgiapp.py in run(74) WSGIApplication("%(prog)s [OPTIONS] [APP_MODULE]").run() /usr/local/lib/python2.7/site-packages/gunicorn/app/base.py in run(203) super(Application, self).run() /usr/local/lib/python2.7/site-packages/gunicorn/app/base.py in run(72) Arbiter(self).run() /usr/local/lib/python2.7/site-packages/gunicorn/arbiter.py in run(202) self.manage_workers() /usr/local/lib/python2.7/site-packages/gunicorn/arbiter.py in manage_workers(544) self.spawn_workers() /usr/local/lib/python2.7/site-packages/gunicorn/arbiter.py in spawn_workers(611) self.spawn_worker() /usr/local/lib/python2.7/site-packages/gunicorn/arbiter.py in spawn_worker(578) worker.init_process() /usr/local/lib/python2.7/site-packages/gunicorn/workers/base.py in init_process(131) self.run() /usr/local/lib/python2.7/site-packages/gunicorn/workers/sync.py in run(124) self.run_for_one(timeout) /usr/local/lib/python2.7/site-packages/gunicorn/workers/sync.py in run_for_one(68) self.accept(listener) /usr/local/lib/python2.7/site-packages/gunicorn/workers/sync.py in accept(30) self.handle(listener, client, addr) /usr/local/lib/python2.7/site-packages/gunicorn/workers/sync.py in handle(135) self.handle_request(listener, req, client, addr) /usr/local/lib/python2.7/site-packages/gunicorn/workers/sync.py in handle_request(176) respiter = self.wsgi(environ, resp.start_response) /app/codalab/apps/web/views.py in get(127) return CompetitionDetailView.as_view()(*args, **kwargs) /app/codalab/apps/web/views.py in get(528) return super(CompetitionDetailView, self).get(request, *args, **kwargs) /app/codalab/apps/web/views.py in get_context_data(576) scores = context['active_phase'].scores() /app/codalab/apps/web/models.py in scores(1082) user = submission.participant.user |
|||||||||||||||||||
+ |
SELECT ••• "teams_teammembership"."id", "teams_teammembership"."user_id", "teams_teammembership"."team_id", "teams_teammembership"."is_invitation", "teams_teammembership"."is_request", "teams_teammembership"."start_date", "teams_teammembership"."end_date", "teams_teammembership"."message", "teams_teammembership"."status_id", "teams_teammembership"."reason" FROM "teams_teammembership" INNER JOIN "teams_teammembershipstatus" ON ( "teams_teammembership"."status_id" = "teams_teammembershipstatus"."id" ) INNER JOIN "teams_team" ON ( "teams_teammembership"."team_id" = "teams_team"."id" ) WHERE ("teams_teammembershipstatus"."codename" = 'approved' AND "teams_team"."competition_id" = 9 AND "teams_teammembership"."user_id" = 54 )
|
1.23102239318% |
0.56 | ||||||||||||||||
Connection: default /usr/local/bin/gunicorn in <module>(8) sys.exit(run()) /usr/local/lib/python2.7/site-packages/gunicorn/app/wsgiapp.py in run(74) WSGIApplication("%(prog)s [OPTIONS] [APP_MODULE]").run() /usr/local/lib/python2.7/site-packages/gunicorn/app/base.py in run(203) super(Application, self).run() /usr/local/lib/python2.7/site-packages/gunicorn/app/base.py in run(72) Arbiter(self).run() /usr/local/lib/python2.7/site-packages/gunicorn/arbiter.py in run(202) self.manage_workers() /usr/local/lib/python2.7/site-packages/gunicorn/arbiter.py in manage_workers(544) self.spawn_workers() /usr/local/lib/python2.7/site-packages/gunicorn/arbiter.py in spawn_workers(611) self.spawn_worker() /usr/local/lib/python2.7/site-packages/gunicorn/arbiter.py in spawn_worker(578) worker.init_process() /usr/local/lib/python2.7/site-packages/gunicorn/workers/base.py in init_process(131) self.run() /usr/local/lib/python2.7/site-packages/gunicorn/workers/sync.py in run(124) self.run_for_one(timeout) /usr/local/lib/python2.7/site-packages/gunicorn/workers/sync.py in run_for_one(68) self.accept(listener) /usr/local/lib/python2.7/site-packages/gunicorn/workers/sync.py in accept(30) self.handle(listener, client, addr) /usr/local/lib/python2.7/site-packages/gunicorn/workers/sync.py in handle(135) self.handle_request(listener, req, client, addr) /usr/local/lib/python2.7/site-packages/gunicorn/workers/sync.py in handle_request(176) respiter = self.wsgi(environ, resp.start_response) /app/codalab/apps/web/views.py in get(127) return CompetitionDetailView.as_view()(*args, **kwargs) /app/codalab/apps/web/views.py in get(528) return super(CompetitionDetailView, self).get(request, *args, **kwargs) /app/codalab/apps/web/views.py in get_context_data(576) scores = context['active_phase'].scores() /app/codalab/apps/web/models.py in scores(1087) team__competition=self.competition |
|||||||||||||||||||
+ |
SELECT ••• "web_competitionparticipant"."id", "web_competitionparticipant"."user_id", "web_competitionparticipant"."competition_id", "web_competitionparticipant"."status_id", "web_competitionparticipant"."reason", "web_competitionparticipant"."trained_models_shared", "web_competitionparticipant"."deleted" FROM "web_competitionparticipant" WHERE "web_competitionparticipant"."id" = 75
|
0.81544097224% |
0.37 | ||||||||||||||||
Connection: default /usr/local/bin/gunicorn in <module>(8) sys.exit(run()) /usr/local/lib/python2.7/site-packages/gunicorn/app/wsgiapp.py in run(74) WSGIApplication("%(prog)s [OPTIONS] [APP_MODULE]").run() /usr/local/lib/python2.7/site-packages/gunicorn/app/base.py in run(203) super(Application, self).run() /usr/local/lib/python2.7/site-packages/gunicorn/app/base.py in run(72) Arbiter(self).run() /usr/local/lib/python2.7/site-packages/gunicorn/arbiter.py in run(202) self.manage_workers() /usr/local/lib/python2.7/site-packages/gunicorn/arbiter.py in manage_workers(544) self.spawn_workers() /usr/local/lib/python2.7/site-packages/gunicorn/arbiter.py in spawn_workers(611) self.spawn_worker() /usr/local/lib/python2.7/site-packages/gunicorn/arbiter.py in spawn_worker(578) worker.init_process() /usr/local/lib/python2.7/site-packages/gunicorn/workers/base.py in init_process(131) self.run() /usr/local/lib/python2.7/site-packages/gunicorn/workers/sync.py in run(124) self.run_for_one(timeout) /usr/local/lib/python2.7/site-packages/gunicorn/workers/sync.py in run_for_one(68) self.accept(listener) /usr/local/lib/python2.7/site-packages/gunicorn/workers/sync.py in accept(30) self.handle(listener, client, addr) /usr/local/lib/python2.7/site-packages/gunicorn/workers/sync.py in handle(135) self.handle_request(listener, req, client, addr) /usr/local/lib/python2.7/site-packages/gunicorn/workers/sync.py in handle_request(176) respiter = self.wsgi(environ, resp.start_response) /app/codalab/apps/web/views.py in get(127) return CompetitionDetailView.as_view()(*args, **kwargs) /app/codalab/apps/web/views.py in get(528) return super(CompetitionDetailView, self).get(request, *args, **kwargs) /app/codalab/apps/web/views.py in get_context_data(576) scores = context['active_phase'].scores() /app/codalab/apps/web/models.py in scores(1082) user = submission.participant.user |
|||||||||||||||||||
+ |
SELECT ••• "authenz_cluser"."id", "authenz_cluser"."password", "authenz_cluser"."last_login", "authenz_cluser"."is_superuser", "authenz_cluser"."username", "authenz_cluser"."first_name", "authenz_cluser"."last_name", "authenz_cluser"."email", "authenz_cluser"."is_staff", "authenz_cluser"."is_active", "authenz_cluser"."date_joined", "authenz_cluser"."chahub_timestamp", "authenz_cluser"."chahub_data_hash", "authenz_cluser"."chahub_needs_retry", "authenz_cluser"."participation_status_updates", "authenz_cluser"."organizer_status_updates", "authenz_cluser"."organizer_direct_message_updates", "authenz_cluser"."email_on_submission_finished_successfully", "authenz_cluser"."allow_forum_notifications", "authenz_cluser"."allow_admin_status_updates", "authenz_cluser"."newsletter_opt_in", "authenz_cluser"."organization_or_affiliation", "authenz_cluser"."team_name", "authenz_cluser"."team_members", "authenz_cluser"."method_name", "authenz_cluser"."method_description", "authenz_cluser"."project_url", "authenz_cluser"."publication_url", "authenz_cluser"."bibtex", "authenz_cluser"."contact_email", "authenz_cluser"."rabbitmq_queue_limit", "authenz_cluser"."rabbitmq_username", "authenz_cluser"."rabbitmq_password" FROM "authenz_cluser" WHERE "authenz_cluser"."id" = 1
|
0.865750955104% |
0.39 | ||||||||||||||||
Connection: default /usr/local/bin/gunicorn in <module>(8) sys.exit(run()) /usr/local/lib/python2.7/site-packages/gunicorn/app/wsgiapp.py in run(74) WSGIApplication("%(prog)s [OPTIONS] [APP_MODULE]").run() /usr/local/lib/python2.7/site-packages/gunicorn/app/base.py in run(203) super(Application, self).run() /usr/local/lib/python2.7/site-packages/gunicorn/app/base.py in run(72) Arbiter(self).run() /usr/local/lib/python2.7/site-packages/gunicorn/arbiter.py in run(202) self.manage_workers() /usr/local/lib/python2.7/site-packages/gunicorn/arbiter.py in manage_workers(544) self.spawn_workers() /usr/local/lib/python2.7/site-packages/gunicorn/arbiter.py in spawn_workers(611) self.spawn_worker() /usr/local/lib/python2.7/site-packages/gunicorn/arbiter.py in spawn_worker(578) worker.init_process() /usr/local/lib/python2.7/site-packages/gunicorn/workers/base.py in init_process(131) self.run() /usr/local/lib/python2.7/site-packages/gunicorn/workers/sync.py in run(124) self.run_for_one(timeout) /usr/local/lib/python2.7/site-packages/gunicorn/workers/sync.py in run_for_one(68) self.accept(listener) /usr/local/lib/python2.7/site-packages/gunicorn/workers/sync.py in accept(30) self.handle(listener, client, addr) /usr/local/lib/python2.7/site-packages/gunicorn/workers/sync.py in handle(135) self.handle_request(listener, req, client, addr) /usr/local/lib/python2.7/site-packages/gunicorn/workers/sync.py in handle_request(176) respiter = self.wsgi(environ, resp.start_response) /app/codalab/apps/web/views.py in get(127) return CompetitionDetailView.as_view()(*args, **kwargs) /app/codalab/apps/web/views.py in get(528) return super(CompetitionDetailView, self).get(request, *args, **kwargs) /app/codalab/apps/web/views.py in get_context_data(576) scores = context['active_phase'].scores() /app/codalab/apps/web/models.py in scores(1082) user = submission.participant.user |
|||||||||||||||||||
+ |
SELECT ••• "teams_teammembership"."id", "teams_teammembership"."user_id", "teams_teammembership"."team_id", "teams_teammembership"."is_invitation", "teams_teammembership"."is_request", "teams_teammembership"."start_date", "teams_teammembership"."end_date", "teams_teammembership"."message", "teams_teammembership"."status_id", "teams_teammembership"."reason" FROM "teams_teammembership" INNER JOIN "teams_teammembershipstatus" ON ( "teams_teammembership"."status_id" = "teams_teammembershipstatus"."id" ) INNER JOIN "teams_team" ON ( "teams_teammembership"."team_id" = "teams_team"."id" ) WHERE ("teams_teammembershipstatus"."codename" = 'approved' AND "teams_team"."competition_id" = 9 AND "teams_teammembership"."user_id" = 1 )
|
1.31854080087% |
0.60 | ||||||||||||||||
Connection: default /usr/local/bin/gunicorn in <module>(8) sys.exit(run()) /usr/local/lib/python2.7/site-packages/gunicorn/app/wsgiapp.py in run(74) WSGIApplication("%(prog)s [OPTIONS] [APP_MODULE]").run() /usr/local/lib/python2.7/site-packages/gunicorn/app/base.py in run(203) super(Application, self).run() /usr/local/lib/python2.7/site-packages/gunicorn/app/base.py in run(72) Arbiter(self).run() /usr/local/lib/python2.7/site-packages/gunicorn/arbiter.py in run(202) self.manage_workers() /usr/local/lib/python2.7/site-packages/gunicorn/arbiter.py in manage_workers(544) self.spawn_workers() /usr/local/lib/python2.7/site-packages/gunicorn/arbiter.py in spawn_workers(611) self.spawn_worker() /usr/local/lib/python2.7/site-packages/gunicorn/arbiter.py in spawn_worker(578) worker.init_process() /usr/local/lib/python2.7/site-packages/gunicorn/workers/base.py in init_process(131) self.run() /usr/local/lib/python2.7/site-packages/gunicorn/workers/sync.py in run(124) self.run_for_one(timeout) /usr/local/lib/python2.7/site-packages/gunicorn/workers/sync.py in run_for_one(68) self.accept(listener) /usr/local/lib/python2.7/site-packages/gunicorn/workers/sync.py in accept(30) self.handle(listener, client, addr) /usr/local/lib/python2.7/site-packages/gunicorn/workers/sync.py in handle(135) self.handle_request(listener, req, client, addr) /usr/local/lib/python2.7/site-packages/gunicorn/workers/sync.py in handle_request(176) respiter = self.wsgi(environ, resp.start_response) /app/codalab/apps/web/views.py in get(127) return CompetitionDetailView.as_view()(*args, **kwargs) /app/codalab/apps/web/views.py in get(528) return super(CompetitionDetailView, self).get(request, *args, **kwargs) /app/codalab/apps/web/views.py in get_context_data(576) scores = context['active_phase'].scores() /app/codalab/apps/web/models.py in scores(1087) team__competition=self.competition |
|||||||||||||||||||
+ |
SELECT ••• "web_competitionparticipant"."id", "web_competitionparticipant"."user_id", "web_competitionparticipant"."competition_id", "web_competitionparticipant"."status_id", "web_competitionparticipant"."reason", "web_competitionparticipant"."trained_models_shared", "web_competitionparticipant"."deleted" FROM "web_competitionparticipant" WHERE "web_competitionparticipant"."id" = 92
|
0.839547839029% |
0.38 | ||||||||||||||||
Connection: default /usr/local/bin/gunicorn in <module>(8) sys.exit(run()) /usr/local/lib/python2.7/site-packages/gunicorn/app/wsgiapp.py in run(74) WSGIApplication("%(prog)s [OPTIONS] [APP_MODULE]").run() /usr/local/lib/python2.7/site-packages/gunicorn/app/base.py in run(203) super(Application, self).run() /usr/local/lib/python2.7/site-packages/gunicorn/app/base.py in run(72) Arbiter(self).run() /usr/local/lib/python2.7/site-packages/gunicorn/arbiter.py in run(202) self.manage_workers() /usr/local/lib/python2.7/site-packages/gunicorn/arbiter.py in manage_workers(544) self.spawn_workers() /usr/local/lib/python2.7/site-packages/gunicorn/arbiter.py in spawn_workers(611) self.spawn_worker() /usr/local/lib/python2.7/site-packages/gunicorn/arbiter.py in spawn_worker(578) worker.init_process() /usr/local/lib/python2.7/site-packages/gunicorn/workers/base.py in init_process(131) self.run() /usr/local/lib/python2.7/site-packages/gunicorn/workers/sync.py in run(124) self.run_for_one(timeout) /usr/local/lib/python2.7/site-packages/gunicorn/workers/sync.py in run_for_one(68) self.accept(listener) /usr/local/lib/python2.7/site-packages/gunicorn/workers/sync.py in accept(30) self.handle(listener, client, addr) /usr/local/lib/python2.7/site-packages/gunicorn/workers/sync.py in handle(135) self.handle_request(listener, req, client, addr) /usr/local/lib/python2.7/site-packages/gunicorn/workers/sync.py in handle_request(176) respiter = self.wsgi(environ, resp.start_response) /app/codalab/apps/web/views.py in get(127) return CompetitionDetailView.as_view()(*args, **kwargs) /app/codalab/apps/web/views.py in get(528) return super(CompetitionDetailView, self).get(request, *args, **kwargs) /app/codalab/apps/web/views.py in get_context_data(576) scores = context['active_phase'].scores() /app/codalab/apps/web/models.py in scores(1082) user = submission.participant.user |
|||||||||||||||||||
+ |
SELECT ••• "authenz_cluser"."id", "authenz_cluser"."password", "authenz_cluser"."last_login", "authenz_cluser"."is_superuser", "authenz_cluser"."username", "authenz_cluser"."first_name", "authenz_cluser"."last_name", "authenz_cluser"."email", "authenz_cluser"."is_staff", "authenz_cluser"."is_active", "authenz_cluser"."date_joined", "authenz_cluser"."chahub_timestamp", "authenz_cluser"."chahub_data_hash", "authenz_cluser"."chahub_needs_retry", "authenz_cluser"."participation_status_updates", "authenz_cluser"."organizer_status_updates", "authenz_cluser"."organizer_direct_message_updates", "authenz_cluser"."email_on_submission_finished_successfully", "authenz_cluser"."allow_forum_notifications", "authenz_cluser"."allow_admin_status_updates", "authenz_cluser"."newsletter_opt_in", "authenz_cluser"."organization_or_affiliation", "authenz_cluser"."team_name", "authenz_cluser"."team_members", "authenz_cluser"."method_name", "authenz_cluser"."method_description", "authenz_cluser"."project_url", "authenz_cluser"."publication_url", "authenz_cluser"."bibtex", "authenz_cluser"."contact_email", "authenz_cluser"."rabbitmq_queue_limit", "authenz_cluser"."rabbitmq_username", "authenz_cluser"."rabbitmq_password" FROM "authenz_cluser" WHERE "authenz_cluser"."id" = 44
|
0.8924781335% |
0.41 | ||||||||||||||||
Connection: default /usr/local/bin/gunicorn in <module>(8) sys.exit(run()) /usr/local/lib/python2.7/site-packages/gunicorn/app/wsgiapp.py in run(74) WSGIApplication("%(prog)s [OPTIONS] [APP_MODULE]").run() /usr/local/lib/python2.7/site-packages/gunicorn/app/base.py in run(203) super(Application, self).run() /usr/local/lib/python2.7/site-packages/gunicorn/app/base.py in run(72) Arbiter(self).run() /usr/local/lib/python2.7/site-packages/gunicorn/arbiter.py in run(202) self.manage_workers() /usr/local/lib/python2.7/site-packages/gunicorn/arbiter.py in manage_workers(544) self.spawn_workers() /usr/local/lib/python2.7/site-packages/gunicorn/arbiter.py in spawn_workers(611) self.spawn_worker() /usr/local/lib/python2.7/site-packages/gunicorn/arbiter.py in spawn_worker(578) worker.init_process() /usr/local/lib/python2.7/site-packages/gunicorn/workers/base.py in init_process(131) self.run() /usr/local/lib/python2.7/site-packages/gunicorn/workers/sync.py in run(124) self.run_for_one(timeout) /usr/local/lib/python2.7/site-packages/gunicorn/workers/sync.py in run_for_one(68) self.accept(listener) /usr/local/lib/python2.7/site-packages/gunicorn/workers/sync.py in accept(30) self.handle(listener, client, addr) /usr/local/lib/python2.7/site-packages/gunicorn/workers/sync.py in handle(135) self.handle_request(listener, req, client, addr) /usr/local/lib/python2.7/site-packages/gunicorn/workers/sync.py in handle_request(176) respiter = self.wsgi(environ, resp.start_response) /app/codalab/apps/web/views.py in get(127) return CompetitionDetailView.as_view()(*args, **kwargs) /app/codalab/apps/web/views.py in get(528) return super(CompetitionDetailView, self).get(request, *args, **kwargs) /app/codalab/apps/web/views.py in get_context_data(576) scores = context['active_phase'].scores() /app/codalab/apps/web/models.py in scores(1082) user = submission.participant.user |
|||||||||||||||||||
+ |
SELECT ••• "teams_teammembership"."id", "teams_teammembership"."user_id", "teams_teammembership"."team_id", "teams_teammembership"."is_invitation", "teams_teammembership"."is_request", "teams_teammembership"."start_date", "teams_teammembership"."end_date", "teams_teammembership"."message", "teams_teammembership"."status_id", "teams_teammembership"."reason" FROM "teams_teammembership" INNER JOIN "teams_teammembershipstatus" ON ( "teams_teammembership"."status_id" = "teams_teammembershipstatus"."id" ) INNER JOIN "teams_team" ON ( "teams_teammembership"."team_id" = "teams_team"."id" ) WHERE ("teams_teammembershipstatus"."codename" = 'approved' AND "teams_team"."competition_id" = 9 AND "teams_teammembership"."user_id" = 44 )
|
1.24622020051% |
0.57 | ||||||||||||||||
Connection: default /usr/local/bin/gunicorn in <module>(8) sys.exit(run()) /usr/local/lib/python2.7/site-packages/gunicorn/app/wsgiapp.py in run(74) WSGIApplication("%(prog)s [OPTIONS] [APP_MODULE]").run() /usr/local/lib/python2.7/site-packages/gunicorn/app/base.py in run(203) super(Application, self).run() /usr/local/lib/python2.7/site-packages/gunicorn/app/base.py in run(72) Arbiter(self).run() /usr/local/lib/python2.7/site-packages/gunicorn/arbiter.py in run(202) self.manage_workers() /usr/local/lib/python2.7/site-packages/gunicorn/arbiter.py in manage_workers(544) self.spawn_workers() /usr/local/lib/python2.7/site-packages/gunicorn/arbiter.py in spawn_workers(611) self.spawn_worker() /usr/local/lib/python2.7/site-packages/gunicorn/arbiter.py in spawn_worker(578) worker.init_process() /usr/local/lib/python2.7/site-packages/gunicorn/workers/base.py in init_process(131) self.run() /usr/local/lib/python2.7/site-packages/gunicorn/workers/sync.py in run(124) self.run_for_one(timeout) /usr/local/lib/python2.7/site-packages/gunicorn/workers/sync.py in run_for_one(68) self.accept(listener) /usr/local/lib/python2.7/site-packages/gunicorn/workers/sync.py in accept(30) self.handle(listener, client, addr) /usr/local/lib/python2.7/site-packages/gunicorn/workers/sync.py in handle(135) self.handle_request(listener, req, client, addr) /usr/local/lib/python2.7/site-packages/gunicorn/workers/sync.py in handle_request(176) respiter = self.wsgi(environ, resp.start_response) /app/codalab/apps/web/views.py in get(127) return CompetitionDetailView.as_view()(*args, **kwargs) /app/codalab/apps/web/views.py in get(528) return super(CompetitionDetailView, self).get(request, *args, **kwargs) /app/codalab/apps/web/views.py in get_context_data(576) scores = context['active_phase'].scores() /app/codalab/apps/web/models.py in scores(1087) team__competition=self.competition |
|||||||||||||||||||
+ |
SELECT ••• "web_competitionparticipant"."id", "web_competitionparticipant"."user_id", "web_competitionparticipant"."competition_id", "web_competitionparticipant"."status_id", "web_competitionparticipant"."reason", "web_competitionparticipant"."trained_models_shared", "web_competitionparticipant"."deleted" FROM "web_competitionparticipant" WHERE "web_competitionparticipant"."id" = 90
|
0.791334105452% |
0.36 | ||||||||||||||||
Connection: default /usr/local/bin/gunicorn in <module>(8) sys.exit(run()) /usr/local/lib/python2.7/site-packages/gunicorn/app/wsgiapp.py in run(74) WSGIApplication("%(prog)s [OPTIONS] [APP_MODULE]").run() /usr/local/lib/python2.7/site-packages/gunicorn/app/base.py in run(203) super(Application, self).run() /usr/local/lib/python2.7/site-packages/gunicorn/app/base.py in run(72) Arbiter(self).run() /usr/local/lib/python2.7/site-packages/gunicorn/arbiter.py in run(202) self.manage_workers() /usr/local/lib/python2.7/site-packages/gunicorn/arbiter.py in manage_workers(544) self.spawn_workers() /usr/local/lib/python2.7/site-packages/gunicorn/arbiter.py in spawn_workers(611) self.spawn_worker() /usr/local/lib/python2.7/site-packages/gunicorn/arbiter.py in spawn_worker(578) worker.init_process() /usr/local/lib/python2.7/site-packages/gunicorn/workers/base.py in init_process(131) self.run() /usr/local/lib/python2.7/site-packages/gunicorn/workers/sync.py in run(124) self.run_for_one(timeout) /usr/local/lib/python2.7/site-packages/gunicorn/workers/sync.py in run_for_one(68) self.accept(listener) /usr/local/lib/python2.7/site-packages/gunicorn/workers/sync.py in accept(30) self.handle(listener, client, addr) /usr/local/lib/python2.7/site-packages/gunicorn/workers/sync.py in handle(135) self.handle_request(listener, req, client, addr) /usr/local/lib/python2.7/site-packages/gunicorn/workers/sync.py in handle_request(176) respiter = self.wsgi(environ, resp.start_response) /app/codalab/apps/web/views.py in get(127) return CompetitionDetailView.as_view()(*args, **kwargs) /app/codalab/apps/web/views.py in get(528) return super(CompetitionDetailView, self).get(request, *args, **kwargs) /app/codalab/apps/web/views.py in get_context_data(576) scores = context['active_phase'].scores() /app/codalab/apps/web/models.py in scores(1082) user = submission.participant.user |
|||||||||||||||||||
+ |
SELECT ••• "authenz_cluser"."id", "authenz_cluser"."password", "authenz_cluser"."last_login", "authenz_cluser"."is_superuser", "authenz_cluser"."username", "authenz_cluser"."first_name", "authenz_cluser"."last_name", "authenz_cluser"."email", "authenz_cluser"."is_staff", "authenz_cluser"."is_active", "authenz_cluser"."date_joined", "authenz_cluser"."chahub_timestamp", "authenz_cluser"."chahub_data_hash", "authenz_cluser"."chahub_needs_retry", "authenz_cluser"."participation_status_updates", "authenz_cluser"."organizer_status_updates", "authenz_cluser"."organizer_direct_message_updates", "authenz_cluser"."email_on_submission_finished_successfully", "authenz_cluser"."allow_forum_notifications", "authenz_cluser"."allow_admin_status_updates", "authenz_cluser"."newsletter_opt_in", "authenz_cluser"."organization_or_affiliation", "authenz_cluser"."team_name", "authenz_cluser"."team_members", "authenz_cluser"."method_name", "authenz_cluser"."method_description", "authenz_cluser"."project_url", "authenz_cluser"."publication_url", "authenz_cluser"."bibtex", "authenz_cluser"."contact_email", "authenz_cluser"."rabbitmq_queue_limit", "authenz_cluser"."rabbitmq_username", "authenz_cluser"."rabbitmq_password" FROM "authenz_cluser" WHERE "authenz_cluser"."id" = 51
|
0.872563765283% |
0.40 | ||||||||||||||||
Connection: default /usr/local/bin/gunicorn in <module>(8) sys.exit(run()) /usr/local/lib/python2.7/site-packages/gunicorn/app/wsgiapp.py in run(74) WSGIApplication("%(prog)s [OPTIONS] [APP_MODULE]").run() /usr/local/lib/python2.7/site-packages/gunicorn/app/base.py in run(203) super(Application, self).run() /usr/local/lib/python2.7/site-packages/gunicorn/app/base.py in run(72) Arbiter(self).run() /usr/local/lib/python2.7/site-packages/gunicorn/arbiter.py in run(202) self.manage_workers() /usr/local/lib/python2.7/site-packages/gunicorn/arbiter.py in manage_workers(544) self.spawn_workers() /usr/local/lib/python2.7/site-packages/gunicorn/arbiter.py in spawn_workers(611) self.spawn_worker() /usr/local/lib/python2.7/site-packages/gunicorn/arbiter.py in spawn_worker(578) worker.init_process() /usr/local/lib/python2.7/site-packages/gunicorn/workers/base.py in init_process(131) self.run() /usr/local/lib/python2.7/site-packages/gunicorn/workers/sync.py in run(124) self.run_for_one(timeout) /usr/local/lib/python2.7/site-packages/gunicorn/workers/sync.py in run_for_one(68) self.accept(listener) /usr/local/lib/python2.7/site-packages/gunicorn/workers/sync.py in accept(30) self.handle(listener, client, addr) /usr/local/lib/python2.7/site-packages/gunicorn/workers/sync.py in handle(135) self.handle_request(listener, req, client, addr) /usr/local/lib/python2.7/site-packages/gunicorn/workers/sync.py in handle_request(176) respiter = self.wsgi(environ, resp.start_response) /app/codalab/apps/web/views.py in get(127) return CompetitionDetailView.as_view()(*args, **kwargs) /app/codalab/apps/web/views.py in get(528) return super(CompetitionDetailView, self).get(request, *args, **kwargs) /app/codalab/apps/web/views.py in get_context_data(576) scores = context['active_phase'].scores() /app/codalab/apps/web/models.py in scores(1082) user = submission.participant.user |
|||||||||||||||||||
+ |
SELECT ••• "teams_teammembership"."id", "teams_teammembership"."user_id", "teams_teammembership"."team_id", "teams_teammembership"."is_invitation", "teams_teammembership"."is_request", "teams_teammembership"."start_date", "teams_teammembership"."end_date", "teams_teammembership"."message", "teams_teammembership"."status_id", "teams_teammembership"."reason" FROM "teams_teammembership" INNER JOIN "teams_teammembershipstatus" ON ( "teams_teammembership"."status_id" = "teams_teammembershipstatus"."id" ) INNER JOIN "teams_team" ON ( "teams_teammembership"."team_id" = "teams_team"."id" ) WHERE ("teams_teammembershipstatus"."codename" = 'approved' AND "teams_team"."competition_id" = 9 AND "teams_teammembership"."user_id" = 51 )
|
1.2923376848% |
0.59 | ||||||||||||||||
Connection: default /usr/local/bin/gunicorn in <module>(8) sys.exit(run()) /usr/local/lib/python2.7/site-packages/gunicorn/app/wsgiapp.py in run(74) WSGIApplication("%(prog)s [OPTIONS] [APP_MODULE]").run() /usr/local/lib/python2.7/site-packages/gunicorn/app/base.py in run(203) super(Application, self).run() /usr/local/lib/python2.7/site-packages/gunicorn/app/base.py in run(72) Arbiter(self).run() /usr/local/lib/python2.7/site-packages/gunicorn/arbiter.py in run(202) self.manage_workers() /usr/local/lib/python2.7/site-packages/gunicorn/arbiter.py in manage_workers(544) self.spawn_workers() /usr/local/lib/python2.7/site-packages/gunicorn/arbiter.py in spawn_workers(611) self.spawn_worker() /usr/local/lib/python2.7/site-packages/gunicorn/arbiter.py in spawn_worker(578) worker.init_process() /usr/local/lib/python2.7/site-packages/gunicorn/workers/base.py in init_process(131) self.run() /usr/local/lib/python2.7/site-packages/gunicorn/workers/sync.py in run(124) self.run_for_one(timeout) /usr/local/lib/python2.7/site-packages/gunicorn/workers/sync.py in run_for_one(68) self.accept(listener) /usr/local/lib/python2.7/site-packages/gunicorn/workers/sync.py in accept(30) self.handle(listener, client, addr) /usr/local/lib/python2.7/site-packages/gunicorn/workers/sync.py in handle(135) self.handle_request(listener, req, client, addr) /usr/local/lib/python2.7/site-packages/gunicorn/workers/sync.py in handle_request(176) respiter = self.wsgi(environ, resp.start_response) /app/codalab/apps/web/views.py in get(127) return CompetitionDetailView.as_view()(*args, **kwargs) /app/codalab/apps/web/views.py in get(528) return super(CompetitionDetailView, self).get(request, *args, **kwargs) /app/codalab/apps/web/views.py in get_context_data(576) scores = context['active_phase'].scores() /app/codalab/apps/web/models.py in scores(1087) team__competition=self.competition |
|||||||||||||||||||
+ |
SELECT ••• "web_submissionscoreset"."id", "web_submissionscoreset"."parent_id", "web_submissionscoreset"."competition_id", "web_submissionscoreset"."key", "web_submissionscoreset"."label", "web_submissionscoreset"."scoredef_id", "web_submissionscoreset"."ordering", "web_submissionscoreset"."lft", "web_submissionscoreset"."rght", "web_submissionscoreset"."tree_id", "web_submissionscoreset"."level", T5."id", T5."parent_id", T5."competition_id", T5."key", T5."label", T5."scoredef_id", T5."ordering", T5."lft", T5."rght", T5."tree_id", T5."level", "web_submissionscoredef"."id", "web_submissionscoredef"."competition_id", "web_submissionscoredef"."key", "web_submissionscoredef"."label", "web_submissionscoredef"."sorting", "web_submissionscoredef"."numeric_format", "web_submissionscoredef"."show_rank", "web_submissionscoredef"."selection_default", "web_submissionscoredef"."computed", "web_submissionscoredef"."ordering" FROM "web_submissionscoreset" INNER JOIN "web_submissionscoredef" ON ( "web_submissionscoreset"."scoredef_id" = "web_submissionscoredef"."id" ) INNER JOIN "web_submissionscoredefgroup" ON ( "web_submissionscoredef"."id" = "web_submissionscoredefgroup"."scoredef_id" ) LEFT OUTER JOIN "web_submissionscoreset" T5 ON ( "web_submissionscoreset"."parent_id" = T5."id" ) WHERE ("web_submissionscoreset"."scoredef_id" IS NOT NULL AND "web_submissionscoredefgroup"."group_id" IN (6)) ORDER BY "web_submissionscoreset"."tree_id" ASC, "web_submissionscoreset"."lft" ASC
|
4.15214577318% |
1.89 | ||||||||||||||||
Connection: default /usr/local/bin/gunicorn in <module>(8) sys.exit(run()) /usr/local/lib/python2.7/site-packages/gunicorn/app/wsgiapp.py in run(74) WSGIApplication("%(prog)s [OPTIONS] [APP_MODULE]").run() /usr/local/lib/python2.7/site-packages/gunicorn/app/base.py in run(203) super(Application, self).run() /usr/local/lib/python2.7/site-packages/gunicorn/app/base.py in run(72) Arbiter(self).run() /usr/local/lib/python2.7/site-packages/gunicorn/arbiter.py in run(202) self.manage_workers() /usr/local/lib/python2.7/site-packages/gunicorn/arbiter.py in manage_workers(544) self.spawn_workers() /usr/local/lib/python2.7/site-packages/gunicorn/arbiter.py in spawn_workers(611) self.spawn_worker() /usr/local/lib/python2.7/site-packages/gunicorn/arbiter.py in spawn_worker(578) worker.init_process() /usr/local/lib/python2.7/site-packages/gunicorn/workers/base.py in init_process(131) self.run() /usr/local/lib/python2.7/site-packages/gunicorn/workers/sync.py in run(124) self.run_for_one(timeout) /usr/local/lib/python2.7/site-packages/gunicorn/workers/sync.py in run_for_one(68) self.accept(listener) /usr/local/lib/python2.7/site-packages/gunicorn/workers/sync.py in accept(30) self.handle(listener, client, addr) /usr/local/lib/python2.7/site-packages/gunicorn/workers/sync.py in handle(135) self.handle_request(listener, req, client, addr) /usr/local/lib/python2.7/site-packages/gunicorn/workers/sync.py in handle_request(176) respiter = self.wsgi(environ, resp.start_response) /app/codalab/apps/web/views.py in get(127) return CompetitionDetailView.as_view()(*args, **kwargs) /app/codalab/apps/web/views.py in get(528) return super(CompetitionDetailView, self).get(request, *args, **kwargs) /app/codalab/apps/web/views.py in get_context_data(576) scores = context['active_phase'].scores() /app/codalab/apps/web/models.py in scores(1113) **kwargs).select_related('scoredef', 'parent'): |
|||||||||||||||||||
+ |
SELECT ••• "web_submissionscore"."id", "web_submissionscore"."result_id", "web_submissionscore"."scoredef_id", "web_submissionscore"."value" FROM "web_submissionscore" WHERE ("web_submissionscore"."scoredef_id" IN (10, 11) AND "web_submissionscore"."result_id" IN (478, 505, 506, 515, 524, 527, 531, 533))
|
1.12568586656% |
0.51 | ||||||||||||||||
Connection: default /usr/local/bin/gunicorn in <module>(8) sys.exit(run()) /usr/local/lib/python2.7/site-packages/gunicorn/app/wsgiapp.py in run(74) WSGIApplication("%(prog)s [OPTIONS] [APP_MODULE]").run() /usr/local/lib/python2.7/site-packages/gunicorn/app/base.py in run(203) super(Application, self).run() /usr/local/lib/python2.7/site-packages/gunicorn/app/base.py in run(72) Arbiter(self).run() /usr/local/lib/python2.7/site-packages/gunicorn/arbiter.py in run(202) self.manage_workers() /usr/local/lib/python2.7/site-packages/gunicorn/arbiter.py in manage_workers(544) self.spawn_workers() /usr/local/lib/python2.7/site-packages/gunicorn/arbiter.py in spawn_workers(611) self.spawn_worker() /usr/local/lib/python2.7/site-packages/gunicorn/arbiter.py in spawn_worker(578) worker.init_process() /usr/local/lib/python2.7/site-packages/gunicorn/workers/base.py in init_process(131) self.run() /usr/local/lib/python2.7/site-packages/gunicorn/workers/sync.py in run(124) self.run_for_one(timeout) /usr/local/lib/python2.7/site-packages/gunicorn/workers/sync.py in run_for_one(68) self.accept(listener) /usr/local/lib/python2.7/site-packages/gunicorn/workers/sync.py in accept(30) self.handle(listener, client, addr) /usr/local/lib/python2.7/site-packages/gunicorn/workers/sync.py in handle(135) self.handle_request(listener, req, client, addr) /usr/local/lib/python2.7/site-packages/gunicorn/workers/sync.py in handle_request(176) respiter = self.wsgi(environ, resp.start_response) /app/codalab/apps/web/views.py in get(127) return CompetitionDetailView.as_view()(*args, **kwargs) /app/codalab/apps/web/views.py in get(528) return super(CompetitionDetailView, self).get(request, *args, **kwargs) /app/codalab/apps/web/views.py in get_context_data(576) scores = context['active_phase'].scores() /app/codalab/apps/web/models.py in scores(1184) for s in SubmissionScore.objects.filter(scoredef_id__in=scoredef_ids, result_id__in=submission_ids): |
|||||||||||||||||||
+ |
SELECT ••• "web_competitionphase"."id", "web_competitionphase"."competition_id", "web_competitionphase"."description", "web_competitionphase"."phasenumber", "web_competitionphase"."label", "web_competitionphase"."start_date", "web_competitionphase"."max_submissions", "web_competitionphase"."max_submissions_per_day", "web_competitionphase"."is_scoring_only", "web_competitionphase"."scoring_program", "web_competitionphase"."reference_data", "web_competitionphase"."input_data", "web_competitionphase"."leaderboard_management_mode", "web_competitionphase"."force_best_submission_to_leaderboard", "web_competitionphase"."auto_migration", "web_competitionphase"."is_migrated", "web_competitionphase"."execution_time_limit", "web_competitionphase"."color", "web_competitionphase"."input_data_organizer_dataset_id", "web_competitionphase"."reference_data_organizer_dataset_id", "web_competitionphase"."scoring_program_organizer_dataset_id", "web_competitionphase"."phase_never_ends", "web_competitionphase"."scoring_program_docker_image", "web_competitionphase"."default_docker_image", "web_competitionphase"."disable_custom_docker_image", "web_competitionphase"."starting_kit", "web_competitionphase"."starting_kit_organizer_dataset_id", "web_competitionphase"."public_data", "web_competitionphase"."public_data_organizer_dataset_id", "web_competitionphase"."ingestion_program", "web_competitionphase"."ingestion_program_docker_image", "web_competitionphase"."ingestion_program_organizer_dataset_id" FROM "web_competitionphase" WHERE "web_competitionphase"."competition_id" = 9 ORDER BY "web_competitionphase"."phasenumber" ASC
|
1.01772902834% |
0.46 | ||||||||||||||||
Connection: default /usr/local/bin/gunicorn in <module>(8) sys.exit(run()) /usr/local/lib/python2.7/site-packages/gunicorn/app/wsgiapp.py in run(74) WSGIApplication("%(prog)s [OPTIONS] [APP_MODULE]").run() /usr/local/lib/python2.7/site-packages/gunicorn/app/base.py in run(203) super(Application, self).run() /usr/local/lib/python2.7/site-packages/gunicorn/app/base.py in run(72) Arbiter(self).run() /usr/local/lib/python2.7/site-packages/gunicorn/arbiter.py in run(202) self.manage_workers() /usr/local/lib/python2.7/site-packages/gunicorn/arbiter.py in manage_workers(544) self.spawn_workers() /usr/local/lib/python2.7/site-packages/gunicorn/arbiter.py in spawn_workers(611) self.spawn_worker() /usr/local/lib/python2.7/site-packages/gunicorn/arbiter.py in spawn_worker(578) worker.init_process() /usr/local/lib/python2.7/site-packages/gunicorn/workers/base.py in init_process(131) self.run() /usr/local/lib/python2.7/site-packages/gunicorn/workers/sync.py in run(124) self.run_for_one(timeout) /usr/local/lib/python2.7/site-packages/gunicorn/workers/sync.py in run_for_one(68) self.accept(listener) /usr/local/lib/python2.7/site-packages/gunicorn/workers/sync.py in accept(30) self.handle(listener, client, addr) /usr/local/lib/python2.7/site-packages/gunicorn/workers/sync.py in handle(135) self.handle_request(listener, req, client, addr) /usr/local/lib/python2.7/site-packages/gunicorn/workers/sync.py in handle_request(176) respiter = self.wsgi(environ, resp.start_response) /app/codalab/apps/web/views.py in get(127) return CompetitionDetailView.as_view()(*args, **kwargs) /app/codalab/apps/web/views.py in get(528) return super(CompetitionDetailView, self).get(request, *args, **kwargs) /app/codalab/apps/web/views.py in get_context_data(646) for phase in all_phases: |
|||||||||||||||||||
+ |
SELECT ••• "web_competitionphase"."id", "web_competitionphase"."competition_id", "web_competitionphase"."description", "web_competitionphase"."phasenumber", "web_competitionphase"."label", "web_competitionphase"."start_date", "web_competitionphase"."max_submissions", "web_competitionphase"."max_submissions_per_day", "web_competitionphase"."is_scoring_only", "web_competitionphase"."scoring_program", "web_competitionphase"."reference_data", "web_competitionphase"."input_data", "web_competitionphase"."leaderboard_management_mode", "web_competitionphase"."force_best_submission_to_leaderboard", "web_competitionphase"."auto_migration", "web_competitionphase"."is_migrated", "web_competitionphase"."execution_time_limit", "web_competitionphase"."color", "web_competitionphase"."input_data_organizer_dataset_id", "web_competitionphase"."reference_data_organizer_dataset_id", "web_competitionphase"."scoring_program_organizer_dataset_id", "web_competitionphase"."phase_never_ends", "web_competitionphase"."scoring_program_docker_image", "web_competitionphase"."default_docker_image", "web_competitionphase"."disable_custom_docker_image", "web_competitionphase"."starting_kit", "web_competitionphase"."starting_kit_organizer_dataset_id", "web_competitionphase"."public_data", "web_competitionphase"."public_data_organizer_dataset_id", "web_competitionphase"."ingestion_program", "web_competitionphase"."ingestion_program_docker_image", "web_competitionphase"."ingestion_program_organizer_dataset_id" FROM "web_competitionphase" WHERE ("web_competitionphase"."competition_id" = 9 AND "web_competitionphase"."phasenumber" = 2 ) ORDER BY "web_competitionphase"."phasenumber" ASC
|
0.991525912261% |
0.45 | ||||||||||||||||
Connection: default /usr/local/bin/gunicorn in <module>(8) sys.exit(run()) /usr/local/lib/python2.7/site-packages/gunicorn/app/wsgiapp.py in run(74) WSGIApplication("%(prog)s [OPTIONS] [APP_MODULE]").run() /usr/local/lib/python2.7/site-packages/gunicorn/app/base.py in run(203) super(Application, self).run() /usr/local/lib/python2.7/site-packages/gunicorn/app/base.py in run(72) Arbiter(self).run() /usr/local/lib/python2.7/site-packages/gunicorn/arbiter.py in run(202) self.manage_workers() /usr/local/lib/python2.7/site-packages/gunicorn/arbiter.py in manage_workers(544) self.spawn_workers() /usr/local/lib/python2.7/site-packages/gunicorn/arbiter.py in spawn_workers(611) self.spawn_worker() /usr/local/lib/python2.7/site-packages/gunicorn/arbiter.py in spawn_worker(578) worker.init_process() /usr/local/lib/python2.7/site-packages/gunicorn/workers/base.py in init_process(131) self.run() /usr/local/lib/python2.7/site-packages/gunicorn/workers/sync.py in run(124) self.run_for_one(timeout) /usr/local/lib/python2.7/site-packages/gunicorn/workers/sync.py in run_for_one(68) self.accept(listener) /usr/local/lib/python2.7/site-packages/gunicorn/workers/sync.py in accept(30) self.handle(listener, client, addr) /usr/local/lib/python2.7/site-packages/gunicorn/workers/sync.py in handle(135) self.handle_request(listener, req, client, addr) /usr/local/lib/python2.7/site-packages/gunicorn/workers/sync.py in handle_request(176) respiter = self.wsgi(environ, resp.start_response) /app/codalab/apps/web/views.py in get(127) return CompetitionDetailView.as_view()(*args, **kwargs) /app/codalab/apps/web/views.py in get(528) return super(CompetitionDetailView, self).get(request, *args, **kwargs) /app/codalab/apps/web/views.py in get_context_data(647) if phase.is_active: /app/codalab/apps/web/models.py in is_active(965) if (next_phase is not None) and (len(next_phase) > 0): |
|||||||||||||||||||
+ |
SELECT ••• "web_competitionphase"."id", "web_competitionphase"."competition_id", "web_competitionphase"."description", "web_competitionphase"."phasenumber", "web_competitionphase"."label", "web_competitionphase"."start_date", "web_competitionphase"."max_submissions", "web_competitionphase"."max_submissions_per_day", "web_competitionphase"."is_scoring_only", "web_competitionphase"."scoring_program", "web_competitionphase"."reference_data", "web_competitionphase"."input_data", "web_competitionphase"."leaderboard_management_mode", "web_competitionphase"."force_best_submission_to_leaderboard", "web_competitionphase"."auto_migration", "web_competitionphase"."is_migrated", "web_competitionphase"."execution_time_limit", "web_competitionphase"."color", "web_competitionphase"."input_data_organizer_dataset_id", "web_competitionphase"."reference_data_organizer_dataset_id", "web_competitionphase"."scoring_program_organizer_dataset_id", "web_competitionphase"."phase_never_ends", "web_competitionphase"."scoring_program_docker_image", "web_competitionphase"."default_docker_image", "web_competitionphase"."disable_custom_docker_image", "web_competitionphase"."starting_kit", "web_competitionphase"."starting_kit_organizer_dataset_id", "web_competitionphase"."public_data", "web_competitionphase"."public_data_organizer_dataset_id", "web_competitionphase"."ingestion_program", "web_competitionphase"."ingestion_program_docker_image", "web_competitionphase"."ingestion_program_organizer_dataset_id" FROM "web_competitionphase" WHERE ("web_competitionphase"."competition_id" = 9 AND "web_competitionphase"."phasenumber" = 3 ) ORDER BY "web_competitionphase"."phasenumber" ASC
|
0.855269708674% |
0.39 | ||||||||||||||||
Connection: default /usr/local/bin/gunicorn in <module>(8) sys.exit(run()) /usr/local/lib/python2.7/site-packages/gunicorn/app/wsgiapp.py in run(74) WSGIApplication("%(prog)s [OPTIONS] [APP_MODULE]").run() /usr/local/lib/python2.7/site-packages/gunicorn/app/base.py in run(203) super(Application, self).run() /usr/local/lib/python2.7/site-packages/gunicorn/app/base.py in run(72) Arbiter(self).run() /usr/local/lib/python2.7/site-packages/gunicorn/arbiter.py in run(202) self.manage_workers() /usr/local/lib/python2.7/site-packages/gunicorn/arbiter.py in manage_workers(544) self.spawn_workers() /usr/local/lib/python2.7/site-packages/gunicorn/arbiter.py in spawn_workers(611) self.spawn_worker() /usr/local/lib/python2.7/site-packages/gunicorn/arbiter.py in spawn_worker(578) worker.init_process() /usr/local/lib/python2.7/site-packages/gunicorn/workers/base.py in init_process(131) self.run() /usr/local/lib/python2.7/site-packages/gunicorn/workers/sync.py in run(124) self.run_for_one(timeout) /usr/local/lib/python2.7/site-packages/gunicorn/workers/sync.py in run_for_one(68) self.accept(listener) /usr/local/lib/python2.7/site-packages/gunicorn/workers/sync.py in accept(30) self.handle(listener, client, addr) /usr/local/lib/python2.7/site-packages/gunicorn/workers/sync.py in handle(135) self.handle_request(listener, req, client, addr) /usr/local/lib/python2.7/site-packages/gunicorn/workers/sync.py in handle_request(176) respiter = self.wsgi(environ, resp.start_response) /app/codalab/apps/web/views.py in get(127) return CompetitionDetailView.as_view()(*args, **kwargs) /app/codalab/apps/web/views.py in get(528) return super(CompetitionDetailView, self).get(request, *args, **kwargs) /app/codalab/apps/web/views.py in get_context_data(647) if phase.is_active: /app/codalab/apps/web/models.py in is_active(965) if (next_phase is not None) and (len(next_phase) > 0): |
|||||||||||||||||||
+ |
SELECT ••• "web_competitionphase"."id", "web_competitionphase"."competition_id", "web_competitionphase"."description", "web_competitionphase"."phasenumber", "web_competitionphase"."label", "web_competitionphase"."start_date", "web_competitionphase"."max_submissions", "web_competitionphase"."max_submissions_per_day", "web_competitionphase"."is_scoring_only", "web_competitionphase"."scoring_program", "web_competitionphase"."reference_data", "web_competitionphase"."input_data", "web_competitionphase"."leaderboard_management_mode", "web_competitionphase"."force_best_submission_to_leaderboard", "web_competitionphase"."auto_migration", "web_competitionphase"."is_migrated", "web_competitionphase"."execution_time_limit", "web_competitionphase"."color", "web_competitionphase"."input_data_organizer_dataset_id", "web_competitionphase"."reference_data_organizer_dataset_id", "web_competitionphase"."scoring_program_organizer_dataset_id", "web_competitionphase"."phase_never_ends", "web_competitionphase"."scoring_program_docker_image", "web_competitionphase"."default_docker_image", "web_competitionphase"."disable_custom_docker_image", "web_competitionphase"."starting_kit", "web_competitionphase"."starting_kit_organizer_dataset_id", "web_competitionphase"."public_data", "web_competitionphase"."public_data_organizer_dataset_id", "web_competitionphase"."ingestion_program", "web_competitionphase"."ingestion_program_docker_image", "web_competitionphase"."ingestion_program_organizer_dataset_id" FROM "web_competitionphase" WHERE ("web_competitionphase"."competition_id" = 9 AND "web_competitionphase"."phasenumber" = 4 ) ORDER BY "web_competitionphase"."phasenumber" ASC
|
1.01353652976% |
0.46 | ||||||||||||||||
Connection: default /usr/local/bin/gunicorn in <module>(8) sys.exit(run()) /usr/local/lib/python2.7/site-packages/gunicorn/app/wsgiapp.py in run(74) WSGIApplication("%(prog)s [OPTIONS] [APP_MODULE]").run() /usr/local/lib/python2.7/site-packages/gunicorn/app/base.py in run(203) super(Application, self).run() /usr/local/lib/python2.7/site-packages/gunicorn/app/base.py in run(72) Arbiter(self).run() /usr/local/lib/python2.7/site-packages/gunicorn/arbiter.py in run(202) self.manage_workers() /usr/local/lib/python2.7/site-packages/gunicorn/arbiter.py in manage_workers(544) self.spawn_workers() /usr/local/lib/python2.7/site-packages/gunicorn/arbiter.py in spawn_workers(611) self.spawn_worker() /usr/local/lib/python2.7/site-packages/gunicorn/arbiter.py in spawn_worker(578) worker.init_process() /usr/local/lib/python2.7/site-packages/gunicorn/workers/base.py in init_process(131) self.run() /usr/local/lib/python2.7/site-packages/gunicorn/workers/sync.py in run(124) self.run_for_one(timeout) /usr/local/lib/python2.7/site-packages/gunicorn/workers/sync.py in run_for_one(68) self.accept(listener) /usr/local/lib/python2.7/site-packages/gunicorn/workers/sync.py in accept(30) self.handle(listener, client, addr) /usr/local/lib/python2.7/site-packages/gunicorn/workers/sync.py in handle(135) self.handle_request(listener, req, client, addr) /usr/local/lib/python2.7/site-packages/gunicorn/workers/sync.py in handle_request(176) respiter = self.wsgi(environ, resp.start_response) /app/codalab/apps/web/views.py in get(127) return CompetitionDetailView.as_view()(*args, **kwargs) /app/codalab/apps/web/views.py in get(528) return super(CompetitionDetailView, self).get(request, *args, **kwargs) /app/codalab/apps/web/views.py in get_context_data(647) if phase.is_active: /app/codalab/apps/web/models.py in is_active(965) if (next_phase is not None) and (len(next_phase) > 0): |
|||||||||||||||||||
+ |
SELECT ••• "authenz_cluser"."id", "authenz_cluser"."password", "authenz_cluser"."last_login", "authenz_cluser"."is_superuser", "authenz_cluser"."username", "authenz_cluser"."first_name", "authenz_cluser"."last_name", "authenz_cluser"."email", "authenz_cluser"."is_staff", "authenz_cluser"."is_active", "authenz_cluser"."date_joined", "authenz_cluser"."chahub_timestamp", "authenz_cluser"."chahub_data_hash", "authenz_cluser"."chahub_needs_retry", "authenz_cluser"."participation_status_updates", "authenz_cluser"."organizer_status_updates", "authenz_cluser"."organizer_direct_message_updates", "authenz_cluser"."email_on_submission_finished_successfully", "authenz_cluser"."allow_forum_notifications", "authenz_cluser"."allow_admin_status_updates", "authenz_cluser"."newsletter_opt_in", "authenz_cluser"."organization_or_affiliation", "authenz_cluser"."team_name", "authenz_cluser"."team_members", "authenz_cluser"."method_name", "authenz_cluser"."method_description", "authenz_cluser"."project_url", "authenz_cluser"."publication_url", "authenz_cluser"."bibtex", "authenz_cluser"."contact_email", "authenz_cluser"."rabbitmq_queue_limit", "authenz_cluser"."rabbitmq_username", "authenz_cluser"."rabbitmq_password" FROM "authenz_cluser" WHERE "authenz_cluser"."id" = 1
|
1.02244558923% |
0.47 | ||||||||||||||||
Connection: default /usr/local/bin/gunicorn in <module>(8) sys.exit(run()) /usr/local/lib/python2.7/site-packages/gunicorn/app/wsgiapp.py in run(74) WSGIApplication("%(prog)s [OPTIONS] [APP_MODULE]").run() /usr/local/lib/python2.7/site-packages/gunicorn/app/base.py in run(203) super(Application, self).run() /usr/local/lib/python2.7/site-packages/gunicorn/app/base.py in run(72) Arbiter(self).run() /usr/local/lib/python2.7/site-packages/gunicorn/arbiter.py in run(202) self.manage_workers() /usr/local/lib/python2.7/site-packages/gunicorn/arbiter.py in manage_workers(544) self.spawn_workers() /usr/local/lib/python2.7/site-packages/gunicorn/arbiter.py in spawn_workers(611) self.spawn_worker() /usr/local/lib/python2.7/site-packages/gunicorn/arbiter.py in spawn_worker(578) worker.init_process() /usr/local/lib/python2.7/site-packages/gunicorn/workers/base.py in init_process(131) self.run() /usr/local/lib/python2.7/site-packages/gunicorn/workers/sync.py in run(124) self.run_for_one(timeout) /usr/local/lib/python2.7/site-packages/gunicorn/workers/sync.py in run_for_one(68) self.accept(listener) /usr/local/lib/python2.7/site-packages/gunicorn/workers/sync.py in accept(30) self.handle(listener, client, addr) /usr/local/lib/python2.7/site-packages/gunicorn/workers/sync.py in handle(135) self.handle_request(listener, req, client, addr) /usr/local/lib/python2.7/site-packages/gunicorn/workers/sync.py in handle_request(176) respiter = self.wsgi(environ, resp.start_response) /app/codalab/apps/web/views.py in get(127) return CompetitionDetailView.as_view()(*args, **kwargs) /app/codalab/apps/web/views.py in get(528) return super(CompetitionDetailView, self).get(request, *args, **kwargs) /app/codalab/apps/web/views.py in get_context_data(653) if competition.creator == self.request.user or self.request.user in competition.admins.all(): |
|||||||||||||||||||
+ |
SELECT ••• "authenz_cluser"."id", "authenz_cluser"."password", "authenz_cluser"."last_login", "authenz_cluser"."is_superuser", "authenz_cluser"."username", "authenz_cluser"."first_name", "authenz_cluser"."last_name", "authenz_cluser"."email", "authenz_cluser"."is_staff", "authenz_cluser"."is_active", "authenz_cluser"."date_joined", "authenz_cluser"."chahub_timestamp", "authenz_cluser"."chahub_data_hash", "authenz_cluser"."chahub_needs_retry", "authenz_cluser"."participation_status_updates", "authenz_cluser"."organizer_status_updates", "authenz_cluser"."organizer_direct_message_updates", "authenz_cluser"."email_on_submission_finished_successfully", "authenz_cluser"."allow_forum_notifications", "authenz_cluser"."allow_admin_status_updates", "authenz_cluser"."newsletter_opt_in", "authenz_cluser"."organization_or_affiliation", "authenz_cluser"."team_name", "authenz_cluser"."team_members", "authenz_cluser"."method_name", "authenz_cluser"."method_description", "authenz_cluser"."project_url", "authenz_cluser"."publication_url", "authenz_cluser"."bibtex", "authenz_cluser"."contact_email", "authenz_cluser"."rabbitmq_queue_limit", "authenz_cluser"."rabbitmq_username", "authenz_cluser"."rabbitmq_password" FROM "authenz_cluser" INNER JOIN "web_competition_admins" ON ( "authenz_cluser"."id" = "web_competition_admins"."cluser_id" ) WHERE "web_competition_admins"."competition_id" = 9
|
1.52973791643% |
0.70 | ||||||||||||||||
Connection: default /usr/local/bin/gunicorn in <module>(8) sys.exit(run()) /usr/local/lib/python2.7/site-packages/gunicorn/app/wsgiapp.py in run(74) WSGIApplication("%(prog)s [OPTIONS] [APP_MODULE]").run() /usr/local/lib/python2.7/site-packages/gunicorn/app/base.py in run(203) super(Application, self).run() /usr/local/lib/python2.7/site-packages/gunicorn/app/base.py in run(72) Arbiter(self).run() /usr/local/lib/python2.7/site-packages/gunicorn/arbiter.py in run(202) self.manage_workers() /usr/local/lib/python2.7/site-packages/gunicorn/arbiter.py in manage_workers(544) self.spawn_workers() /usr/local/lib/python2.7/site-packages/gunicorn/arbiter.py in spawn_workers(611) self.spawn_worker() /usr/local/lib/python2.7/site-packages/gunicorn/arbiter.py in spawn_worker(578) worker.init_process() /usr/local/lib/python2.7/site-packages/gunicorn/workers/base.py in init_process(131) self.run() /usr/local/lib/python2.7/site-packages/gunicorn/workers/sync.py in run(124) self.run_for_one(timeout) /usr/local/lib/python2.7/site-packages/gunicorn/workers/sync.py in run_for_one(68) self.accept(listener) /usr/local/lib/python2.7/site-packages/gunicorn/workers/sync.py in accept(30) self.handle(listener, client, addr) /usr/local/lib/python2.7/site-packages/gunicorn/workers/sync.py in handle(135) self.handle_request(listener, req, client, addr) /usr/local/lib/python2.7/site-packages/gunicorn/workers/sync.py in handle_request(176) respiter = self.wsgi(environ, resp.start_response) /app/codalab/apps/web/views.py in get(127) return CompetitionDetailView.as_view()(*args, **kwargs) /app/codalab/apps/web/views.py in get(528) return super(CompetitionDetailView, self).get(request, *args, **kwargs) /app/codalab/apps/web/views.py in get_context_data(653) if competition.creator == self.request.user or self.request.user in competition.admins.all(): |
|||||||||||||||||||
+ |
SELECT ••• "forums_forum"."id", "forums_forum"."competition_id" FROM "forums_forum" WHERE "forums_forum"."competition_id" = 9
|
0.828542530278% |
0.38 | ||||||||||||||||
Connection: default /usr/local/bin/gunicorn in <module>(8) sys.exit(run()) /usr/local/lib/python2.7/site-packages/gunicorn/app/wsgiapp.py in run(74) WSGIApplication("%(prog)s [OPTIONS] [APP_MODULE]").run() /usr/local/lib/python2.7/site-packages/gunicorn/app/base.py in run(203) super(Application, self).run() /usr/local/lib/python2.7/site-packages/gunicorn/app/base.py in run(72) Arbiter(self).run() /usr/local/lib/python2.7/site-packages/gunicorn/arbiter.py in run(202) self.manage_workers() /usr/local/lib/python2.7/site-packages/gunicorn/arbiter.py in manage_workers(544) self.spawn_workers() /usr/local/lib/python2.7/site-packages/gunicorn/arbiter.py in spawn_workers(611) self.spawn_worker() /usr/local/lib/python2.7/site-packages/gunicorn/arbiter.py in spawn_worker(578) worker.init_process() /usr/local/lib/python2.7/site-packages/gunicorn/workers/base.py in init_process(131) self.run() /usr/local/lib/python2.7/site-packages/gunicorn/workers/sync.py in run(124) self.run_for_one(timeout) /usr/local/lib/python2.7/site-packages/gunicorn/workers/sync.py in run_for_one(68) self.accept(listener) /usr/local/lib/python2.7/site-packages/gunicorn/workers/sync.py in accept(30) self.handle(listener, client, addr) /usr/local/lib/python2.7/site-packages/gunicorn/workers/sync.py in handle(135) self.handle_request(listener, req, client, addr) /usr/local/lib/python2.7/site-packages/gunicorn/workers/sync.py in handle_request(176) respiter = self.wsgi(environ, resp.start_response)
/app/codalab/apps/web/templates/web/competitions/view.html |
|||||||||||||||||||
+ |
SELECT ••• "web_competition"."id", "web_competition"."chahub_timestamp", "web_competition"."chahub_data_hash", "web_competition"."chahub_needs_retry", "web_competition"."queue_id", "web_competition"."title", "web_competition"."description", "web_competition"."url_redirect", "web_competition"."image", "web_competition"."image_url_base", "web_competition"."has_registration", "web_competition"."start_date", "web_competition"."end_date", "web_competition"."creator_id", "web_competition"."modified_by_id", "web_competition"."last_modified", "web_competition"."published", "web_competition"."last_phase_migration", "web_competition"."is_migrating", "web_competition"."force_submission_to_leaderboard", "web_competition"."disallow_leaderboard_modifying", "web_competition"."secret_key", "web_competition"."enable_docker_submission", "web_competition"."enable_medical_image_viewer", "web_competition"."enable_detailed_results", "web_competition"."original_yaml_file", "web_competition"."show_datasets_from_yaml", "web_competition"."reward", "web_competition"."is_migrating_delayed", "web_competition"."allow_teams", "web_competition"."enable_per_submission_metadata", "web_competition"."allow_public_submissions", "web_competition"."enable_forum", "web_competition"."anonymous_leaderboard", "web_competition"."enable_teams", "web_competition"."require_team_approval", "web_competition"."hide_top_three", "web_competition"."hide_chart", "web_competition"."allow_organizer_teams", "web_competition"."competition_docker_image", "web_competition"."deleted" FROM "web_competition" WHERE "web_competition"."id" = 9
|
1.224209583% |
0.56 | ||||||||||||||||
Connection: default /usr/local/bin/gunicorn in <module>(8) sys.exit(run()) /usr/local/lib/python2.7/site-packages/gunicorn/app/wsgiapp.py in run(74) WSGIApplication("%(prog)s [OPTIONS] [APP_MODULE]").run() /usr/local/lib/python2.7/site-packages/gunicorn/app/base.py in run(203) super(Application, self).run() /usr/local/lib/python2.7/site-packages/gunicorn/app/base.py in run(72) Arbiter(self).run() /usr/local/lib/python2.7/site-packages/gunicorn/arbiter.py in run(202) self.manage_workers() /usr/local/lib/python2.7/site-packages/gunicorn/arbiter.py in manage_workers(544) self.spawn_workers() /usr/local/lib/python2.7/site-packages/gunicorn/arbiter.py in spawn_workers(611) self.spawn_worker() /usr/local/lib/python2.7/site-packages/gunicorn/arbiter.py in spawn_worker(578) worker.init_process() /usr/local/lib/python2.7/site-packages/gunicorn/workers/base.py in init_process(131) self.run() /usr/local/lib/python2.7/site-packages/gunicorn/workers/sync.py in run(124) self.run_for_one(timeout) /usr/local/lib/python2.7/site-packages/gunicorn/workers/sync.py in run_for_one(68) self.accept(listener) /usr/local/lib/python2.7/site-packages/gunicorn/workers/sync.py in accept(30) self.handle(listener, client, addr) /usr/local/lib/python2.7/site-packages/gunicorn/workers/sync.py in handle(135) self.handle_request(listener, req, client, addr) /usr/local/lib/python2.7/site-packages/gunicorn/workers/sync.py in handle_request(176) respiter = self.wsgi(environ, resp.start_response) /app/codalab/apps/web/models.py in processed_html(667) asset_base_url = "{0}competition_assets/{1}".format(url, self.competition.pk)
/app/codalab/apps/web/templates/web/competitions/_innertabs.html |
|||||||||||||||||||
+ |
SELECT ••• "web_competition"."id", "web_competition"."chahub_timestamp", "web_competition"."chahub_data_hash", "web_competition"."chahub_needs_retry", "web_competition"."queue_id", "web_competition"."title", "web_competition"."description", "web_competition"."url_redirect", "web_competition"."image", "web_competition"."image_url_base", "web_competition"."has_registration", "web_competition"."start_date", "web_competition"."end_date", "web_competition"."creator_id", "web_competition"."modified_by_id", "web_competition"."last_modified", "web_competition"."published", "web_competition"."last_phase_migration", "web_competition"."is_migrating", "web_competition"."force_submission_to_leaderboard", "web_competition"."disallow_leaderboard_modifying", "web_competition"."secret_key", "web_competition"."enable_docker_submission", "web_competition"."enable_medical_image_viewer", "web_competition"."enable_detailed_results", "web_competition"."original_yaml_file", "web_competition"."show_datasets_from_yaml", "web_competition"."reward", "web_competition"."is_migrating_delayed", "web_competition"."allow_teams", "web_competition"."enable_per_submission_metadata", "web_competition"."allow_public_submissions", "web_competition"."enable_forum", "web_competition"."anonymous_leaderboard", "web_competition"."enable_teams", "web_competition"."require_team_approval", "web_competition"."hide_top_three", "web_competition"."hide_chart", "web_competition"."allow_organizer_teams", "web_competition"."competition_docker_image", "web_competition"."deleted" FROM "web_competition" WHERE "web_competition"."id" = 9
|
1.04183589512% |
0.47 | ||||||||||||||||
Connection: default /usr/local/bin/gunicorn in <module>(8) sys.exit(run()) /usr/local/lib/python2.7/site-packages/gunicorn/app/wsgiapp.py in run(74) WSGIApplication("%(prog)s [OPTIONS] [APP_MODULE]").run() /usr/local/lib/python2.7/site-packages/gunicorn/app/base.py in run(203) super(Application, self).run() /usr/local/lib/python2.7/site-packages/gunicorn/app/base.py in run(72) Arbiter(self).run() /usr/local/lib/python2.7/site-packages/gunicorn/arbiter.py in run(202) self.manage_workers() /usr/local/lib/python2.7/site-packages/gunicorn/arbiter.py in manage_workers(544) self.spawn_workers() /usr/local/lib/python2.7/site-packages/gunicorn/arbiter.py in spawn_workers(611) self.spawn_worker() /usr/local/lib/python2.7/site-packages/gunicorn/arbiter.py in spawn_worker(578) worker.init_process() /usr/local/lib/python2.7/site-packages/gunicorn/workers/base.py in init_process(131) self.run() /usr/local/lib/python2.7/site-packages/gunicorn/workers/sync.py in run(124) self.run_for_one(timeout) /usr/local/lib/python2.7/site-packages/gunicorn/workers/sync.py in run_for_one(68) self.accept(listener) /usr/local/lib/python2.7/site-packages/gunicorn/workers/sync.py in accept(30) self.handle(listener, client, addr) /usr/local/lib/python2.7/site-packages/gunicorn/workers/sync.py in handle(135) self.handle_request(listener, req, client, addr) /usr/local/lib/python2.7/site-packages/gunicorn/workers/sync.py in handle_request(176) respiter = self.wsgi(environ, resp.start_response) /app/codalab/apps/web/models.py in processed_html(667) asset_base_url = "{0}competition_assets/{1}".format(url, self.competition.pk)
/app/codalab/apps/web/templates/web/competitions/_innertabs.html |
|||||||||||||||||||
+ |
SELECT ••• "web_competition"."id", "web_competition"."chahub_timestamp", "web_competition"."chahub_data_hash", "web_competition"."chahub_needs_retry", "web_competition"."queue_id", "web_competition"."title", "web_competition"."description", "web_competition"."url_redirect", "web_competition"."image", "web_competition"."image_url_base", "web_competition"."has_registration", "web_competition"."start_date", "web_competition"."end_date", "web_competition"."creator_id", "web_competition"."modified_by_id", "web_competition"."last_modified", "web_competition"."published", "web_competition"."last_phase_migration", "web_competition"."is_migrating", "web_competition"."force_submission_to_leaderboard", "web_competition"."disallow_leaderboard_modifying", "web_competition"."secret_key", "web_competition"."enable_docker_submission", "web_competition"."enable_medical_image_viewer", "web_competition"."enable_detailed_results", "web_competition"."original_yaml_file", "web_competition"."show_datasets_from_yaml", "web_competition"."reward", "web_competition"."is_migrating_delayed", "web_competition"."allow_teams", "web_competition"."enable_per_submission_metadata", "web_competition"."allow_public_submissions", "web_competition"."enable_forum", "web_competition"."anonymous_leaderboard", "web_competition"."enable_teams", "web_competition"."require_team_approval", "web_competition"."hide_top_three", "web_competition"."hide_chart", "web_competition"."allow_organizer_teams", "web_competition"."competition_docker_image", "web_competition"."deleted" FROM "web_competition" WHERE "web_competition"."id" = 9
|
0.936499368505% |
0.43 | ||||||||||||||||
Connection: default /usr/local/bin/gunicorn in <module>(8) sys.exit(run()) /usr/local/lib/python2.7/site-packages/gunicorn/app/wsgiapp.py in run(74) WSGIApplication("%(prog)s [OPTIONS] [APP_MODULE]").run() /usr/local/lib/python2.7/site-packages/gunicorn/app/base.py in run(203) super(Application, self).run() /usr/local/lib/python2.7/site-packages/gunicorn/app/base.py in run(72) Arbiter(self).run() /usr/local/lib/python2.7/site-packages/gunicorn/arbiter.py in run(202) self.manage_workers() /usr/local/lib/python2.7/site-packages/gunicorn/arbiter.py in manage_workers(544) self.spawn_workers() /usr/local/lib/python2.7/site-packages/gunicorn/arbiter.py in spawn_workers(611) self.spawn_worker() /usr/local/lib/python2.7/site-packages/gunicorn/arbiter.py in spawn_worker(578) worker.init_process() /usr/local/lib/python2.7/site-packages/gunicorn/workers/base.py in init_process(131) self.run() /usr/local/lib/python2.7/site-packages/gunicorn/workers/sync.py in run(124) self.run_for_one(timeout) /usr/local/lib/python2.7/site-packages/gunicorn/workers/sync.py in run_for_one(68) self.accept(listener) /usr/local/lib/python2.7/site-packages/gunicorn/workers/sync.py in accept(30) self.handle(listener, client, addr) /usr/local/lib/python2.7/site-packages/gunicorn/workers/sync.py in handle(135) self.handle_request(listener, req, client, addr) /usr/local/lib/python2.7/site-packages/gunicorn/workers/sync.py in handle_request(176) respiter = self.wsgi(environ, resp.start_response) /app/codalab/apps/web/models.py in processed_html(667) asset_base_url = "{0}competition_assets/{1}".format(url, self.competition.pk)
/app/codalab/apps/web/templates/web/competitions/_innertabs.html |
|||||||||||||||||||
+ |
SELECT ••• "web_competition"."id", "web_competition"."chahub_timestamp", "web_competition"."chahub_data_hash", "web_competition"."chahub_needs_retry", "web_competition"."queue_id", "web_competition"."title", "web_competition"."description", "web_competition"."url_redirect", "web_competition"."image", "web_competition"."image_url_base", "web_competition"."has_registration", "web_competition"."start_date", "web_competition"."end_date", "web_competition"."creator_id", "web_competition"."modified_by_id", "web_competition"."last_modified", "web_competition"."published", "web_competition"."last_phase_migration", "web_competition"."is_migrating", "web_competition"."force_submission_to_leaderboard", "web_competition"."disallow_leaderboard_modifying", "web_competition"."secret_key", "web_competition"."enable_docker_submission", "web_competition"."enable_medical_image_viewer", "web_competition"."enable_detailed_results", "web_competition"."original_yaml_file", "web_competition"."show_datasets_from_yaml", "web_competition"."reward", "web_competition"."is_migrating_delayed", "web_competition"."allow_teams", "web_competition"."enable_per_submission_metadata", "web_competition"."allow_public_submissions", "web_competition"."enable_forum", "web_competition"."anonymous_leaderboard", "web_competition"."enable_teams", "web_competition"."require_team_approval", "web_competition"."hide_top_three", "web_competition"."hide_chart", "web_competition"."allow_organizer_teams", "web_competition"."competition_docker_image", "web_competition"."deleted" FROM "web_competition" WHERE "web_competition"."id" = 9
|
1.01091621816% |
0.46 | ||||||||||||||||
Connection: default /usr/local/bin/gunicorn in <module>(8) sys.exit(run()) /usr/local/lib/python2.7/site-packages/gunicorn/app/wsgiapp.py in run(74) WSGIApplication("%(prog)s [OPTIONS] [APP_MODULE]").run() /usr/local/lib/python2.7/site-packages/gunicorn/app/base.py in run(203) super(Application, self).run() /usr/local/lib/python2.7/site-packages/gunicorn/app/base.py in run(72) Arbiter(self).run() /usr/local/lib/python2.7/site-packages/gunicorn/arbiter.py in run(202) self.manage_workers() /usr/local/lib/python2.7/site-packages/gunicorn/arbiter.py in manage_workers(544) self.spawn_workers() /usr/local/lib/python2.7/site-packages/gunicorn/arbiter.py in spawn_workers(611) self.spawn_worker() /usr/local/lib/python2.7/site-packages/gunicorn/arbiter.py in spawn_worker(578) worker.init_process() /usr/local/lib/python2.7/site-packages/gunicorn/workers/base.py in init_process(131) self.run() /usr/local/lib/python2.7/site-packages/gunicorn/workers/sync.py in run(124) self.run_for_one(timeout) /usr/local/lib/python2.7/site-packages/gunicorn/workers/sync.py in run_for_one(68) self.accept(listener) /usr/local/lib/python2.7/site-packages/gunicorn/workers/sync.py in accept(30) self.handle(listener, client, addr) /usr/local/lib/python2.7/site-packages/gunicorn/workers/sync.py in handle(135) self.handle_request(listener, req, client, addr) /usr/local/lib/python2.7/site-packages/gunicorn/workers/sync.py in handle_request(176) respiter = self.wsgi(environ, resp.start_response) /app/codalab/apps/web/models.py in processed_html(667) asset_base_url = "{0}competition_assets/{1}".format(url, self.competition.pk)
/app/codalab/apps/web/templates/web/competitions/_innertabs.html |
|||||||||||||||||||
+ |
SELECT ••• "web_competition"."id", "web_competition"."chahub_timestamp", "web_competition"."chahub_data_hash", "web_competition"."chahub_needs_retry", "web_competition"."queue_id", "web_competition"."title", "web_competition"."description", "web_competition"."url_redirect", "web_competition"."image", "web_competition"."image_url_base", "web_competition"."has_registration", "web_competition"."start_date", "web_competition"."end_date", "web_competition"."creator_id", "web_competition"."modified_by_id", "web_competition"."last_modified", "web_competition"."published", "web_competition"."last_phase_migration", "web_competition"."is_migrating", "web_competition"."force_submission_to_leaderboard", "web_competition"."disallow_leaderboard_modifying", "web_competition"."secret_key", "web_competition"."enable_docker_submission", "web_competition"."enable_medical_image_viewer", "web_competition"."enable_detailed_results", "web_competition"."original_yaml_file", "web_competition"."show_datasets_from_yaml", "web_competition"."reward", "web_competition"."is_migrating_delayed", "web_competition"."allow_teams", "web_competition"."enable_per_submission_metadata", "web_competition"."allow_public_submissions", "web_competition"."enable_forum", "web_competition"."anonymous_leaderboard", "web_competition"."enable_teams", "web_competition"."require_team_approval", "web_competition"."hide_top_three", "web_competition"."hide_chart", "web_competition"."allow_organizer_teams", "web_competition"."competition_docker_image", "web_competition"."deleted" FROM "web_competition" WHERE "web_competition"."id" = 9
|
1.21530052354% |
0.55 | ||||||||||||||||
Connection: default /usr/local/bin/gunicorn in <module>(8) sys.exit(run()) /usr/local/lib/python2.7/site-packages/gunicorn/app/wsgiapp.py in run(74) WSGIApplication("%(prog)s [OPTIONS] [APP_MODULE]").run() /usr/local/lib/python2.7/site-packages/gunicorn/app/base.py in run(203) super(Application, self).run() /usr/local/lib/python2.7/site-packages/gunicorn/app/base.py in run(72) Arbiter(self).run() /usr/local/lib/python2.7/site-packages/gunicorn/arbiter.py in run(202) self.manage_workers() /usr/local/lib/python2.7/site-packages/gunicorn/arbiter.py in manage_workers(544) self.spawn_workers() /usr/local/lib/python2.7/site-packages/gunicorn/arbiter.py in spawn_workers(611) self.spawn_worker() /usr/local/lib/python2.7/site-packages/gunicorn/arbiter.py in spawn_worker(578) worker.init_process() /usr/local/lib/python2.7/site-packages/gunicorn/workers/base.py in init_process(131) self.run() /usr/local/lib/python2.7/site-packages/gunicorn/workers/sync.py in run(124) self.run_for_one(timeout) /usr/local/lib/python2.7/site-packages/gunicorn/workers/sync.py in run_for_one(68) self.accept(listener) /usr/local/lib/python2.7/site-packages/gunicorn/workers/sync.py in accept(30) self.handle(listener, client, addr) /usr/local/lib/python2.7/site-packages/gunicorn/workers/sync.py in handle(135) self.handle_request(listener, req, client, addr) /usr/local/lib/python2.7/site-packages/gunicorn/workers/sync.py in handle_request(176) respiter = self.wsgi(environ, resp.start_response) /app/codalab/apps/web/models.py in processed_html(667) asset_base_url = "{0}competition_assets/{1}".format(url, self.competition.pk)
/app/codalab/apps/web/templates/web/competitions/_innertabs.html |
|||||||||||||||||||
+ |
SELECT ••• "web_competitionphase"."id", "web_competitionphase"."competition_id", "web_competitionphase"."description", "web_competitionphase"."phasenumber", "web_competitionphase"."label", "web_competitionphase"."start_date", "web_competitionphase"."max_submissions", "web_competitionphase"."max_submissions_per_day", "web_competitionphase"."is_scoring_only", "web_competitionphase"."scoring_program", "web_competitionphase"."reference_data", "web_competitionphase"."input_data", "web_competitionphase"."leaderboard_management_mode", "web_competitionphase"."force_best_submission_to_leaderboard", "web_competitionphase"."auto_migration", "web_competitionphase"."is_migrated", "web_competitionphase"."execution_time_limit", "web_competitionphase"."color", "web_competitionphase"."input_data_organizer_dataset_id", "web_competitionphase"."reference_data_organizer_dataset_id", "web_competitionphase"."scoring_program_organizer_dataset_id", "web_competitionphase"."phase_never_ends", "web_competitionphase"."scoring_program_docker_image", "web_competitionphase"."default_docker_image", "web_competitionphase"."disable_custom_docker_image", "web_competitionphase"."starting_kit", "web_competitionphase"."starting_kit_organizer_dataset_id", "web_competitionphase"."public_data", "web_competitionphase"."public_data_organizer_dataset_id", "web_competitionphase"."ingestion_program", "web_competitionphase"."ingestion_program_docker_image", "web_competitionphase"."ingestion_program_organizer_dataset_id" FROM "web_competitionphase" WHERE "web_competitionphase"."competition_id" = 9 ORDER BY "web_competitionphase"."phasenumber" ASC
|
1.25932175854% |
0.57 | ||||||||||||||||
Connection: default /usr/local/bin/gunicorn in <module>(8) sys.exit(run()) /usr/local/lib/python2.7/site-packages/gunicorn/app/wsgiapp.py in run(74) WSGIApplication("%(prog)s [OPTIONS] [APP_MODULE]").run() /usr/local/lib/python2.7/site-packages/gunicorn/app/base.py in run(203) super(Application, self).run() /usr/local/lib/python2.7/site-packages/gunicorn/app/base.py in run(72) Arbiter(self).run() /usr/local/lib/python2.7/site-packages/gunicorn/arbiter.py in run(202) self.manage_workers() /usr/local/lib/python2.7/site-packages/gunicorn/arbiter.py in manage_workers(544) self.spawn_workers() /usr/local/lib/python2.7/site-packages/gunicorn/arbiter.py in spawn_workers(611) self.spawn_worker() /usr/local/lib/python2.7/site-packages/gunicorn/arbiter.py in spawn_worker(578) worker.init_process() /usr/local/lib/python2.7/site-packages/gunicorn/workers/base.py in init_process(131) self.run() /usr/local/lib/python2.7/site-packages/gunicorn/workers/sync.py in run(124) self.run_for_one(timeout) /usr/local/lib/python2.7/site-packages/gunicorn/workers/sync.py in run_for_one(68) self.accept(listener) /usr/local/lib/python2.7/site-packages/gunicorn/workers/sync.py in accept(30) self.handle(listener, client, addr) /usr/local/lib/python2.7/site-packages/gunicorn/workers/sync.py in handle(135) self.handle_request(listener, req, client, addr) /usr/local/lib/python2.7/site-packages/gunicorn/workers/sync.py in handle_request(176) respiter = self.wsgi(environ, resp.start_response)
/app/codalab/apps/web/templates/web/competitions/view.html |
|||||||||||||||||||
+ |
SELECT ••• "web_competitionphase"."id", "web_competitionphase"."competition_id", "web_competitionphase"."description", "web_competitionphase"."phasenumber", "web_competitionphase"."label", "web_competitionphase"."start_date", "web_competitionphase"."max_submissions", "web_competitionphase"."max_submissions_per_day", "web_competitionphase"."is_scoring_only", "web_competitionphase"."scoring_program", "web_competitionphase"."reference_data", "web_competitionphase"."input_data", "web_competitionphase"."leaderboard_management_mode", "web_competitionphase"."force_best_submission_to_leaderboard", "web_competitionphase"."auto_migration", "web_competitionphase"."is_migrated", "web_competitionphase"."execution_time_limit", "web_competitionphase"."color", "web_competitionphase"."input_data_organizer_dataset_id", "web_competitionphase"."reference_data_organizer_dataset_id", "web_competitionphase"."scoring_program_organizer_dataset_id", "web_competitionphase"."phase_never_ends", "web_competitionphase"."scoring_program_docker_image", "web_competitionphase"."default_docker_image", "web_competitionphase"."disable_custom_docker_image", "web_competitionphase"."starting_kit", "web_competitionphase"."starting_kit_organizer_dataset_id", "web_competitionphase"."public_data", "web_competitionphase"."public_data_organizer_dataset_id", "web_competitionphase"."ingestion_program", "web_competitionphase"."ingestion_program_docker_image", "web_competitionphase"."ingestion_program_organizer_dataset_id" FROM "web_competitionphase" WHERE "web_competitionphase"."competition_id" = 9 ORDER BY "web_competitionphase"."phasenumber" ASC
|
1.08795337942% |
0.49 | ||||||||||||||||
Connection: default /usr/local/bin/gunicorn in <module>(8) sys.exit(run()) /usr/local/lib/python2.7/site-packages/gunicorn/app/wsgiapp.py in run(74) WSGIApplication("%(prog)s [OPTIONS] [APP_MODULE]").run() /usr/local/lib/python2.7/site-packages/gunicorn/app/base.py in run(203) super(Application, self).run() /usr/local/lib/python2.7/site-packages/gunicorn/app/base.py in run(72) Arbiter(self).run() /usr/local/lib/python2.7/site-packages/gunicorn/arbiter.py in run(202) self.manage_workers() /usr/local/lib/python2.7/site-packages/gunicorn/arbiter.py in manage_workers(544) self.spawn_workers() /usr/local/lib/python2.7/site-packages/gunicorn/arbiter.py in spawn_workers(611) self.spawn_worker() /usr/local/lib/python2.7/site-packages/gunicorn/arbiter.py in spawn_worker(578) worker.init_process() /usr/local/lib/python2.7/site-packages/gunicorn/workers/base.py in init_process(131) self.run() /usr/local/lib/python2.7/site-packages/gunicorn/workers/sync.py in run(124) self.run_for_one(timeout) /usr/local/lib/python2.7/site-packages/gunicorn/workers/sync.py in run_for_one(68) self.accept(listener) /usr/local/lib/python2.7/site-packages/gunicorn/workers/sync.py in accept(30) self.handle(listener, client, addr) /usr/local/lib/python2.7/site-packages/gunicorn/workers/sync.py in handle(135) self.handle_request(listener, req, client, addr) /usr/local/lib/python2.7/site-packages/gunicorn/workers/sync.py in handle_request(176) respiter = self.wsgi(environ, resp.start_response)
/app/codalab/apps/web/templates/web/competitions/_results.html |
|||||||||||||||||||
+ |
SELECT ••• "web_competitionphase"."id", "web_competitionphase"."competition_id", "web_competitionphase"."description", "web_competitionphase"."phasenumber", "web_competitionphase"."label", "web_competitionphase"."start_date", "web_competitionphase"."max_submissions", "web_competitionphase"."max_submissions_per_day", "web_competitionphase"."is_scoring_only", "web_competitionphase"."scoring_program", "web_competitionphase"."reference_data", "web_competitionphase"."input_data", "web_competitionphase"."leaderboard_management_mode", "web_competitionphase"."force_best_submission_to_leaderboard", "web_competitionphase"."auto_migration", "web_competitionphase"."is_migrated", "web_competitionphase"."execution_time_limit", "web_competitionphase"."color", "web_competitionphase"."input_data_organizer_dataset_id", "web_competitionphase"."reference_data_organizer_dataset_id", "web_competitionphase"."scoring_program_organizer_dataset_id", "web_competitionphase"."phase_never_ends", "web_competitionphase"."scoring_program_docker_image", "web_competitionphase"."default_docker_image", "web_competitionphase"."disable_custom_docker_image", "web_competitionphase"."starting_kit", "web_competitionphase"."starting_kit_organizer_dataset_id", "web_competitionphase"."public_data", "web_competitionphase"."public_data_organizer_dataset_id", "web_competitionphase"."ingestion_program", "web_competitionphase"."ingestion_program_docker_image", "web_competitionphase"."ingestion_program_organizer_dataset_id" FROM "web_competitionphase" WHERE ("web_competitionphase"."competition_id" = 9 AND "web_competitionphase"."phasenumber" = 2 ) ORDER BY "web_competitionphase"."phasenumber" ASC
|
0.931782807611% |
0.42 | ||||||||||||||||
Connection: default /usr/local/bin/gunicorn in <module>(8) sys.exit(run()) /usr/local/lib/python2.7/site-packages/gunicorn/app/wsgiapp.py in run(74) WSGIApplication("%(prog)s [OPTIONS] [APP_MODULE]").run() /usr/local/lib/python2.7/site-packages/gunicorn/app/base.py in run(203) super(Application, self).run() /usr/local/lib/python2.7/site-packages/gunicorn/app/base.py in run(72) Arbiter(self).run() /usr/local/lib/python2.7/site-packages/gunicorn/arbiter.py in run(202) self.manage_workers() /usr/local/lib/python2.7/site-packages/gunicorn/arbiter.py in manage_workers(544) self.spawn_workers() /usr/local/lib/python2.7/site-packages/gunicorn/arbiter.py in spawn_workers(611) self.spawn_worker() /usr/local/lib/python2.7/site-packages/gunicorn/arbiter.py in spawn_worker(578) worker.init_process() /usr/local/lib/python2.7/site-packages/gunicorn/workers/base.py in init_process(131) self.run() /usr/local/lib/python2.7/site-packages/gunicorn/workers/sync.py in run(124) self.run_for_one(timeout) /usr/local/lib/python2.7/site-packages/gunicorn/workers/sync.py in run_for_one(68) self.accept(listener) /usr/local/lib/python2.7/site-packages/gunicorn/workers/sync.py in accept(30) self.handle(listener, client, addr) /usr/local/lib/python2.7/site-packages/gunicorn/workers/sync.py in handle(135) self.handle_request(listener, req, client, addr) /usr/local/lib/python2.7/site-packages/gunicorn/workers/sync.py in handle_request(176) respiter = self.wsgi(environ, resp.start_response) /app/codalab/apps/web/models.py in is_active(965) if (next_phase is not None) and (len(next_phase) > 0):
/app/codalab/apps/web/templates/web/competitions/_results.html |
|||||||||||||||||||
+ |
SELECT ••• "web_competitionphase"."id", "web_competitionphase"."competition_id", "web_competitionphase"."description", "web_competitionphase"."phasenumber", "web_competitionphase"."label", "web_competitionphase"."start_date", "web_competitionphase"."max_submissions", "web_competitionphase"."max_submissions_per_day", "web_competitionphase"."is_scoring_only", "web_competitionphase"."scoring_program", "web_competitionphase"."reference_data", "web_competitionphase"."input_data", "web_competitionphase"."leaderboard_management_mode", "web_competitionphase"."force_best_submission_to_leaderboard", "web_competitionphase"."auto_migration", "web_competitionphase"."is_migrated", "web_competitionphase"."execution_time_limit", "web_competitionphase"."color", "web_competitionphase"."input_data_organizer_dataset_id", "web_competitionphase"."reference_data_organizer_dataset_id", "web_competitionphase"."scoring_program_organizer_dataset_id", "web_competitionphase"."phase_never_ends", "web_competitionphase"."scoring_program_docker_image", "web_competitionphase"."default_docker_image", "web_competitionphase"."disable_custom_docker_image", "web_competitionphase"."starting_kit", "web_competitionphase"."starting_kit_organizer_dataset_id", "web_competitionphase"."public_data", "web_competitionphase"."public_data_organizer_dataset_id", "web_competitionphase"."ingestion_program", "web_competitionphase"."ingestion_program_docker_image", "web_competitionphase"."ingestion_program_organizer_dataset_id" FROM "web_competitionphase" |