#	exclusive	inclusive	rows x	rows	loops	node
1.	0.186	118.368	↓ 267.0	267	1	→ Sort (cost=57,931.26..57,931.27 rows=1 width=227) (actual time=118.353..118.368 rows=267 loops=1) Sort Key: plate.plate_number, copy.name Sort Method: quicksort Memory: 95kB
2.						CTE plate_cte
3.	0.285	1.245	↑ 1.0	267	1	→ Hash Join (cost=909.53..1,661.37 rows=267 width=29) (actual time=0.830..1.245 rows=267 loops=1) Hash Cond: (copy_1.library_id = library_1.library_id)
4.	0.060	0.865	↑ 1.0	267	1	→ Hash Join (cost=882.93..1,629.09 rows=267 width=18) (actual time=0.724..0.865 rows=267 loops=1) Hash Cond: (plate_1.copy_id = copy_1.copy_id)
5.	0.094	0.309	↑ 1.0	267	1	→ Bitmap Heap Scan on plate plate_1 (cost=795.50..1,537.99 rows=267 width=12) (actual time=0.224..0.309 rows=267 loops=1) Recheck Cond: (plate_id = ANY ('{1293,1296,1297,1298,1310,1311,1314,1316,1317,1318,1319,1320,1323,1328,1329,1331,1340,1505,1506,1507,1513,1515,1517,1524,1532,1541,1562,1573,1575,1601,1620,1653,1654,1656,1657,1661,1662,1663,1664,1667,1668,1669,1671,1672,1674,1676,1677,1678,1679,1680,1682,1685,1689,1694,1696,1697,1776,1777,1780,1781,1784,1790,1791,1801,1817,1818,1819,1822,1825,1826,1827,1828,1830,1831,1832,1833,1834,1836,1837,1838,1839,1840,1841,1846,1878,1880,1889,1890,1893,1898,1900,1902,1903,1908,1909,1910,1911,1912,1926,1930,1932,1936,1937,1975,1977,1981,1985,1998,2002,2015,2035,2036,2041,2042,2048,2052,2064,2067,2068,2073,2261,2266,2338,2340,2687,2688,2693,2696,2699,2700,2701,2705,2707,2709,2711,2713,2807,2814,2815,3205,4057,4065,4069,8674,8694,13233,13256,13311,13315,13317,13318,14103,14298,14299,14301,14304,14305,17719,17724,17725,17730,17732,17733,17734,17736,17740,17741,17743,17744,17747,17749,19232,19236,19240,19241,19246,19250,19253,19254,19255,19256,19259,19263,19269,19270,19273,19280,19281,19284,19285,19288,19294,19299,19300,19301,19586,19587,19588,19589,19590,19591,20416,20418,20422,20428,20433,20434,20441,20456,20961,20962,20963,20964,20965,20966,20967,20972,20973,20974,20976,20977,20984,22206,22852,22854,22856,22858,22859,22860,22861,24157,24158,24159,24163,24519,24520,24521,24523,24524,28246,28247,28248,28249,28254,28330,28348,28350,28355,28357,28371,28373,28377,28381,28384,28391,28396,28398,28399,28402,28408,28419,28440,28443,28444,28445,28448,28454}'::integer[])) Heap Blocks: exact=81
6.	0.215	0.215	↑ 1.0	267	1	→ Bitmap Index Scan on plate_pkey (cost=0.00..795.43 rows=267 width=0) (actual time=0.215..0.215 rows=267 loops=1) Index Cond: (plate_id = ANY ('{1293,1296,1297,1298,1310,1311,1314,1316,1317,1318,1319,1320,1323,1328,1329,1331,1340,1505,1506,1507,1513,1515,1517,1524,1532,1541,1562,1573,1575,1601,1620,1653,1654,1656,1657,1661,1662,1663,1664,1667,1668,1669,1671,1672,1674,1676,1677,1678,1679,1680,1682,1685,1689,1694,1696,1697,1776,1777,1780,1781,1784,1790,1791,1801,1817,1818,1819,1822,1825,1826,1827,1828,1830,1831,1832,1833,1834,1836,1837,1838,1839,1840,1841,1846,1878,1880,1889,1890,1893,1898,1900,1902,1903,1908,1909,1910,1911,1912,1926,1930,1932,1936,1937,1975,1977,1981,1985,1998,2002,2015,2035,2036,2041,2042,2048,2052,2064,2067,2068,2073,2261,2266,2338,2340,2687,2688,2693,2696,2699,2700,2701,2705,2707,2709,2711,2713,2807,2814,2815,3205,4057,4065,4069,8674,8694,13233,13256,13311,13315,13317,13318,14103,14298,14299,14301,14304,14305,17719,17724,17725,17730,17732,17733,17734,17736,17740,17741,17743,17744,17747,17749,19232,19236,19240,19241,19246,19250,19253,19254,19255,19256,19259,19263,19269,19270,19273,19280,19281,19284,19285,19288,19294,19299,19300,19301,19586,19587,19588,19589,19590,19591,20416,20418,20422,20428,20433,20434,20441,20456,20961,20962,20963,20964,20965,20966,20967,20972,20973,20974,20976,20977,20984,22206,22852,22854,22856,22858,22859,22860,22861,24157,24158,24159,24163,24519,24520,24521,24523,24524,28246,28247,28248,28249,28254,28330,28348,28350,28355,28357,28371,28373,28377,28381,28384,28391,28396,28398,28399,28402,28408,28419,28440,28443,28444,28445,28448,28454}'::integer[]))
7.	0.242	0.496	↑ 1.0	2,419	1	→ Hash (cost=57.19..57.19 rows=2,419 width=10) (actual time=0.496..0.496 rows=2,419 loops=1) Buckets: 4096 Batches: 1 Memory Usage: 138kB
8.	0.254	0.254	↑ 1.0	2,419	1	→ Seq Scan on copy copy_1 (cost=0.00..57.19 rows=2,419 width=10) (actual time=0.001..0.254 rows=2,419 loops=1)
9.	0.032	0.095	↑ 1.0	338	1	→ Hash (cost=22.38..22.38 rows=338 width=15) (actual time=0.095..0.095 rows=338 loops=1) Buckets: 1024 Batches: 1 Memory Usage: 25kB
10.	0.063	0.063	↑ 1.0	338	1	→ Seq Scan on library library_1 (cost=0.00..22.38 rows=338 width=15) (actual time=0.002..0.063 rows=338 loops=1)
11.						CTE copy_well_volumes
12.	4.414	6.307	↓ 1.4	267	1	→ HashAggregate (cost=8,370.69..8,373.01 rows=185 width=18) (actual time=6.221..6.307 rows=267 loops=1) Group Key: copy_well.plate_id
13.	1.240	1.893	↑ 1.3	9,209	1	→ Bitmap Heap Scan on copy_well (cost=1,131.97..8,096.78 rows=12,174 width=18) (actual time=0.676..1.893 rows=9,209 loops=1) Recheck Cond: (plate_id = ANY ('{1293,1296,1297,1298,1310,1311,1314,1316,1317,1318,1319,1320,1323,1328,1329,1331,1340,1505,1506,1507,1513,1515,1517,1524,1532,1541,1562,1573,1575,1601,1620,1653,1654,1656,1657,1661,1662,1663,1664,1667,1668,1669,1671,1672,1674,1676,1677,1678,1679,1680,1682,1685,1689,1694,1696,1697,1776,1777,1780,1781,1784,1790,1791,1801,1817,1818,1819,1822,1825,1826,1827,1828,1830,1831,1832,1833,1834,1836,1837,1838,1839,1840,1841,1846,1878,1880,1889,1890,1893,1898,1900,1902,1903,1908,1909,1910,1911,1912,1926,1930,1932,1936,1937,1975,1977,1981,1985,1998,2002,2015,2035,2036,2041,2042,2048,2052,2064,2067,2068,2073,2261,2266,2338,2340,2687,2688,2693,2696,2699,2700,2701,2705,2707,2709,2711,2713,2807,2814,2815,3205,4057,4065,4069,8674,8694,13233,13256,13311,13315,13317,13318,14103,14298,14299,14301,14304,14305,17719,17724,17725,17730,17732,17733,17734,17736,17740,17741,17743,17744,17747,17749,19232,19236,19240,19241,19246,19250,19253,19254,19255,19256,19259,19263,19269,19270,19273,19280,19281,19284,19285,19288,19294,19299,19300,19301,19586,19587,19588,19589,19590,19591,20416,20418,20422,20428,20433,20434,20441,20456,20961,20962,20963,20964,20965,20966,20967,20972,20973,20974,20976,20977,20984,22206,22852,22854,22856,22858,22859,22860,22861,24157,24158,24159,24163,24519,24520,24521,24523,24524,28246,28247,28248,28249,28254,28330,28348,28350,28355,28357,28371,28373,28377,28381,28384,28391,28396,28398,28399,28402,28408,28419,28440,28443,28444,28445,28448,28454}'::integer[])) Heap Blocks: exact=291
14.	0.653	0.653	↑ 1.3	9,209	1	→ Bitmap Index Scan on copy_well_plate_id_cdacc97b (cost=0.00..1,128.92 rows=12,174 width=0) (actual time=0.653..0.653 rows=9,209 loops=1) Index Cond: (plate_id = ANY ('{1293,1296,1297,1298,1310,1311,1314,1316,1317,1318,1319,1320,1323,1328,1329,1331,1340,1505,1506,1507,1513,1515,1517,1524,1532,1541,1562,1573,1575,1601,1620,1653,1654,1656,1657,1661,1662,1663,1664,1667,1668,1669,1671,1672,1674,1676,1677,1678,1679,1680,1682,1685,1689,1694,1696,1697,1776,1777,1780,1781,1784,1790,1791,1801,1817,1818,1819,1822,1825,1826,1827,1828,1830,1831,1832,1833,1834,1836,1837,1838,1839,1840,1841,1846,1878,1880,1889,1890,1893,1898,1900,1902,1903,1908,1909,1910,1911,1912,1926,1930,1932,1936,1937,1975,1977,1981,1985,1998,2002,2015,2035,2036,2041,2042,2048,2052,2064,2067,2068,2073,2261,2266,2338,2340,2687,2688,2693,2696,2699,2700,2701,2705,2707,2709,2711,2713,2807,2814,2815,3205,4057,4065,4069,8674,8694,13233,13256,13311,13315,13317,13318,14103,14298,14299,14301,14304,14305,17719,17724,17725,17730,17732,17733,17734,17736,17740,17741,17743,17744,17747,17749,19232,19236,19240,19241,19246,19250,19253,19254,19255,19256,19259,19263,19269,19270,19273,19280,19281,19284,19285,19288,19294,19299,19300,19301,19586,19587,19588,19589,19590,19591,20416,20418,20422,20428,20433,20434,20441,20456,20961,20962,20963,20964,20965,20966,20967,20972,20973,20974,20976,20977,20984,22206,22852,22854,22856,22858,22859,22860,22861,24157,24158,24159,24163,24519,24520,24521,24523,24524,28246,28247,28248,28249,28254,28330,28348,28350,28355,28357,28371,28373,28377,28381,28384,28391,28396,28398,28399,28402,28408,28419,28440,28443,28444,28445,28448,28454}'::integer[]))
15.						CTE well_concentrations
16.	32.127	69.486	↑ 21.8	267	1	→ HashAggregate (cost=42,927.22..42,985.52 rows=5,830 width=14) (actual time=69.430..69.486 rows=267 loops=1) Group Key: well.plate_number
17.	13.932	37.359	↓ 7.1	102,528	1	→ Nested Loop (cost=1,545.87..42,747.62 rows=14,368 width=14) (actual time=0.383..37.359 rows=102,528 loops=1)
18.	0.147	0.465	↓ 6.7	267	1	→ HashAggregate (cost=1,538.66..1,539.06 rows=40 width=4) (actual time=0.355..0.465 rows=267 loops=1) Group Key: plate_2.plate_number
19.	0.104	0.318	↑ 1.0	267	1	→ Bitmap Heap Scan on plate plate_2 (cost=795.50..1,537.99 rows=267 width=4) (actual time=0.224..0.318 rows=267 loops=1) Recheck Cond: (plate_id = ANY ('{1293,1296,1297,1298,1310,1311,1314,1316,1317,1318,1319,1320,1323,1328,1329,1331,1340,1505,1506,1507,1513,1515,1517,1524,1532,1541,1562,1573,1575,1601,1620,1653,1654,1656,1657,1661,1662,1663,1664,1667,1668,1669,1671,1672,1674,1676,1677,1678,1679,1680,1682,1685,1689,1694,1696,1697,1776,1777,1780,1781,1784,1790,1791,1801,1817,1818,1819,1822,1825,1826,1827,1828,1830,1831,1832,1833,1834,1836,1837,1838,1839,1840,1841,1846,1878,1880,1889,1890,1893,1898,1900,1902,1903,1908,1909,1910,1911,1912,1926,1930,1932,1936,1937,1975,1977,1981,1985,1998,2002,2015,2035,2036,2041,2042,2048,2052,2064,2067,2068,2073,2261,2266,2338,2340,2687,2688,2693,2696,2699,2700,2701,2705,2707,2709,2711,2713,2807,2814,2815,3205,4057,4065,4069,8674,8694,13233,13256,13311,13315,13317,13318,14103,14298,14299,14301,14304,14305,17719,17724,17725,17730,17732,17733,17734,17736,17740,17741,17743,17744,17747,17749,19232,19236,19240,19241,19246,19250,19253,19254,19255,19256,19259,19263,19269,19270,19273,19280,19281,19284,19285,19288,19294,19299,19300,19301,19586,19587,19588,19589,19590,19591,20416,20418,20422,20428,20433,20434,20441,20456,20961,20962,20963,20964,20965,20966,20967,20972,20973,20974,20976,20977,20984,22206,22852,22854,22856,22858,22859,22860,22861,24157,24158,24159,24163,24519,24520,24521,24523,24524,28246,28247,28248,28249,28254,28330,28348,28350,28355,28357,28371,28373,28377,28381,28384,28391,28396,28398,28399,28402,28408,28419,28440,28443,28444,28445,28448,28454}'::integer[])) Heap Blocks: exact=81
20.	0.214	0.214	↑ 1.0	267	1	→ Bitmap Index Scan on plate_pkey (cost=0.00..795.43 rows=267 width=0) (actual time=0.214..0.214 rows=267 loops=1) Index Cond: (plate_id = ANY ('{1293,1296,1297,1298,1310,1311,1314,1316,1317,1318,1319,1320,1323,1328,1329,1331,1340,1505,1506,1507,1513,1515,1517,1524,1532,1541,1562,1573,1575,1601,1620,1653,1654,1656,1657,1661,1662,1663,1664,1667,1668,1669,1671,1672,1674,1676,1677,1678,1679,1680,1682,1685,1689,1694,1696,1697,1776,1777,1780,1781,1784,1790,1791,1801,1817,1818,1819,1822,1825,1826,1827,1828,1830,1831,1832,1833,1834,1836,1837,1838,1839,1840,1841,1846,1878,1880,1889,1890,1893,1898,1900,1902,1903,1908,1909,1910,1911,1912,1926,1930,1932,1936,1937,1975,1977,1981,1985,1998,2002,2015,2035,2036,2041,2042,2048,2052,2064,2067,2068,2073,2261,2266,2338,2340,2687,2688,2693,2696,2699,2700,2701,2705,2707,2709,2711,2713,2807,2814,2815,3205,4057,4065,4069,8674,8694,13233,13256,13311,13315,13317,13318,14103,14298,14299,14301,14304,14305,17719,17724,17725,17730,17732,17733,17734,17736,17740,17741,17743,17744,17747,17749,19232,19236,19240,19241,19246,19250,19253,19254,19255,19256,19259,19263,19269,19270,19273,19280,19281,19284,19285,19288,19294,19299,19300,19301,19586,19587,19588,19589,19590,19591,20416,20418,20422,20428,20433,20434,20441,20456,20961,20962,20963,20964,20965,20966,20967,20972,20973,20974,20976,20977,20984,22206,22852,22854,22856,22858,22859,22860,22861,24157,24158,24159,24163,24519,24520,24521,24523,24524,28246,28247,28248,28249,28254,28330,28348,28350,28355,28357,28371,28373,28377,28381,28384,28391,28396,28398,28399,28402,28408,28419,28440,28443,28444,28445,28448,28454}'::integer[]))
21.	16.821	22.962	↓ 1.1	384	267	→ Bitmap Heap Scan on well (cost=7.21..1,026.61 rows=359 width=14) (actual time=0.027..0.086 rows=384 loops=267) Recheck Cond: (plate_number = plate_2.plate_number) Heap Blocks: exact=6832
22.	6.141	6.141	↓ 1.1	384	267	→ Bitmap Index Scan on well_plate_number_key (cost=0.00..7.12 rows=359 width=0) (actual time=0.023..0.023 rows=384 loops=267) Index Cond: (plate_number = plate_2.plate_number)
23.						CTE plate_statistics
24.	0.475	77.615	↑ 1.0	267	1	→ Hash Join (cost=1,078.41..2,029.23 rows=280 width=367) (actual time=76.750..77.615 rows=267 loops=1) Hash Cond: (plate_3.plate_number = well_concentrations.plate_number)
25.	0.094	7.545	↑ 1.0	267	1	→ Hash Join (cost=888.94..1,636.11 rows=267 width=239) (actual time=7.141..7.545 rows=267 loops=1) Hash Cond: (plate_3.copy_id = copy_2.copy_id)
26.	0.201	6.954	↑ 1.0	267	1	→ Hash Left Join (cost=801.51..1,545.01 rows=267 width=237) (actual time=6.635..6.954 rows=267 loops=1) Hash Cond: (plate_3.plate_id = copy_well_volumes.plate_id)
27.	0.132	0.327	↑ 1.0	267	1	→ Bitmap Heap Scan on plate plate_3 (cost=795.50..1,537.99 rows=267 width=37) (actual time=0.201..0.327 rows=267 loops=1) Recheck Cond: (plate_id = ANY ('{1293,1296,1297,1298,1310,1311,1314,1316,1317,1318,1319,1320,1323,1328,1329,1331,1340,1505,1506,1507,1513,1515,1517,1524,1532,1541,1562,1573,1575,1601,1620,1653,1654,1656,1657,1661,1662,1663,1664,1667,1668,1669,1671,1672,1674,1676,1677,1678,1679,1680,1682,1685,1689,1694,1696,1697,1776,1777,1780,1781,1784,1790,1791,1801,1817,1818,1819,1822,1825,1826,1827,1828,1830,1831,1832,1833,1834,1836,1837,1838,1839,1840,1841,1846,1878,1880,1889,1890,1893,1898,1900,1902,1903,1908,1909,1910,1911,1912,1926,1930,1932,1936,1937,1975,1977,1981,1985,1998,2002,2015,2035,2036,2041,2042,2048,2052,2064,2067,2068,2073,2261,2266,2338,2340,2687,2688,2693,2696,2699,2700,2701,2705,2707,2709,2711,2713,2807,2814,2815,3205,4057,4065,4069,8674,8694,13233,13256,13311,13315,13317,13318,14103,14298,14299,14301,14304,14305,17719,17724,17725,17730,17732,17733,17734,17736,17740,17741,17743,17744,17747,17749,19232,19236,19240,19241,19246,19250,19253,19254,19255,19256,19259,19263,19269,19270,19273,19280,19281,19284,19285,19288,19294,19299,19300,19301,19586,19587,19588,19589,19590,19591,20416,20418,20422,20428,20433,20434,20441,20456,20961,20962,20963,20964,20965,20966,20967,20972,20973,20974,20976,20977,20984,22206,22852,22854,22856,22858,22859,22860,22861,24157,24158,24159,24163,24519,24520,24521,24523,24524,28246,28247,28248,28249,28254,28330,28348,28350,28355,28357,28371,28373,28377,28381,28384,28391,28396,28398,28399,28402,28408,28419,28440,28443,28444,28445,28448,28454}'::integer[])) Heap Blocks: exact=81
28.	0.195	0.195	↑ 1.0	267	1	→ Bitmap Index Scan on plate_pkey (cost=0.00..795.43 rows=267 width=0) (actual time=0.195..0.195 rows=267 loops=1) Index Cond: (plate_id = ANY ('{1293,1296,1297,1298,1310,1311,1314,1316,1317,1318,1319,1320,1323,1328,1329,1331,1340,1505,1506,1507,1513,1515,1517,1524,1532,1541,1562,1573,1575,1601,1620,1653,1654,1656,1657,1661,1662,1663,1664,1667,1668,1669,1671,1672,1674,1676,1677,1678,1679,1680,1682,1685,1689,1694,1696,1697,1776,1777,1780,1781,1784,1790,1791,1801,1817,1818,1819,1822,1825,1826,1827,1828,1830,1831,1832,1833,1834,1836,1837,1838,1839,1840,1841,1846,1878,1880,1889,1890,1893,1898,1900,1902,1903,1908,1909,1910,1911,1912,1926,1930,1932,1936,1937,1975,1977,1981,1985,1998,2002,2015,2035,2036,2041,2042,2048,2052,2064,2067,2068,2073,2261,2266,2338,2340,2687,2688,2693,2696,2699,2700,2701,2705,2707,2709,2711,2713,2807,2814,2815,3205,4057,4065,4069,8674,8694,13233,13256,13311,13315,13317,13318,14103,14298,14299,14301,14304,14305,17719,17724,17725,17730,17732,17733,17734,17736,17740,17741,17743,17744,17747,17749,19232,19236,19240,19241,19246,19250,19253,19254,19255,19256,19259,19263,19269,19270,19273,19280,19281,19284,19285,19288,19294,19299,19300,19301,19586,19587,19588,19589,19590,19591,20416,20418,20422,20428,20433,20434,20441,20456,20961,20962,20963,20964,20965,20966,20967,20972,20973,20974,20976,20977,20984,22206,22852,22854,22856,22858,22859,22860,22861,24157,24158,24159,24163,24519,24520,24521,24523,24524,28246,28247,28248,28249,28254,28330,28348,28350,28355,28357,28371,28373,28377,28381,28384,28391,28396,28398,28399,28402,28408,28419,28440,28443,28444,28445,28448,28454}'::integer[]))
29.	0.047	6.426	↓ 1.4	267	1	→ Hash (cost=3.70..3.70 rows=185 width=204) (actual time=6.426..6.426 rows=267 loops=1) Buckets: 1024 Batches: 1 Memory Usage: 23kB
30.	6.379	6.379	↓ 1.4	267	1	→ CTE Scan on copy_well_volumes (cost=0.00..3.70 rows=185 width=204) (actual time=6.224..6.379 rows=267 loops=1)
31.	0.238	0.497	↑ 1.0	2,419	1	→ Hash (cost=57.19..57.19 rows=2,419 width=6) (actual time=0.497..0.497 rows=2,419 loops=1) Buckets: 4096 Batches: 1 Memory Usage: 128kB
32.	0.259	0.259	↑ 1.0	2,419	1	→ Seq Scan on copy copy_2 (cost=0.00..57.19 rows=2,419 width=6) (actual time=0.003..0.259 rows=2,419 loops=1)
33.	0.049	69.595	↑ 21.8	267	1	→ Hash (cost=116.60..116.60 rows=5,830 width=132) (actual time=69.595..69.595 rows=267 loops=1) Buckets: 8192 Batches: 1 Memory Usage: 77kB
34.	69.546	69.546	↑ 21.8	267	1	→ CTE Scan on well_concentrations (cost=0.00..116.60 rows=5,830 width=132) (actual time=69.432..69.546 rows=267 loops=1)
35.	0.115	118.182	↓ 267.0	267	1	→ Nested Loop (cost=804.88..2,882.12 rows=1 width=227) (actual time=78.400..118.182 rows=267 loops=1)
36.	0.000	89.498	↓ 267.0	267	1	→ Nested Loop Left Join (cost=804.73..1,571.79 rows=1 width=210) (actual time=78.281..89.498 rows=267 loops=1)
37.	0.259	89.268	↓ 267.0	267	1	→ Nested Loop (cost=804.46..1,571.31 rows=1 width=199) (actual time=78.277..89.268 rows=267 loops=1)
38.	6.999	88.742	↓ 267.0	267	1	→ Nested Loop (cost=804.18..1,570.37 rows=1 width=174) (actual time=78.270..88.742 rows=267 loops=1) Join Filter: (plate.plate_id = plate_statistics.plate_id) Rows Removed by Join Filter: 71022
39.	77.738	77.738	↑ 1.0	267	1	→ CTE Scan on plate_statistics (cost=0.00..5.60 rows=280 width=116) (actual time=76.751..77.738 rows=267 loops=1)
40.	2.349	4.005	↓ 133.5	267	267	→ Materialize (cost=804.18..1,556.38 rows=2 width=70) (actual time=0.006..0.015 rows=267 loops=267)
41.	0.093	1.656	↓ 133.5	267	1	→ Hash Join (cost=804.18..1,556.37 rows=2 width=70) (actual time=1.517..1.656 rows=267 loops=1) Hash Cond: (plate.plate_id = plate_cte.plate_id)
42.	0.060	0.228	↑ 1.0	267	1	→ Bitmap Heap Scan on plate (cost=795.50..1,537.99 rows=267 width=66) (actual time=0.174..0.228 rows=267 loops=1) Recheck Cond: (plate_id = ANY ('{1293,1296,1297,1298,1310,1311,1314,1316,1317,1318,1319,1320,1323,1328,1329,1331,1340,1505,1506,1507,1513,1515,1517,1524,1532,1541,1562,1573,1575,1601,1620,1653,1654,1656,1657,1661,1662,1663,1664,1667,1668,1669,1671,1672,1674,1676,1677,1678,1679,1680,1682,1685,1689,1694,1696,1697,1776,1777,1780,1781,1784,1790,1791,1801,1817,1818,1819,1822,1825,1826,1827,1828,1830,1831,1832,1833,1834,1836,1837,1838,1839,1840,1841,1846,1878,1880,1889,1890,1893,1898,1900,1902,1903,1908,1909,1910,1911,1912,1926,1930,1932,1936,1937,1975,1977,1981,1985,1998,2002,2015,2035,2036,2041,2042,2048,2052,2064,2067,2068,2073,2261,2266,2338,2340,2687,2688,2693,2696,2699,2700,2701,2705,2707,2709,2711,2713,2807,2814,2815,3205,4057,4065,4069,8674,8694,13233,13256,13311,13315,13317,13318,14103,14298,14299,14301,14304,14305,17719,17724,17725,17730,17732,17733,17734,17736,17740,17741,17743,17744,17747,17749,19232,19236,19240,19241,19246,19250,19253,19254,19255,19256,19259,19263,19269,19270,19273,19280,19281,19284,19285,19288,19294,19299,19300,19301,19586,19587,19588,19589,19590,19591,20416,20418,20422,20428,20433,20434,20441,20456,20961,20962,20963,20964,20965,20966,20967,20972,20973,20974,20976,20977,20984,22206,22852,22854,22856,22858,22859,22860,22861,24157,24158,24159,24163,24519,24520,24521,24523,24524,28246,28247,28248,28249,28254,28330,28348,28350,28355,28357,28371,28373,28377,28381,28384,28391,28396,28398,28399,28402,28408,28419,28440,28443,28444,28445,28448,28454}'::integer[])) Heap Blocks: exact=81
43.	0.168	0.168	↑ 1.0	267	1	→ Bitmap Index Scan on plate_pkey (cost=0.00..795.43 rows=267 width=0) (actual time=0.168..0.168 rows=267 loops=1) Index Cond: (plate_id = ANY ('{1293,1296,1297,1298,1310,1311,1314,1316,1317,1318,1319,1320,1323,1328,1329,1331,1340,1505,1506,1507,1513,1515,1517,1524,1532,1541,1562,1573,1575,1601,1620,1653,1654,1656,1657,1661,1662,1663,1664,1667,1668,1669,1671,1672,1674,1676,1677,1678,1679,1680,1682,1685,1689,1694,1696,1697,1776,1777,1780,1781,1784,1790,1791,1801,1817,1818,1819,1822,1825,1826,1827,1828,1830,1831,1832,1833,1834,1836,1837,1838,1839,1840,1841,1846,1878,1880,1889,1890,1893,1898,1900,1902,1903,1908,1909,1910,1911,1912,1926,1930,1932,1936,1937,1975,1977,1981,1985,1998,2002,2015,2035,2036,2041,2042,2048,2052,2064,2067,2068,2073,2261,2266,2338,2340,2687,2688,2693,2696,2699,2700,2701,2705,2707,2709,2711,2713,2807,2814,2815,3205,4057,4065,4069,8674,8694,13233,13256,13311,13315,13317,13318,14103,14298,14299,14301,14304,14305,17719,17724,17725,17730,17732,17733,17734,17736,17740,17741,17743,17744,17747,17749,19232,19236,19240,19241,19246,19250,19253,19254,19255,19256,19259,19263,19269,19270,19273,19280,19281,19284,19285,19288,19294,19299,19300,19301,19586,19587,19588,19589,19590,19591,20416,20418,20422,20428,20433,20434,20441,20456,20961,20962,20963,20964,20965,20966,20967,20972,20973,20974,20976,20977,20984,22206,22852,22854,22856,22858,22859,22860,22861,24157,24158,24159,24163,24519,24520,24521,24523,24524,28246,28247,28248,28249,28254,28330,28348,28350,28355,28357,28371,28373,28377,28381,28384,28391,28396,28398,28399,28402,28408,28419,28440,28443,28444,28445,28448,28454}'::integer[]))
44.	0.026	1.335	↑ 1.0	267	1	→ Hash (cost=5.34..5.34 rows=267 width=4) (actual time=1.335..1.335 rows=267 loops=1) Buckets: 1024 Batches: 1 Memory Usage: 18kB
45.	1.309	1.309	↑ 1.0	267	1	→ CTE Scan on plate_cte (cost=0.00..5.34 rows=267 width=4) (actual time=0.831..1.309 rows=267 loops=1)
46.	0.267	0.267	↑ 1.0	1	267	→ Index Scan using copy_pkey on copy (cost=0.28..0.93 rows=1 width=33) (actual time=0.001..0.001 rows=1 loops=267) Index Cond: (copy_id = plate.copy_id)
47.	0.267	0.267	↓ 0.0	0	267	→ Index Scan using plate_location_pkey on plate_location (cost=0.28..0.47 rows=1 width=19) (actual time=0.001..0.001 rows=0 loops=267) Index Cond: (plate.plate_location_id = plate_location_id)
48.	0.267	0.267	↑ 1.0	1	267	→ Index Scan using library_pkey on library (cost=0.15..0.20 rows=1 width=25) (actual time=0.001..0.001 rows=1 loops=267) Index Cond: (library_id = copy.library_id)
49.						SubPlan (forNested Loop)
50.	4.539	28.302	↑ 1.0	1	267	→ Aggregate (cost=1,310.11..1,310.12 rows=1 width=0) (actual time=0.105..0.106 rows=1 loops=267)
51.	18.690	23.763	↓ 1.5	350	267	→ Bitmap Heap Scan on well well_1 (cost=7.18..1,309.52 rows=239 width=0) (actual time=0.029..0.089 rows=350 loops=267) Recheck Cond: (plate_number = plate.plate_number) Filter: (library_well_type = 'experimental'::text) Rows Removed by Filter: 34 Heap Blocks: exact=6832
52.	5.073	5.073	↓ 1.1	384	267	→ Bitmap Index Scan on well_plate_number_key (cost=0.00..7.12 rows=359 width=0) (actual time=0.019..0.019 rows=384 loops=267) Index Cond: (plate_number = plate.plate_number)

                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                    QUERY PLAN                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                    
------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
 Sort  (cost=57931.26..57931.27 rows=1 width=227) (actual time=118.353..118.368 rows=267 loops=1)
   Sort Key: plate.plate_number, copy.name
   Sort Method: quicksort  Memory: 95kB
   CTE plate_cte
     ->  Hash Join  (cost=909.53..1661.37 rows=267 width=29) (actual time=0.830..1.245 rows=267 loops=1)
           Hash Cond: (copy_1.library_id = library_1.library_id)
           ->  Hash Join  (cost=882.93..1629.09 rows=267 width=18) (actual time=0.724..0.865 rows=267 loops=1)
                 Hash Cond: (plate_1.copy_id = copy_1.copy_id)
                 ->  Bitmap Heap Scan on plate plate_1  (cost=795.50..1537.99 rows=267 width=12) (actual time=0.224..0.309 rows=267 loops=1)
                       Recheck Cond: (plate_id = ANY ('{1293,1296,1297,1298,1310,1311,1314,1316,1317,1318,1319,1320,1323,1328,1329,1331,1340,1505,1506,1507,1513,1515,1517,1524,1532,1541,1562,1573,1575,1601,1620,1653,1654,1656,1657,1661,1662,1663,1664,1667,1668,1669,1671,1672,1674,1676,1677,1678,1679,1680,1682,1685,1689,1694,1696,1697,1776,1777,1780,1781,1784,1790,1791,1801,1817,1818,1819,1822,1825,1826,1827,1828,1830,1831,1832,1833,1834,1836,1837,1838,1839,1840,1841,1846,1878,1880,1889,1890,1893,1898,1900,1902,1903,1908,1909,1910,1911,1912,1926,1930,1932,1936,1937,1975,1977,1981,1985,1998,2002,2015,2035,2036,2041,2042,2048,2052,2064,2067,2068,2073,2261,2266,2338,2340,2687,2688,2693,2696,2699,2700,2701,2705,2707,2709,2711,2713,2807,2814,2815,3205,4057,4065,4069,8674,8694,13233,13256,13311,13315,13317,13318,14103,14298,14299,14301,14304,14305,17719,17724,17725,17730,17732,17733,17734,17736,17740,17741,17743,17744,17747,17749,19232,19236,19240,19241,19246,19250,19253,19254,19255,19256,19259,19263,19269,19270,19273,19280,19281,19284,19285,19288,19294,19299,19300,19301,19586,19587,19588,19589,19590,19591,20416,20418,20422,20428,20433,20434,20441,20456,20961,20962,20963,20964,20965,20966,20967,20972,20973,20974,20976,20977,20984,22206,22852,22854,22856,22858,22859,22860,22861,24157,24158,24159,24163,24519,24520,24521,24523,24524,28246,28247,28248,28249,28254,28330,28348,28350,28355,28357,28371,28373,28377,28381,28384,28391,28396,28398,28399,28402,28408,28419,28440,28443,28444,28445,28448,28454}'::integer[]))
                       Heap Blocks: exact=81
                       ->  Bitmap Index Scan on plate_pkey  (cost=0.00..795.43 rows=267 width=0) (actual time=0.215..0.215 rows=267 loops=1)
                             Index Cond: (plate_id = ANY ('{1293,1296,1297,1298,1310,1311,1314,1316,1317,1318,1319,1320,1323,1328,1329,1331,1340,1505,1506,1507,1513,1515,1517,1524,1532,1541,1562,1573,1575,1601,1620,1653,1654,1656,1657,1661,1662,1663,1664,1667,1668,1669,1671,1672,1674,1676,1677,1678,1679,1680,1682,1685,1689,1694,1696,1697,1776,1777,1780,1781,1784,1790,1791,1801,1817,1818,1819,1822,1825,1826,1827,1828,1830,1831,1832,1833,1834,1836,1837,1838,1839,1840,1841,1846,1878,1880,1889,1890,1893,1898,1900,1902,1903,1908,1909,1910,1911,1912,1926,1930,1932,1936,1937,1975,1977,1981,1985,1998,2002,2015,2035,2036,2041,2042,2048,2052,2064,2067,2068,2073,2261,2266,2338,2340,2687,2688,2693,2696,2699,2700,2701,2705,2707,2709,2711,2713,2807,2814,2815,3205,4057,4065,4069,8674,8694,13233,13256,13311,13315,13317,13318,14103,14298,14299,14301,14304,14305,17719,17724,17725,17730,17732,17733,17734,17736,17740,17741,17743,17744,17747,17749,19232,19236,19240,19241,19246,19250,19253,19254,19255,19256,19259,19263,19269,19270,19273,19280,19281,19284,19285,19288,19294,19299,19300,19301,19586,19587,19588,19589,19590,19591,20416,20418,20422,20428,20433,20434,20441,20456,20961,20962,20963,20964,20965,20966,20967,20972,20973,20974,20976,20977,20984,22206,22852,22854,22856,22858,22859,22860,22861,24157,24158,24159,24163,24519,24520,24521,24523,24524,28246,28247,28248,28249,28254,28330,28348,28350,28355,28357,28371,28373,28377,28381,28384,28391,28396,28398,28399,28402,28408,28419,28440,28443,28444,28445,28448,28454}'::integer[]))
                 ->  Hash  (cost=57.19..57.19 rows=2419 width=10) (actual time=0.496..0.496 rows=2419 loops=1)
                       Buckets: 4096  Batches: 1  Memory Usage: 138kB
                       ->  Seq Scan on copy copy_1  (cost=0.00..57.19 rows=2419 width=10) (actual time=0.001..0.254 rows=2419 loops=1)
           ->  Hash  (cost=22.38..22.38 rows=338 width=15) (actual time=0.095..0.095 rows=338 loops=1)
                 Buckets: 1024  Batches: 1  Memory Usage: 25kB
                 ->  Seq Scan on library library_1  (cost=0.00..22.38 rows=338 width=15) (actual time=0.002..0.063 rows=338 loops=1)
   CTE copy_well_volumes
     ->  HashAggregate  (cost=8370.69..8373.01 rows=185 width=18) (actual time=6.221..6.307 rows=267 loops=1)
           Group Key: copy_well.plate_id
           ->  Bitmap Heap Scan on copy_well  (cost=1131.97..8096.78 rows=12174 width=18) (actual time=0.676..1.893 rows=9209 loops=1)
                 Recheck Cond: (plate_id = ANY ('{1293,1296,1297,1298,1310,1311,1314,1316,1317,1318,1319,1320,1323,1328,1329,1331,1340,1505,1506,1507,1513,1515,1517,1524,1532,1541,1562,1573,1575,1601,1620,1653,1654,1656,1657,1661,1662,1663,1664,1667,1668,1669,1671,1672,1674,1676,1677,1678,1679,1680,1682,1685,1689,1694,1696,1697,1776,1777,1780,1781,1784,1790,1791,1801,1817,1818,1819,1822,1825,1826,1827,1828,1830,1831,1832,1833,1834,1836,1837,1838,1839,1840,1841,1846,1878,1880,1889,1890,1893,1898,1900,1902,1903,1908,1909,1910,1911,1912,1926,1930,1932,1936,1937,1975,1977,1981,1985,1998,2002,2015,2035,2036,2041,2042,2048,2052,2064,2067,2068,2073,2261,2266,2338,2340,2687,2688,2693,2696,2699,2700,2701,2705,2707,2709,2711,2713,2807,2814,2815,3205,4057,4065,4069,8674,8694,13233,13256,13311,13315,13317,13318,14103,14298,14299,14301,14304,14305,17719,17724,17725,17730,17732,17733,17734,17736,17740,17741,17743,17744,17747,17749,19232,19236,19240,19241,19246,19250,19253,19254,19255,19256,19259,19263,19269,19270,19273,19280,19281,19284,19285,19288,19294,19299,19300,19301,19586,19587,19588,19589,19590,19591,20416,20418,20422,20428,20433,20434,20441,20456,20961,20962,20963,20964,20965,20966,20967,20972,20973,20974,20976,20977,20984,22206,22852,22854,22856,22858,22859,22860,22861,24157,24158,24159,24163,24519,24520,24521,24523,24524,28246,28247,28248,28249,28254,28330,28348,28350,28355,28357,28371,28373,28377,28381,28384,28391,28396,28398,28399,28402,28408,28419,28440,28443,28444,28445,28448,28454}'::integer[]))
                 Heap Blocks: exact=291
                 ->  Bitmap Index Scan on copy_well_plate_id_cdacc97b  (cost=0.00..1128.92 rows=12174 width=0) (actual time=0.653..0.653 rows=9209 loops=1)
                       Index Cond: (plate_id = ANY ('{1293,1296,1297,1298,1310,1311,1314,1316,1317,1318,1319,1320,1323,1328,1329,1331,1340,1505,1506,1507,1513,1515,1517,1524,1532,1541,1562,1573,1575,1601,1620,1653,1654,1656,1657,1661,1662,1663,1664,1667,1668,1669,1671,1672,1674,1676,1677,1678,1679,1680,1682,1685,1689,1694,1696,1697,1776,1777,1780,1781,1784,1790,1791,1801,1817,1818,1819,1822,1825,1826,1827,1828,1830,1831,1832,1833,1834,1836,1837,1838,1839,1840,1841,1846,1878,1880,1889,1890,1893,1898,1900,1902,1903,1908,1909,1910,1911,1912,1926,1930,1932,1936,1937,1975,1977,1981,1985,1998,2002,2015,2035,2036,2041,2042,2048,2052,2064,2067,2068,2073,2261,2266,2338,2340,2687,2688,2693,2696,2699,2700,2701,2705,2707,2709,2711,2713,2807,2814,2815,3205,4057,4065,4069,8674,8694,13233,13256,13311,13315,13317,13318,14103,14298,14299,14301,14304,14305,17719,17724,17725,17730,17732,17733,17734,17736,17740,17741,17743,17744,17747,17749,19232,19236,19240,19241,19246,19250,19253,19254,19255,19256,19259,19263,19269,19270,19273,19280,19281,19284,19285,19288,19294,19299,19300,19301,19586,19587,19588,19589,19590,19591,20416,20418,20422,20428,20433,20434,20441,20456,20961,20962,20963,20964,20965,20966,20967,20972,20973,20974,20976,20977,20984,22206,22852,22854,22856,22858,22859,22860,22861,24157,24158,24159,24163,24519,24520,24521,24523,24524,28246,28247,28248,28249,28254,28330,28348,28350,28355,28357,28371,28373,28377,28381,28384,28391,28396,28398,28399,28402,28408,28419,28440,28443,28444,28445,28448,28454}'::integer[]))
   CTE well_concentrations
     ->  HashAggregate  (cost=42927.22..42985.52 rows=5830 width=14) (actual time=69.430..69.486 rows=267 loops=1)
           Group Key: well.plate_number
           ->  Nested Loop  (cost=1545.87..42747.62 rows=14368 width=14) (actual time=0.383..37.359 rows=102528 loops=1)
                 ->  HashAggregate  (cost=1538.66..1539.06 rows=40 width=4) (actual time=0.355..0.465 rows=267 loops=1)
                       Group Key: plate_2.plate_number
                       ->  Bitmap Heap Scan on plate plate_2  (cost=795.50..1537.99 rows=267 width=4) (actual time=0.224..0.318 rows=267 loops=1)
                             Recheck Cond: (plate_id = ANY ('{1293,1296,1297,1298,1310,1311,1314,1316,1317,1318,1319,1320,1323,1328,1329,1331,1340,1505,1506,1507,1513,1515,1517,1524,1532,1541,1562,1573,1575,1601,1620,1653,1654,1656,1657,1661,1662,1663,1664,1667,1668,1669,1671,1672,1674,1676,1677,1678,1679,1680,1682,1685,1689,1694,1696,1697,1776,1777,1780,1781,1784,1790,1791,1801,1817,1818,1819,1822,1825,1826,1827,1828,1830,1831,1832,1833,1834,1836,1837,1838,1839,1840,1841,1846,1878,1880,1889,1890,1893,1898,1900,1902,1903,1908,1909,1910,1911,1912,1926,1930,1932,1936,1937,1975,1977,1981,1985,1998,2002,2015,2035,2036,2041,2042,2048,2052,2064,2067,2068,2073,2261,2266,2338,2340,2687,2688,2693,2696,2699,2700,2701,2705,2707,2709,2711,2713,2807,2814,2815,3205,4057,4065,4069,8674,8694,13233,13256,13311,13315,13317,13318,14103,14298,14299,14301,14304,14305,17719,17724,17725,17730,17732,17733,17734,17736,17740,17741,17743,17744,17747,17749,19232,19236,19240,19241,19246,19250,19253,19254,19255,19256,19259,19263,19269,19270,19273,19280,19281,19284,19285,19288,19294,19299,19300,19301,19586,19587,19588,19589,19590,19591,20416,20418,20422,20428,20433,20434,20441,20456,20961,20962,20963,20964,20965,20966,20967,20972,20973,20974,20976,20977,20984,22206,22852,22854,22856,22858,22859,22860,22861,24157,24158,24159,24163,24519,24520,24521,24523,24524,28246,28247,28248,28249,28254,28330,28348,28350,28355,28357,28371,28373,28377,28381,28384,28391,28396,28398,28399,28402,28408,28419,28440,28443,28444,28445,28448,28454}'::integer[]))
                             Heap Blocks: exact=81
                             ->  Bitmap Index Scan on plate_pkey  (cost=0.00..795.43 rows=267 width=0) (actual time=0.214..0.214 rows=267 loops=1)
                                   Index Cond: (plate_id = ANY ('{1293,1296,1297,1298,1310,1311,1314,1316,1317,1318,1319,1320,1323,1328,1329,1331,1340,1505,1506,1507,1513,1515,1517,1524,1532,1541,1562,1573,1575,1601,1620,1653,1654,1656,1657,1661,1662,1663,1664,1667,1668,1669,1671,1672,1674,1676,1677,1678,1679,1680,1682,1685,1689,1694,1696,1697,1776,1777,1780,1781,1784,1790,1791,1801,1817,1818,1819,1822,1825,1826,1827,1828,1830,1831,1832,1833,1834,1836,1837,1838,1839,1840,1841,1846,1878,1880,1889,1890,1893,1898,1900,1902,1903,1908,1909,1910,1911,1912,1926,1930,1932,1936,1937,1975,1977,1981,1985,1998,2002,2015,2035,2036,2041,2042,2048,2052,2064,2067,2068,2073,2261,2266,2338,2340,2687,2688,2693,2696,2699,2700,2701,2705,2707,2709,2711,2713,2807,2814,2815,3205,4057,4065,4069,8674,8694,13233,13256,13311,13315,13317,13318,14103,14298,14299,14301,14304,14305,17719,17724,17725,17730,17732,17733,17734,17736,17740,17741,17743,17744,17747,17749,19232,19236,19240,19241,19246,19250,19253,19254,19255,19256,19259,19263,19269,19270,19273,19280,19281,19284,19285,19288,19294,19299,19300,19301,19586,19587,19588,19589,19590,19591,20416,20418,20422,20428,20433,20434,20441,20456,20961,20962,20963,20964,20965,20966,20967,20972,20973,20974,20976,20977,20984,22206,22852,22854,22856,22858,22859,22860,22861,24157,24158,24159,24163,24519,24520,24521,24523,24524,28246,28247,28248,28249,28254,28330,28348,28350,28355,28357,28371,28373,28377,28381,28384,28391,28396,28398,28399,28402,28408,28419,28440,28443,28444,28445,28448,28454}'::integer[]))
                 ->  Bitmap Heap Scan on well  (cost=7.21..1026.61 rows=359 width=14) (actual time=0.027..0.086 rows=384 loops=267)
                       Recheck Cond: (plate_number = plate_2.plate_number)
                       Heap Blocks: exact=6832
                       ->  Bitmap Index Scan on well_plate_number_key  (cost=0.00..7.12 rows=359 width=0) (actual time=0.023..0.023 rows=384 loops=267)
                             Index Cond: (plate_number = plate_2.plate_number)
   CTE plate_statistics
     ->  Hash Join  (cost=1078.41..2029.23 rows=280 width=367) (actual time=76.750..77.615 rows=267 loops=1)
           Hash Cond: (plate_3.plate_number = well_concentrations.plate_number)
           ->  Hash Join  (cost=888.94..1636.11 rows=267 width=239) (actual time=7.141..7.545 rows=267 loops=1)
                 Hash Cond: (plate_3.copy_id = copy_2.copy_id)
                 ->  Hash Left Join  (cost=801.51..1545.01 rows=267 width=237) (actual time=6.635..6.954 rows=267 loops=1)
                       Hash Cond: (plate_3.plate_id = copy_well_volumes.plate_id)
                       ->  Bitmap Heap Scan on plate plate_3  (cost=795.50..1537.99 rows=267 width=37) (actual time=0.201..0.327 rows=267 loops=1)
                             Recheck Cond: (plate_id = ANY ('{1293,1296,1297,1298,1310,1311,1314,1316,1317,1318,1319,1320,1323,1328,1329,1331,1340,1505,1506,1507,1513,1515,1517,1524,1532,1541,1562,1573,1575,1601,1620,1653,1654,1656,1657,1661,1662,1663,1664,1667,1668,1669,1671,1672,1674,1676,1677,1678,1679,1680,1682,1685,1689,1694,1696,1697,1776,1777,1780,1781,1784,1790,1791,1801,1817,1818,1819,1822,1825,1826,1827,1828,1830,1831,1832,1833,1834,1836,1837,1838,1839,1840,1841,1846,1878,1880,1889,1890,1893,1898,1900,1902,1903,1908,1909,1910,1911,1912,1926,1930,1932,1936,1937,1975,1977,1981,1985,1998,2002,2015,2035,2036,2041,2042,2048,2052,2064,2067,2068,2073,2261,2266,2338,2340,2687,2688,2693,2696,2699,2700,2701,2705,2707,2709,2711,2713,2807,2814,2815,3205,4057,4065,4069,8674,8694,13233,13256,13311,13315,13317,13318,14103,14298,14299,14301,14304,14305,17719,17724,17725,17730,17732,17733,17734,17736,17740,17741,17743,17744,17747,17749,19232,19236,19240,19241,19246,19250,19253,19254,19255,19256,19259,19263,19269,19270,19273,19280,19281,19284,19285,19288,19294,19299,19300,19301,19586,19587,19588,19589,19590,19591,20416,20418,20422,20428,20433,20434,20441,20456,20961,20962,20963,20964,20965,20966,20967,20972,20973,20974,20976,20977,20984,22206,22852,22854,22856,22858,22859,22860,22861,24157,24158,24159,24163,24519,24520,24521,24523,24524,28246,28247,28248,28249,28254,28330,28348,28350,28355,28357,28371,28373,28377,28381,28384,28391,28396,28398,28399,28402,28408,28419,28440,28443,28444,28445,28448,28454}'::integer[]))
                             Heap Blocks: exact=81
                             ->  Bitmap Index Scan on plate_pkey  (cost=0.00..795.43 rows=267 width=0) (actual time=0.195..0.195 rows=267 loops=1)
                                   Index Cond: (plate_id = ANY ('{1293,1296,1297,1298,1310,1311,1314,1316,1317,1318,1319,1320,1323,1328,1329,1331,1340,1505,1506,1507,1513,1515,1517,1524,1532,1541,1562,1573,1575,1601,1620,1653,1654,1656,1657,1661,1662,1663,1664,1667,1668,1669,1671,1672,1674,1676,1677,1678,1679,1680,1682,1685,1689,1694,1696,1697,1776,1777,1780,1781,1784,1790,1791,1801,1817,1818,1819,1822,1825,1826,1827,1828,1830,1831,1832,1833,1834,1836,1837,1838,1839,1840,1841,1846,1878,1880,1889,1890,1893,1898,1900,1902,1903,1908,1909,1910,1911,1912,1926,1930,1932,1936,1937,1975,1977,1981,1985,1998,2002,2015,2035,2036,2041,2042,2048,2052,2064,2067,2068,2073,2261,2266,2338,2340,2687,2688,2693,2696,2699,2700,2701,2705,2707,2709,2711,2713,2807,2814,2815,3205,4057,4065,4069,8674,8694,13233,13256,13311,13315,13317,13318,14103,14298,14299,14301,14304,14305,17719,17724,17725,17730,17732,17733,17734,17736,17740,17741,17743,17744,17747,17749,19232,19236,19240,19241,19246,19250,19253,19254,19255,19256,19259,19263,19269,19270,19273,19280,19281,19284,19285,19288,19294,19299,19300,19301,19586,19587,19588,19589,19590,19591,20416,20418,20422,20428,20433,20434,20441,20456,20961,20962,20963,20964,20965,20966,20967,20972,20973,20974,20976,20977,20984,22206,22852,22854,22856,22858,22859,22860,22861,24157,24158,24159,24163,24519,24520,24521,24523,24524,28246,28247,28248,28249,28254,28330,28348,28350,28355,28357,28371,28373,28377,28381,28384,28391,28396,28398,28399,28402,28408,28419,28440,28443,28444,28445,28448,28454}'::integer[]))
                       ->  Hash  (cost=3.70..3.70 rows=185 width=204) (actual time=6.426..6.426 rows=267 loops=1)
                             Buckets: 1024  Batches: 1  Memory Usage: 23kB
                             ->  CTE Scan on copy_well_volumes  (cost=0.00..3.70 rows=185 width=204) (actual time=6.224..6.379 rows=267 loops=1)
                 ->  Hash  (cost=57.19..57.19 rows=2419 width=6) (actual time=0.497..0.497 rows=2419 loops=1)
                       Buckets: 4096  Batches: 1  Memory Usage: 128kB
                       ->  Seq Scan on copy copy_2  (cost=0.00..57.19 rows=2419 width=6) (actual time=0.003..0.259 rows=2419 loops=1)
           ->  Hash  (cost=116.60..116.60 rows=5830 width=132) (actual time=69.595..69.595 rows=267 loops=1)
                 Buckets: 8192  Batches: 1  Memory Usage: 77kB
                 ->  CTE Scan on well_concentrations  (cost=0.00..116.60 rows=5830 width=132) (actual time=69.432..69.546 rows=267 loops=1)
   ->  Nested Loop  (cost=804.88..2882.12 rows=1 width=227) (actual time=78.400..118.182 rows=267 loops=1)
         ->  Nested Loop Left Join  (cost=804.73..1571.79 rows=1 width=210) (actual time=78.281..89.498 rows=267 loops=1)
               ->  Nested Loop  (cost=804.46..1571.31 rows=1 width=199) (actual time=78.277..89.268 rows=267 loops=1)
                     ->  Nested Loop  (cost=804.18..1570.37 rows=1 width=174) (actual time=78.270..88.742 rows=267 loops=1)
                           Join Filter: (plate.plate_id = plate_statistics.plate_id)
                           Rows Removed by Join Filter: 71022
                           ->  CTE Scan on plate_statistics  (cost=0.00..5.60 rows=280 width=116) (actual time=76.751..77.738 rows=267 loops=1)
                           ->  Materialize  (cost=804.18..1556.38 rows=2 width=70) (actual time=0.006..0.015 rows=267 loops=267)
                                 ->  Hash Join  (cost=804.18..1556.37 rows=2 width=70) (actual time=1.517..1.656 rows=267 loops=1)
                                       Hash Cond: (plate.plate_id = plate_cte.plate_id)
                                       ->  Bitmap Heap Scan on plate  (cost=795.50..1537.99 rows=267 width=66) (actual time=0.174..0.228 rows=267 loops=1)
                                             Recheck Cond: (plate_id = ANY ('{1293,1296,1297,1298,1310,1311,1314,1316,1317,1318,1319,1320,1323,1328,1329,1331,1340,1505,1506,1507,1513,1515,1517,1524,1532,1541,1562,1573,1575,1601,1620,1653,1654,1656,1657,1661,1662,1663,1664,1667,1668,1669,1671,1672,1674,1676,1677,1678,1679,1680,1682,1685,1689,1694,1696,1697,1776,1777,1780,1781,1784,1790,1791,1801,1817,1818,1819,1822,1825,1826,1827,1828,1830,1831,1832,1833,1834,1836,1837,1838,1839,1840,1841,1846,1878,1880,1889,1890,1893,1898,1900,1902,1903,1908,1909,1910,1911,1912,1926,1930,1932,1936,1937,1975,1977,1981,1985,1998,2002,2015,2035,2036,2041,2042,2048,2052,2064,2067,2068,2073,2261,2266,2338,2340,2687,2688,2693,2696,2699,2700,2701,2705,2707,2709,2711,2713,2807,2814,2815,3205,4057,4065,4069,8674,8694,13233,13256,13311,13315,13317,13318,14103,14298,14299,14301,14304,14305,17719,17724,17725,17730,17732,17733,17734,17736,17740,17741,17743,17744,17747,17749,19232,19236,19240,19241,19246,19250,19253,19254,19255,19256,19259,19263,19269,19270,19273,19280,19281,19284,19285,19288,19294,19299,19300,19301,19586,19587,19588,19589,19590,19591,20416,20418,20422,20428,20433,20434,20441,20456,20961,20962,20963,20964,20965,20966,20967,20972,20973,20974,20976,20977,20984,22206,22852,22854,22856,22858,22859,22860,22861,24157,24158,24159,24163,24519,24520,24521,24523,24524,28246,28247,28248,28249,28254,28330,28348,28350,28355,28357,28371,28373,28377,28381,28384,28391,28396,28398,28399,28402,28408,28419,28440,28443,28444,28445,28448,28454}'::integer[]))
                                             Heap Blocks: exact=81
                                             ->  Bitmap Index Scan on plate_pkey  (cost=0.00..795.43 rows=267 width=0) (actual time=0.168..0.168 rows=267 loops=1)
                                                   Index Cond: (plate_id = ANY ('{1293,1296,1297,1298,1310,1311,1314,1316,1317,1318,1319,1320,1323,1328,1329,1331,1340,1505,1506,1507,1513,1515,1517,1524,1532,1541,1562,1573,1575,1601,1620,1653,1654,1656,1657,1661,1662,1663,1664,1667,1668,1669,1671,1672,1674,1676,1677,1678,1679,1680,1682,1685,1689,1694,1696,1697,1776,1777,1780,1781,1784,1790,1791,1801,1817,1818,1819,1822,1825,1826,1827,1828,1830,1831,1832,1833,1834,1836,1837,1838,1839,1840,1841,1846,1878,1880,1889,1890,1893,1898,1900,1902,1903,1908,1909,1910,1911,1912,1926,1930,1932,1936,1937,1975,1977,1981,1985,1998,2002,2015,2035,2036,2041,2042,2048,2052,2064,2067,2068,2073,2261,2266,2338,2340,2687,2688,2693,2696,2699,2700,2701,2705,2707,2709,2711,2713,2807,2814,2815,3205,4057,4065,4069,8674,8694,13233,13256,13311,13315,13317,13318,14103,14298,14299,14301,14304,14305,17719,17724,17725,17730,17732,17733,17734,17736,17740,17741,17743,17744,17747,17749,19232,19236,19240,19241,19246,19250,19253,19254,19255,19256,19259,19263,19269,19270,19273,19280,19281,19284,19285,19288,19294,19299,19300,19301,19586,19587,19588,19589,19590,19591,20416,20418,20422,20428,20433,20434,20441,20456,20961,20962,20963,20964,20965,20966,20967,20972,20973,20974,20976,20977,20984,22206,22852,22854,22856,22858,22859,22860,22861,24157,24158,24159,24163,24519,24520,24521,24523,24524,28246,28247,28248,28249,28254,28330,28348,28350,28355,28357,28371,28373,28377,28381,28384,28391,28396,28398,28399,28402,28408,28419,28440,28443,28444,28445,28448,28454}'::integer[]))
                                       ->  Hash  (cost=5.34..5.34 rows=267 width=4) (actual time=1.335..1.335 rows=267 loops=1)
                                             Buckets: 1024  Batches: 1  Memory Usage: 18kB
                                             ->  CTE Scan on plate_cte  (cost=0.00..5.34 rows=267 width=4) (actual time=0.831..1.309 rows=267 loops=1)
                     ->  Index Scan using copy_pkey on copy  (cost=0.28..0.93 rows=1 width=33) (actual time=0.001..0.001 rows=1 loops=267)
                           Index Cond: (copy_id = plate.copy_id)
               ->  Index Scan using plate_location_pkey on plate_location  (cost=0.28..0.47 rows=1 width=19) (actual time=0.001..0.001 rows=0 loops=267)
                     Index Cond: (plate.plate_location_id = plate_location_id)
         ->  Index Scan using library_pkey on library  (cost=0.15..0.20 rows=1 width=25) (actual time=0.001..0.001 rows=1 loops=267)
               Index Cond: (library_id = copy.library_id)
         SubPlan 5
           ->  Aggregate  (cost=1310.11..1310.12 rows=1 width=0) (actual time=0.105..0.106 rows=1 loops=267)
                 ->  Bitmap Heap Scan on well well_1  (cost=7.18..1309.52 rows=239 width=0) (actual time=0.029..0.089 rows=350 loops=267)
                       Recheck Cond: (plate_number = plate.plate_number)
                       Filter: (library_well_type = 'experimental'::text)
                       Rows Removed by Filter: 34
                       Heap Blocks: exact=6832
                       ->  Bitmap Index Scan on well_plate_number_key  (cost=0.00..7.12 rows=359 width=0) (actual time=0.019..0.019 rows=384 loops=267)
                             Index Cond: (plate_number = plate.plate_number)
 Planning time: 4.541 ms
 Execution time: 118.629 ms
(99 rows)

Per node type stats

node type	count	sum of times	% of query
Aggregate	1	4.539 ms	3.8 %
Bitmap Heap Scan	7	37.141 ms	31.4 %
Bitmap Index Scan	7	12.659 ms	10.7 %
CTE Scan	4	154.972 ms	130.9 %
Hash	6	0.634 ms	0.5 %
Hash Join	5	1.007 ms	0.9 %
Hash Left Join	1	0.201 ms	0.2 %
HashAggregate	3	36.688 ms	31.0 %
Index Scan	3	0.801 ms	0.7 %
Materialize	1	2.349 ms	2.0 %
Nested Loop	4	21.305 ms	18.0 %
Nested Loop Left Join	1	0.000 ms	0.0 %
Seq Scan	3	0.576 ms	0.5 %
Sort	1	0.186 ms	0.2 %

Per table stats

Table name	Scan count	Total time	% of query
scan type	count	sum of times	% of table
copy	3	0.780 ms	0.7 %
Index Scan	1	0.267 ms	34.2 %
Seq Scan	2	0.513 ms	65.8 %
copy_well	1	1.240 ms	1.0 %
Bitmap Heap Scan	1	1.240 ms	100.0 %
library	2	0.330 ms	0.3 %
Index Scan	1	0.267 ms	80.9 %
Seq Scan	1	0.063 ms	19.1 %
plate	4	0.390 ms	0.3 %
Bitmap Heap Scan	4	0.390 ms	100.0 %
plate_location	1	0.267 ms	0.2 %
Index Scan	1	0.267 ms	100.0 %
well	2	35.511 ms	30.0 %
Bitmap Heap Scan	2	35.511 ms	100.0 %

explain.depesz.com

PostgreSQL's explain analyze made readable

Result: ipvU

Color mode:

Visible columns:

Per node type stats

Per table stats