Aggregate  (cost=45.77..45.78 rows=1 width=8) (actual time=202326.210..202326.214 rows=1 loops=1)
  ->  Unique  (cost=0.88..45.76 rows=1 width=1052) (actual time=10492.963..202326.205 rows=1 loops=1)
        ->  Nested Loop  (cost=0.88..45.75 rows=1 width=1052) (actual time=10492.959..202326.188 rows=8 loops=1)
              Join Filter: ("DataRepo_peakdata".id = "DataRepo_peakdatalabel".peak_data_id)
              Rows Removed by Join Filter: 3076
              ->  Nested Loop  (cost=0.62..37.47 rows=1 width=8) (actual time=10492.455..202323.935 rows=8 loops=1)
                    Join Filter: ("DataRepo_peakgroup".id = "DataRepo_peakdata".peak_group_id)
                    Rows Removed by Join Filter: 7888
                    ->  Index Scan using "DataRepo_peakdata_peak_group_id_4dd87f4a" on "DataRepo_peakdata"  (cost=0.25..8.26 rows=1 width=8) (actual time=0.017..7.149 rows=7896 loops=1)
                    ->  Nested Loop  (cost=0.38..29.20 rows=1 width=4) (actual time=2.942..25.621 rows=1 loops=7896)
                          Join Filter: ("DataRepo_peakgroup".peak_annotation_file_id = "DataRepo_archivefile".id)
                          ->  Nested Loop  (cost=0.38..18.43 rows=1 width=8) (actual time=2.935..25.614 rows=1 loops=7896)
                                Join Filter: ("DataRepo_msrun".sample_id = "DataRepo_sample".id)
                                Rows Removed by Join Filter: 83
                                ->  Nested Loop  (cost=0.12..10.15 rows=1 width=12) (actual time=0.028..2.513 rows=84 loops=7896)
                                      Join Filter: ("DataRepo_peakgroup".msrun_id = "DataRepo_msrun".id)
                                      Rows Removed by Join Filter: 3486
                                      ->  Index Scan using "DataRepo_peakgroup_peak_annotation_file_id_6dc2fc25" on "DataRepo_peakgroup"  (cost=0.12..8.14 rows=1 width=12) (actual time=0.006..0.464 rows=84 loops=7896)
                                            Filter: ((name)::text = 'serine'::text)",)
                                            Rows Removed by Filter: 1008
                                      ->  Seq Scan on "DataRepo_msrun"  (cost=0.00..2.00 rows=1 width=8) (actual time=0.013..0.017 rows=42 loops=663264)
                                ->  Index Scan using "DataRepo_sample_pkey" on "DataRepo_sample"  (cost=0.25..8.27 rows=1 width=4) (actual time=0.194..0.275 rows=1 loops=663264)
                                      Filter: ((name)::text = 'xzl5_panc'::text)",)
                                      Rows Removed by Filter: 281
                          ->  Seq Scan on "DataRepo_archivefile"  (cost=0.00..10.75 rows=1 width=4) (actual time=0.002..0.002 rows=1 loops=7896)
                                Filter: ((filename)::text = 'alafasted_cor.xlsx'::text)",)
              ->  Index Scan using "DataRepo_peakdatalabel_peak_data_id_f6151d4a" on "DataRepo_peakdatalabel"  (cost=0.25..8.27 rows=1 width=12) (actual time=0.007..0.217 rows=386 loops=8)
                    Filter: ((element)::text = 'C'::text)",)
                    Rows Removed by Filter: 180
Planning Time: 0.963 ms
Execution Time: 202327.334 ms


Aggregate  (cost=99.01..99.02 rows=1 width=8) (actual time=1.399..1.403 rows=1 loops=1)
  ->  Unique  (cost=98.99..99.00 rows=1 width=1052) (actual time=1.390..1.398 rows=1 loops=1)
        ->  Sort  (cost=98.99..99.00 rows=1 width=1052) (actual time=1.389..1.393 rows=8 loops=1)
              Sort Key: "DataRepo_peakgroup".id
              Sort Method: quicksort  Memory: 25kB
              ->  Nested Loop  (cost=5.36..98.98 rows=1 width=1052) (actual time=0.261..1.377 rows=8 loops=1)
                    ->  Nested Loop  (cost=5.08..80.19 rows=51 width=8) (actual time=0.152..1.234 rows=8 loops=1)
                          ->  Nested Loop  (cost=0.55..28.36 rows=1 width=4) (actual time=0.138..1.214 rows=1 loops=1)
                                ->  Nested Loop  (cost=0.29..27.20 rows=1 width=8) (actual time=0.061..0.873 rows=84 loops=1)
                                      ->  Nested Loop  (cost=0.14..18.92 rows=1 width=8) (actual time=0.048..0.667 rows=84 loops=1)
                                            ->  Seq Scan on "DataRepo_archivefile"  (cost=0.00..10.75 rows=1 width=4) (actual time=0.011..0.012 rows=1 loops=1)
                                                  Filter: ((filename)::text = 'alafasted_cor.xlsx'::text)",)
                                            ->  Index Scan using "DataRepo_peakgroup_peak_annotation_file_id_6dc2fc25" on "DataRepo_peakgroup"  (cost=0.14..8.16 rows=1 width=12) (actual time=0.035..0.634 rows=84 loops=1)
                                                  Index Cond: (peak_annotation_file_id = "DataRepo_archivefile".id)
                                                  Filter: ((name)::text = 'serine'::text)",)
                                                  Rows Removed by Filter: 1008
                                      ->  Index Scan using "DataRepo_msrun_pkey" on "DataRepo_msrun"  (cost=0.14..8.16 rows=1 width=8) (actual time=0.002..0.002 rows=1 loops=84)
                                            Index Cond: (id = "DataRepo_peakgroup".msrun_id)
                                ->  Index Scan using "DataRepo_sample_pkey" on "DataRepo_sample"  (cost=0.27..0.72 rows=1 width=4) (actual time=0.004..0.004 rows=0 loops=84)
                                      Index Cond: (id = "DataRepo_msrun".sample_id)
                                      Filter: ((name)::text = 'xzl5_panc'::text)",)
                                      Rows Removed by Filter: 1
                          ->  Bitmap Heap Scan on "DataRepo_peakdata"  (cost=4.52..51.52 rows=31 width=8) (actual time=0.010..0.012 rows=8 loops=1)
                                Recheck Cond: (peak_group_id = "DataRepo_peakgroup".id)
                                Heap Blocks: exact=1
                                ->  Bitmap Index Scan on "DataRepo_peakdata_peak_group_id_4dd87f4a"  (cost=0.00..4.51 rows=31 width=0) (actual time=0.005..0.005 rows=8 loops=1)
                                      Index Cond: (peak_group_id = "DataRepo_peakgroup".id)
                    ->  Index Only Scan using unique_peakdata on "DataRepo_peakdatalabel"  (cost=0.29..0.37 rows=1 width=12) (actual time=0.017..0.017 rows=1 loops=8)
                          Index Cond: ((peak_data_id = "DataRepo_peakdata".id) AND (element = \'C\'::text))
                          Heap Fetches: 8
Planning Time: 1.195 ms
Execution Time: 1.566 ms