gist:9b249c0c9529388bd19c

                                                                                     QUERY PLAN                                                                                     
------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
 GroupAggregate  (cost=20016.16..20289.64 rows=252 width=41)
   ->  GroupAggregate  (cost=20016.16..20223.62 rows=2515 width=59)
         ->  Sort  (cost=20016.16..20028.73 rows=5029 width=59)
               Sort Key: dispatch_slr_task_result.slr_id, dispatch_slr_task_result.start_time, dispatch_slr_task_result.key, dispatch_slr.min_checked, dispatch_slr.min_failure_pct
               ->  Nested Loop  (cost=0.56..19706.97 rows=5029 width=59)
                     ->  Seq Scan on dispatch_slr  (cost=0.00..1.11 rows=11 width=8)
                     ->  Index Scan using dispatch_slr_task_result_slr_id_start_time_idx on dispatch_slr_task_result  (cost=0.56..1

lennax

#!/usr/bin/env python
# Copyright (c) 2014 Lenna X. Peterson, all rights reserved
# lenna@purdue.edu

import argparse
import csv
import glob
import logging
import math
import os

lennax

#!/usr/bin/env python

from __future__ import division

import argparse
import glob
import inspect
import logging
import os