Skip to content

Instantly share code, notes, and snippets.

@kbrock kbrock/metrics_delete_1.sql Secret
Last active Feb 16, 2018

Embed
What would you like to do?
explain deleting from metrics
explain
DELETE FROM "metrics"
WHERE "metrics"."id" IN (
SELECT "metrics"."id"
FROM "metrics"
WHERE ("metrics"."timestamp" <= '2018-02-01 19:56:37.519979')
LIMIT 100
);
QUERY PLAN
------------------------------------------------------------------------------------------------------------------------------------------------------------------------
Delete on metrics (cost=25.69..37339.03 rows=2207 width=38)
Delete on metrics
Delete on metrics_00
Delete on metrics_01
Delete on metrics_02
Delete on metrics_03
Delete on metrics_04
Delete on metrics_05
Delete on metrics_06
Delete on metrics_07
Delete on metrics_08
Delete on metrics_09
Delete on metrics_10
Delete on metrics_11
Delete on metrics_12
Delete on metrics_13
Delete on metrics_14
Delete on metrics_15
Delete on metrics_16
Delete on metrics_17
Delete on metrics_18
Delete on metrics_19
Delete on metrics_20
Delete on metrics_21
Delete on metrics_22
Delete on metrics_23
-> Hash Semi Join (cost=25.69..25.69 rows=1 width=38)
Hash Cond: (metrics.id = "ANY_subquery".id)
-> Seq Scan on metrics (cost=0.00..0.00 rows=1 width=14)
-> Hash (cost=24.44..24.44 rows=100 width=40)
-> Subquery Scan on "ANY_subquery" (cost=0.00..24.44 rows=100 width=40)
-> Limit (cost=0.00..23.44 rows=100 width=8)
-> Append (cost=0.00..4412398.56 rows=18826783 width=8)
-> Seq Scan on metrics metrics_1 (cost=0.00..0.00 rows=1 width=8)
Filter: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Seq Scan on metrics_00 metrics_00_1 (cost=0.00..11.38 rows=37 width=8)
Filter: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Seq Scan on metrics_01 metrics_01_1 (cost=0.00..11.38 rows=37 width=8)
Filter: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Seq Scan on metrics_02 metrics_02_1 (cost=0.00..11.38 rows=37 width=8)
Filter: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Seq Scan on metrics_03 metrics_03_1 (cost=0.00..11.38 rows=37 width=8)
Filter: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Seq Scan on metrics_04 metrics_04_1 (cost=0.00..11.38 rows=37 width=8)
Filter: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Seq Scan on metrics_05 metrics_05_1 (cost=0.00..11.38 rows=37 width=8)
Filter: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Index Scan using index_metrics_06_on_ts_and_capture_interval_name on metrics_06 metrics_06_1 (cost=0.39..281.02 rows=1 width=8)
Index Cond: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Index Scan using index_metrics_07_on_ts_and_capture_interval_name on metrics_07 metrics_07_1 (cost=0.39..2286.23 rows=1 width=8)
Index Cond: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Index Scan using index_metrics_08_on_ts_and_capture_interval_name on metrics_08 metrics_08_1 (cost=0.12..8.14 rows=1 width=8)
Index Cond: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Index Scan using index_metrics_09_on_ts_and_capture_interval_name on metrics_09 metrics_09_1 (cost=0.40..222.58 rows=1 width=8)
Index Cond: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Bitmap Heap Scan on metrics_10 metrics_10_1 (cost=1808.68..6977.71 rows=1566 width=8)
Recheck Cond: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Bitmap Index Scan on index_metrics_10_on_ts_and_capture_interval_name (cost=0.00..1808.29 rows=1566 width=0)
Index Cond: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Seq Scan on metrics_11 metrics_11_1 (cost=0.00..245446.61 rows=487284 width=8)
Filter: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Index Scan using index_metrics_12_on_ts_and_capture_interval_name on metrics_12 metrics_12_1 (cost=0.55..284.03 rows=66 width=8)
Index Cond: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Seq Scan on metrics_13 metrics_13_1 (cost=0.00..486237.14 rows=1823609 width=8)
Filter: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Seq Scan on metrics_14 metrics_14_1 (cost=0.00..103778.50 rows=271425 width=8)
Filter: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Seq Scan on metrics_15 metrics_15_1 (cost=0.00..435378.46 rows=1451402 width=8)
Filter: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Seq Scan on metrics_16 metrics_16_1 (cost=0.00..25891.25 rows=1411022 width=8)
Filter: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Bitmap Heap Scan on metrics_17 metrics_17_1 (cost=15380.68..205479.54 rows=87291 width=8)
Recheck Cond: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Bitmap Index Scan on index_metrics_17_on_ts_and_capture_interval_name (cost=0.00..15358.86 rows=87291 width=0)
Index Cond: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Seq Scan on metrics_18 metrics_18_1 (cost=0.00..424833.28 rows=1949687 width=8)
Filter: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Seq Scan on metrics_19 metrics_19_1 (cost=0.00..493598.59 rows=2990170 width=8)
Filter: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Seq Scan on metrics_20 metrics_20_1 (cost=0.00..492859.35 rows=2080476 width=8)
Filter: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Seq Scan on metrics_21 metrics_21_1 (cost=0.00..496204.62 rows=2088911 width=8)
Filter: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Seq Scan on metrics_22 metrics_22_1 (cost=0.00..496263.41 rows=2103562 width=8)
Filter: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Seq Scan on metrics_23 metrics_23_1 (cost=0.00..496299.85 rows=2080085 width=8)
Filter: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Hash Semi Join (cost=25.69..38.19 rows=100 width=38)
Hash Cond: (metrics_00.id = "ANY_subquery_1".id)
-> Seq Scan on metrics_00 (cost=0.00..11.10 rows=110 width=14)
-> Hash (cost=24.44..24.44 rows=100 width=40)
-> Subquery Scan on "ANY_subquery_1" (cost=0.00..24.44 rows=100 width=40)
-> Limit (cost=0.00..23.44 rows=100 width=8)
-> Append (cost=0.00..4412398.56 rows=18826783 width=8)
-> Seq Scan on metrics metrics_2 (cost=0.00..0.00 rows=1 width=8)
Filter: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Seq Scan on metrics_00 metrics_00_2 (cost=0.00..11.38 rows=37 width=8)
Filter: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Seq Scan on metrics_01 metrics_01_2 (cost=0.00..11.38 rows=37 width=8)
Filter: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Seq Scan on metrics_02 metrics_02_2 (cost=0.00..11.38 rows=37 width=8)
Filter: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Seq Scan on metrics_03 metrics_03_2 (cost=0.00..11.38 rows=37 width=8)
Filter: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Seq Scan on metrics_04 metrics_04_2 (cost=0.00..11.38 rows=37 width=8)
Filter: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Seq Scan on metrics_05 metrics_05_2 (cost=0.00..11.38 rows=37 width=8)
Filter: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Index Scan using index_metrics_06_on_ts_and_capture_interval_name on metrics_06 metrics_06_2 (cost=0.39..281.02 rows=1 width=8)
Index Cond: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Index Scan using index_metrics_07_on_ts_and_capture_interval_name on metrics_07 metrics_07_2 (cost=0.39..2286.23 rows=1 width=8)
Index Cond: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Index Scan using index_metrics_08_on_ts_and_capture_interval_name on metrics_08 metrics_08_2 (cost=0.12..8.14 rows=1 width=8)
Index Cond: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Index Scan using index_metrics_09_on_ts_and_capture_interval_name on metrics_09 metrics_09_2 (cost=0.40..222.58 rows=1 width=8)
Index Cond: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Bitmap Heap Scan on metrics_10 metrics_10_2 (cost=1808.68..6977.71 rows=1566 width=8)
Recheck Cond: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Bitmap Index Scan on index_metrics_10_on_ts_and_capture_interval_name (cost=0.00..1808.29 rows=1566 width=0)
Index Cond: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Seq Scan on metrics_11 metrics_11_2 (cost=0.00..245446.61 rows=487284 width=8)
Filter: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Index Scan using index_metrics_12_on_ts_and_capture_interval_name on metrics_12 metrics_12_2 (cost=0.55..284.03 rows=66 width=8)
Index Cond: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Seq Scan on metrics_13 metrics_13_2 (cost=0.00..486237.14 rows=1823609 width=8)
Filter: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Seq Scan on metrics_14 metrics_14_2 (cost=0.00..103778.50 rows=271425 width=8)
Filter: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Seq Scan on metrics_15 metrics_15_2 (cost=0.00..435378.46 rows=1451402 width=8)
Filter: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Seq Scan on metrics_16 metrics_16_2 (cost=0.00..25891.25 rows=1411022 width=8)
Filter: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Bitmap Heap Scan on metrics_17 metrics_17_2 (cost=15380.68..205479.54 rows=87291 width=8)
Recheck Cond: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Bitmap Index Scan on index_metrics_17_on_ts_and_capture_interval_name (cost=0.00..15358.86 rows=87291 width=0)
Index Cond: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Seq Scan on metrics_18 metrics_18_2 (cost=0.00..424833.28 rows=1949687 width=8)
Filter: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Seq Scan on metrics_19 metrics_19_2 (cost=0.00..493598.59 rows=2990170 width=8)
Filter: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Seq Scan on metrics_20 metrics_20_2 (cost=0.00..492859.35 rows=2080476 width=8)
Filter: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Seq Scan on metrics_21 metrics_21_2 (cost=0.00..496204.62 rows=2088911 width=8)
Filter: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Seq Scan on metrics_22 metrics_22_2 (cost=0.00..496263.41 rows=2103562 width=8)
Filter: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Seq Scan on metrics_23 metrics_23_2 (cost=0.00..496299.85 rows=2080085 width=8)
Filter: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Hash Semi Join (cost=25.69..38.19 rows=100 width=38)
Hash Cond: (metrics_01.id = "ANY_subquery_2".id)
-> Seq Scan on metrics_01 (cost=0.00..11.10 rows=110 width=14)
-> Hash (cost=24.44..24.44 rows=100 width=40)
-> Subquery Scan on "ANY_subquery_2" (cost=0.00..24.44 rows=100 width=40)
-> Limit (cost=0.00..23.44 rows=100 width=8)
-> Append (cost=0.00..4412398.56 rows=18826783 width=8)
-> Seq Scan on metrics metrics_3 (cost=0.00..0.00 rows=1 width=8)
Filter: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Seq Scan on metrics_00 metrics_00_3 (cost=0.00..11.38 rows=37 width=8)
Filter: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Seq Scan on metrics_01 metrics_01_3 (cost=0.00..11.38 rows=37 width=8)
Filter: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Seq Scan on metrics_02 metrics_02_3 (cost=0.00..11.38 rows=37 width=8)
Filter: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Seq Scan on metrics_03 metrics_03_3 (cost=0.00..11.38 rows=37 width=8)
Filter: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Seq Scan on metrics_04 metrics_04_3 (cost=0.00..11.38 rows=37 width=8)
Filter: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Seq Scan on metrics_05 metrics_05_3 (cost=0.00..11.38 rows=37 width=8)
Filter: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Index Scan using index_metrics_06_on_ts_and_capture_interval_name on metrics_06 metrics_06_3 (cost=0.39..281.02 rows=1 width=8)
Index Cond: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Index Scan using index_metrics_07_on_ts_and_capture_interval_name on metrics_07 metrics_07_3 (cost=0.39..2286.23 rows=1 width=8)
Index Cond: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Index Scan using index_metrics_08_on_ts_and_capture_interval_name on metrics_08 metrics_08_3 (cost=0.12..8.14 rows=1 width=8)
Index Cond: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Index Scan using index_metrics_09_on_ts_and_capture_interval_name on metrics_09 metrics_09_3 (cost=0.40..222.58 rows=1 width=8)
Index Cond: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Bitmap Heap Scan on metrics_10 metrics_10_3 (cost=1808.68..6977.71 rows=1566 width=8)
Recheck Cond: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Bitmap Index Scan on index_metrics_10_on_ts_and_capture_interval_name (cost=0.00..1808.29 rows=1566 width=0)
Index Cond: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Seq Scan on metrics_11 metrics_11_3 (cost=0.00..245446.61 rows=487284 width=8)
Filter: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Index Scan using index_metrics_12_on_ts_and_capture_interval_name on metrics_12 metrics_12_3 (cost=0.55..284.03 rows=66 width=8)
Index Cond: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Seq Scan on metrics_13 metrics_13_3 (cost=0.00..486237.14 rows=1823609 width=8)
Filter: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Seq Scan on metrics_14 metrics_14_3 (cost=0.00..103778.50 rows=271425 width=8)
Filter: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Seq Scan on metrics_15 metrics_15_3 (cost=0.00..435378.46 rows=1451402 width=8)
Filter: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Seq Scan on metrics_16 metrics_16_3 (cost=0.00..25891.25 rows=1411022 width=8)
Filter: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Bitmap Heap Scan on metrics_17 metrics_17_3 (cost=15380.68..205479.54 rows=87291 width=8)
Recheck Cond: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Bitmap Index Scan on index_metrics_17_on_ts_and_capture_interval_name (cost=0.00..15358.86 rows=87291 width=0)
Index Cond: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Seq Scan on metrics_18 metrics_18_3 (cost=0.00..424833.28 rows=1949687 width=8)
Filter: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Seq Scan on metrics_19 metrics_19_3 (cost=0.00..493598.59 rows=2990170 width=8)
Filter: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Seq Scan on metrics_20 metrics_20_3 (cost=0.00..492859.35 rows=2080476 width=8)
Filter: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Seq Scan on metrics_21 metrics_21_3 (cost=0.00..496204.62 rows=2088911 width=8)
Filter: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Seq Scan on metrics_22 metrics_22_3 (cost=0.00..496263.41 rows=2103562 width=8)
Filter: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Seq Scan on metrics_23 metrics_23_3 (cost=0.00..496299.85 rows=2080085 width=8)
Filter: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Hash Semi Join (cost=25.69..38.19 rows=100 width=38)
Hash Cond: (metrics_02.id = "ANY_subquery_3".id)
-> Seq Scan on metrics_02 (cost=0.00..11.10 rows=110 width=14)
-> Hash (cost=24.44..24.44 rows=100 width=40)
-> Subquery Scan on "ANY_subquery_3" (cost=0.00..24.44 rows=100 width=40)
-> Limit (cost=0.00..23.44 rows=100 width=8)
-> Append (cost=0.00..4412398.56 rows=18826783 width=8)
-> Seq Scan on metrics metrics_4 (cost=0.00..0.00 rows=1 width=8)
Filter: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Seq Scan on metrics_00 metrics_00_4 (cost=0.00..11.38 rows=37 width=8)
Filter: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Seq Scan on metrics_01 metrics_01_4 (cost=0.00..11.38 rows=37 width=8)
Filter: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Seq Scan on metrics_02 metrics_02_4 (cost=0.00..11.38 rows=37 width=8)
Filter: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Seq Scan on metrics_03 metrics_03_4 (cost=0.00..11.38 rows=37 width=8)
Filter: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Seq Scan on metrics_04 metrics_04_4 (cost=0.00..11.38 rows=37 width=8)
Filter: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Seq Scan on metrics_05 metrics_05_4 (cost=0.00..11.38 rows=37 width=8)
Filter: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Index Scan using index_metrics_06_on_ts_and_capture_interval_name on metrics_06 metrics_06_4 (cost=0.39..281.02 rows=1 width=8)
Index Cond: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Index Scan using index_metrics_07_on_ts_and_capture_interval_name on metrics_07 metrics_07_4 (cost=0.39..2286.23 rows=1 width=8)
Index Cond: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Index Scan using index_metrics_08_on_ts_and_capture_interval_name on metrics_08 metrics_08_4 (cost=0.12..8.14 rows=1 width=8)
Index Cond: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Index Scan using index_metrics_09_on_ts_and_capture_interval_name on metrics_09 metrics_09_4 (cost=0.40..222.58 rows=1 width=8)
Index Cond: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Bitmap Heap Scan on metrics_10 metrics_10_4 (cost=1808.68..6977.71 rows=1566 width=8)
Recheck Cond: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Bitmap Index Scan on index_metrics_10_on_ts_and_capture_interval_name (cost=0.00..1808.29 rows=1566 width=0)
Index Cond: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Seq Scan on metrics_11 metrics_11_4 (cost=0.00..245446.61 rows=487284 width=8)
Filter: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Index Scan using index_metrics_12_on_ts_and_capture_interval_name on metrics_12 metrics_12_4 (cost=0.55..284.03 rows=66 width=8)
Index Cond: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Seq Scan on metrics_13 metrics_13_4 (cost=0.00..486237.14 rows=1823609 width=8)
Filter: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Seq Scan on metrics_14 metrics_14_4 (cost=0.00..103778.50 rows=271425 width=8)
Filter: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Seq Scan on metrics_15 metrics_15_4 (cost=0.00..435378.46 rows=1451402 width=8)
Filter: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Seq Scan on metrics_16 metrics_16_4 (cost=0.00..25891.25 rows=1411022 width=8)
Filter: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Bitmap Heap Scan on metrics_17 metrics_17_4 (cost=15380.68..205479.54 rows=87291 width=8)
Recheck Cond: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Bitmap Index Scan on index_metrics_17_on_ts_and_capture_interval_name (cost=0.00..15358.86 rows=87291 width=0)
Index Cond: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Seq Scan on metrics_18 metrics_18_4 (cost=0.00..424833.28 rows=1949687 width=8)
Filter: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Seq Scan on metrics_19 metrics_19_4 (cost=0.00..493598.59 rows=2990170 width=8)
Filter: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Seq Scan on metrics_20 metrics_20_4 (cost=0.00..492859.35 rows=2080476 width=8)
Filter: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Seq Scan on metrics_21 metrics_21_4 (cost=0.00..496204.62 rows=2088911 width=8)
Filter: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Seq Scan on metrics_22 metrics_22_4 (cost=0.00..496263.41 rows=2103562 width=8)
Filter: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Seq Scan on metrics_23 metrics_23_4 (cost=0.00..496299.85 rows=2080085 width=8)
Filter: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Hash Semi Join (cost=25.69..38.19 rows=100 width=38)
Hash Cond: (metrics_03.id = "ANY_subquery_4".id)
-> Seq Scan on metrics_03 (cost=0.00..11.10 rows=110 width=14)
-> Hash (cost=24.44..24.44 rows=100 width=40)
-> Subquery Scan on "ANY_subquery_4" (cost=0.00..24.44 rows=100 width=40)
-> Limit (cost=0.00..23.44 rows=100 width=8)
-> Append (cost=0.00..4412398.56 rows=18826783 width=8)
-> Seq Scan on metrics metrics_5 (cost=0.00..0.00 rows=1 width=8)
Filter: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Seq Scan on metrics_00 metrics_00_5 (cost=0.00..11.38 rows=37 width=8)
Filter: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Seq Scan on metrics_01 metrics_01_5 (cost=0.00..11.38 rows=37 width=8)
Filter: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Seq Scan on metrics_02 metrics_02_5 (cost=0.00..11.38 rows=37 width=8)
Filter: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Seq Scan on metrics_03 metrics_03_5 (cost=0.00..11.38 rows=37 width=8)
Filter: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Seq Scan on metrics_04 metrics_04_5 (cost=0.00..11.38 rows=37 width=8)
Filter: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Seq Scan on metrics_05 metrics_05_5 (cost=0.00..11.38 rows=37 width=8)
Filter: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Index Scan using index_metrics_06_on_ts_and_capture_interval_name on metrics_06 metrics_06_5 (cost=0.39..281.02 rows=1 width=8)
Index Cond: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Index Scan using index_metrics_07_on_ts_and_capture_interval_name on metrics_07 metrics_07_5 (cost=0.39..2286.23 rows=1 width=8)
Index Cond: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Index Scan using index_metrics_08_on_ts_and_capture_interval_name on metrics_08 metrics_08_5 (cost=0.12..8.14 rows=1 width=8)
Index Cond: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Index Scan using index_metrics_09_on_ts_and_capture_interval_name on metrics_09 metrics_09_5 (cost=0.40..222.58 rows=1 width=8)
Index Cond: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Bitmap Heap Scan on metrics_10 metrics_10_5 (cost=1808.68..6977.71 rows=1566 width=8)
Recheck Cond: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Bitmap Index Scan on index_metrics_10_on_ts_and_capture_interval_name (cost=0.00..1808.29 rows=1566 width=0)
Index Cond: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Seq Scan on metrics_11 metrics_11_5 (cost=0.00..245446.61 rows=487284 width=8)
Filter: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Index Scan using index_metrics_12_on_ts_and_capture_interval_name on metrics_12 metrics_12_5 (cost=0.55..284.03 rows=66 width=8)
Index Cond: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Seq Scan on metrics_13 metrics_13_5 (cost=0.00..486237.14 rows=1823609 width=8)
Filter: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Seq Scan on metrics_14 metrics_14_5 (cost=0.00..103778.50 rows=271425 width=8)
Filter: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Seq Scan on metrics_15 metrics_15_5 (cost=0.00..435378.46 rows=1451402 width=8)
Filter: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Seq Scan on metrics_16 metrics_16_5 (cost=0.00..25891.25 rows=1411022 width=8)
Filter: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Bitmap Heap Scan on metrics_17 metrics_17_5 (cost=15380.68..205479.54 rows=87291 width=8)
Recheck Cond: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Bitmap Index Scan on index_metrics_17_on_ts_and_capture_interval_name (cost=0.00..15358.86 rows=87291 width=0)
Index Cond: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Seq Scan on metrics_18 metrics_18_5 (cost=0.00..424833.28 rows=1949687 width=8)
Filter: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Seq Scan on metrics_19 metrics_19_5 (cost=0.00..493598.59 rows=2990170 width=8)
Filter: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Seq Scan on metrics_20 metrics_20_5 (cost=0.00..492859.35 rows=2080476 width=8)
Filter: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Seq Scan on metrics_21 metrics_21_5 (cost=0.00..496204.62 rows=2088911 width=8)
Filter: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Seq Scan on metrics_22 metrics_22_5 (cost=0.00..496263.41 rows=2103562 width=8)
Filter: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Seq Scan on metrics_23 metrics_23_5 (cost=0.00..496299.85 rows=2080085 width=8)
Filter: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Hash Semi Join (cost=25.69..38.19 rows=100 width=38)
Hash Cond: (metrics_04.id = "ANY_subquery_5".id)
-> Seq Scan on metrics_04 (cost=0.00..11.10 rows=110 width=14)
-> Hash (cost=24.44..24.44 rows=100 width=40)
-> Subquery Scan on "ANY_subquery_5" (cost=0.00..24.44 rows=100 width=40)
-> Limit (cost=0.00..23.44 rows=100 width=8)
-> Append (cost=0.00..4412398.56 rows=18826783 width=8)
-> Seq Scan on metrics metrics_6 (cost=0.00..0.00 rows=1 width=8)
Filter: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Seq Scan on metrics_00 metrics_00_6 (cost=0.00..11.38 rows=37 width=8)
Filter: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Seq Scan on metrics_01 metrics_01_6 (cost=0.00..11.38 rows=37 width=8)
Filter: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Seq Scan on metrics_02 metrics_02_6 (cost=0.00..11.38 rows=37 width=8)
Filter: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Seq Scan on metrics_03 metrics_03_6 (cost=0.00..11.38 rows=37 width=8)
Filter: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Seq Scan on metrics_04 metrics_04_6 (cost=0.00..11.38 rows=37 width=8)
Filter: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Seq Scan on metrics_05 metrics_05_6 (cost=0.00..11.38 rows=37 width=8)
Filter: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Index Scan using index_metrics_06_on_ts_and_capture_interval_name on metrics_06 metrics_06_6 (cost=0.39..281.02 rows=1 width=8)
Index Cond: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Index Scan using index_metrics_07_on_ts_and_capture_interval_name on metrics_07 metrics_07_6 (cost=0.39..2286.23 rows=1 width=8)
Index Cond: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Index Scan using index_metrics_08_on_ts_and_capture_interval_name on metrics_08 metrics_08_6 (cost=0.12..8.14 rows=1 width=8)
Index Cond: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Index Scan using index_metrics_09_on_ts_and_capture_interval_name on metrics_09 metrics_09_6 (cost=0.40..222.58 rows=1 width=8)
Index Cond: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Bitmap Heap Scan on metrics_10 metrics_10_6 (cost=1808.68..6977.71 rows=1566 width=8)
Recheck Cond: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Bitmap Index Scan on index_metrics_10_on_ts_and_capture_interval_name (cost=0.00..1808.29 rows=1566 width=0)
Index Cond: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Seq Scan on metrics_11 metrics_11_6 (cost=0.00..245446.61 rows=487284 width=8)
Filter: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Index Scan using index_metrics_12_on_ts_and_capture_interval_name on metrics_12 metrics_12_6 (cost=0.55..284.03 rows=66 width=8)
Index Cond: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Seq Scan on metrics_13 metrics_13_6 (cost=0.00..486237.14 rows=1823609 width=8)
Filter: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Seq Scan on metrics_14 metrics_14_6 (cost=0.00..103778.50 rows=271425 width=8)
Filter: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Seq Scan on metrics_15 metrics_15_6 (cost=0.00..435378.46 rows=1451402 width=8)
Filter: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Seq Scan on metrics_16 metrics_16_6 (cost=0.00..25891.25 rows=1411022 width=8)
Filter: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Bitmap Heap Scan on metrics_17 metrics_17_6 (cost=15380.68..205479.54 rows=87291 width=8)
Recheck Cond: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Bitmap Index Scan on index_metrics_17_on_ts_and_capture_interval_name (cost=0.00..15358.86 rows=87291 width=0)
Index Cond: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Seq Scan on metrics_18 metrics_18_6 (cost=0.00..424833.28 rows=1949687 width=8)
Filter: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Seq Scan on metrics_19 metrics_19_6 (cost=0.00..493598.59 rows=2990170 width=8)
Filter: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Seq Scan on metrics_20 metrics_20_6 (cost=0.00..492859.35 rows=2080476 width=8)
Filter: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Seq Scan on metrics_21 metrics_21_6 (cost=0.00..496204.62 rows=2088911 width=8)
Filter: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Seq Scan on metrics_22 metrics_22_6 (cost=0.00..496263.41 rows=2103562 width=8)
Filter: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Seq Scan on metrics_23 metrics_23_6 (cost=0.00..496299.85 rows=2080085 width=8)
Filter: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Hash Semi Join (cost=25.69..38.19 rows=100 width=38)
Hash Cond: (metrics_05.id = "ANY_subquery_6".id)
-> Seq Scan on metrics_05 (cost=0.00..11.10 rows=110 width=14)
-> Hash (cost=24.44..24.44 rows=100 width=40)
-> Subquery Scan on "ANY_subquery_6" (cost=0.00..24.44 rows=100 width=40)
-> Limit (cost=0.00..23.44 rows=100 width=8)
-> Append (cost=0.00..4412398.56 rows=18826783 width=8)
-> Seq Scan on metrics metrics_7 (cost=0.00..0.00 rows=1 width=8)
Filter: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Seq Scan on metrics_00 metrics_00_7 (cost=0.00..11.38 rows=37 width=8)
Filter: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Seq Scan on metrics_01 metrics_01_7 (cost=0.00..11.38 rows=37 width=8)
Filter: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Seq Scan on metrics_02 metrics_02_7 (cost=0.00..11.38 rows=37 width=8)
Filter: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Seq Scan on metrics_03 metrics_03_7 (cost=0.00..11.38 rows=37 width=8)
Filter: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Seq Scan on metrics_04 metrics_04_7 (cost=0.00..11.38 rows=37 width=8)
Filter: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Seq Scan on metrics_05 metrics_05_7 (cost=0.00..11.38 rows=37 width=8)
Filter: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Index Scan using index_metrics_06_on_ts_and_capture_interval_name on metrics_06 metrics_06_7 (cost=0.39..281.02 rows=1 width=8)
Index Cond: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Index Scan using index_metrics_07_on_ts_and_capture_interval_name on metrics_07 metrics_07_7 (cost=0.39..2286.23 rows=1 width=8)
Index Cond: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Index Scan using index_metrics_08_on_ts_and_capture_interval_name on metrics_08 metrics_08_7 (cost=0.12..8.14 rows=1 width=8)
Index Cond: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Index Scan using index_metrics_09_on_ts_and_capture_interval_name on metrics_09 metrics_09_7 (cost=0.40..222.58 rows=1 width=8)
Index Cond: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Bitmap Heap Scan on metrics_10 metrics_10_7 (cost=1808.68..6977.71 rows=1566 width=8)
Recheck Cond: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Bitmap Index Scan on index_metrics_10_on_ts_and_capture_interval_name (cost=0.00..1808.29 rows=1566 width=0)
Index Cond: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Seq Scan on metrics_11 metrics_11_7 (cost=0.00..245446.61 rows=487284 width=8)
Filter: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Index Scan using index_metrics_12_on_ts_and_capture_interval_name on metrics_12 metrics_12_7 (cost=0.55..284.03 rows=66 width=8)
Index Cond: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Seq Scan on metrics_13 metrics_13_7 (cost=0.00..486237.14 rows=1823609 width=8)
Filter: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Seq Scan on metrics_14 metrics_14_7 (cost=0.00..103778.50 rows=271425 width=8)
Filter: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Seq Scan on metrics_15 metrics_15_7 (cost=0.00..435378.46 rows=1451402 width=8)
Filter: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Seq Scan on metrics_16 metrics_16_7 (cost=0.00..25891.25 rows=1411022 width=8)
Filter: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Bitmap Heap Scan on metrics_17 metrics_17_7 (cost=15380.68..205479.54 rows=87291 width=8)
Recheck Cond: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Bitmap Index Scan on index_metrics_17_on_ts_and_capture_interval_name (cost=0.00..15358.86 rows=87291 width=0)
Index Cond: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Seq Scan on metrics_18 metrics_18_7 (cost=0.00..424833.28 rows=1949687 width=8)
Filter: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Seq Scan on metrics_19 metrics_19_7 (cost=0.00..493598.59 rows=2990170 width=8)
Filter: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Seq Scan on metrics_20 metrics_20_7 (cost=0.00..492859.35 rows=2080476 width=8)
Filter: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Seq Scan on metrics_21 metrics_21_7 (cost=0.00..496204.62 rows=2088911 width=8)
Filter: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Seq Scan on metrics_22 metrics_22_7 (cost=0.00..496263.41 rows=2103562 width=8)
Filter: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Seq Scan on metrics_23 metrics_23_7 (cost=0.00..496299.85 rows=2080085 width=8)
Filter: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Nested Loop (cost=84.05..6363.96 rows=90 width=38)
-> HashAggregate (cost=24.69..25.69 rows=100 width=40)
Group Key: "ANY_subquery_7".id
-> Subquery Scan on "ANY_subquery_7" (cost=0.00..24.44 rows=100 width=40)
-> Limit (cost=0.00..23.44 rows=100 width=8)
-> Append (cost=0.00..4412398.56 rows=18826783 width=8)
-> Seq Scan on metrics metrics_8 (cost=0.00..0.00 rows=1 width=8)
Filter: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Seq Scan on metrics_00 metrics_00_8 (cost=0.00..11.38 rows=37 width=8)
Filter: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Seq Scan on metrics_01 metrics_01_8 (cost=0.00..11.38 rows=37 width=8)
Filter: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Seq Scan on metrics_02 metrics_02_8 (cost=0.00..11.38 rows=37 width=8)
Filter: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Seq Scan on metrics_03 metrics_03_8 (cost=0.00..11.38 rows=37 width=8)
Filter: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Seq Scan on metrics_04 metrics_04_8 (cost=0.00..11.38 rows=37 width=8)
Filter: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Seq Scan on metrics_05 metrics_05_8 (cost=0.00..11.38 rows=37 width=8)
Filter: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Index Scan using index_metrics_06_on_ts_and_capture_interval_name on metrics_06 metrics_06_8 (cost=0.39..281.02 rows=1 width=8)
Index Cond: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Index Scan using index_metrics_07_on_ts_and_capture_interval_name on metrics_07 metrics_07_8 (cost=0.39..2286.23 rows=1 width=8)
Index Cond: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Index Scan using index_metrics_08_on_ts_and_capture_interval_name on metrics_08 metrics_08_8 (cost=0.12..8.14 rows=1 width=8)
Index Cond: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Index Scan using index_metrics_09_on_ts_and_capture_interval_name on metrics_09 metrics_09_8 (cost=0.40..222.58 rows=1 width=8)
Index Cond: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Bitmap Heap Scan on metrics_10 metrics_10_8 (cost=1808.68..6977.71 rows=1566 width=8)
Recheck Cond: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Bitmap Index Scan on index_metrics_10_on_ts_and_capture_interval_name (cost=0.00..1808.29 rows=1566 width=0)
Index Cond: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Seq Scan on metrics_11 metrics_11_8 (cost=0.00..245446.61 rows=487284 width=8)
Filter: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Index Scan using index_metrics_12_on_ts_and_capture_interval_name on metrics_12 metrics_12_8 (cost=0.55..284.03 rows=66 width=8)
Index Cond: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Seq Scan on metrics_13 metrics_13_8 (cost=0.00..486237.14 rows=1823609 width=8)
Filter: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Seq Scan on metrics_14 metrics_14_8 (cost=0.00..103778.50 rows=271425 width=8)
Filter: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Seq Scan on metrics_15 metrics_15_8 (cost=0.00..435378.46 rows=1451402 width=8)
Filter: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Seq Scan on metrics_16 metrics_16_8 (cost=0.00..25891.25 rows=1411022 width=8)
Filter: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Bitmap Heap Scan on metrics_17 metrics_17_8 (cost=15380.68..205479.54 rows=87291 width=8)
Recheck Cond: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Bitmap Index Scan on index_metrics_17_on_ts_and_capture_interval_name (cost=0.00..15358.86 rows=87291 width=0)
Index Cond: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Seq Scan on metrics_18 metrics_18_8 (cost=0.00..424833.28 rows=1949687 width=8)
Filter: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Seq Scan on metrics_19 metrics_19_8 (cost=0.00..493598.59 rows=2990170 width=8)
Filter: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Seq Scan on metrics_20 metrics_20_8 (cost=0.00..492859.35 rows=2080476 width=8)
Filter: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Seq Scan on metrics_21 metrics_21_8 (cost=0.00..496204.62 rows=2088911 width=8)
Filter: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Seq Scan on metrics_22 metrics_22_8 (cost=0.00..496263.41 rows=2103562 width=8)
Filter: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Seq Scan on metrics_23 metrics_23_8 (cost=0.00..496299.85 rows=2080085 width=8)
Filter: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Bitmap Heap Scan on metrics_06 (cost=59.36..63.37 rows=1 width=14)
Recheck Cond: (id = "ANY_subquery_7".id)
-> Bitmap Index Scan on metrics_06_pkey (cost=0.00..59.36 rows=1 width=0)
Index Cond: (id = "ANY_subquery_7".id)
-> Nested Loop (cost=138.40..11799.21 rows=15 width=38)
-> HashAggregate (cost=24.69..25.69 rows=100 width=40)
Group Key: "ANY_subquery_8".id
-> Subquery Scan on "ANY_subquery_8" (cost=0.00..24.44 rows=100 width=40)
-> Limit (cost=0.00..23.44 rows=100 width=8)
-> Append (cost=0.00..4412398.56 rows=18826783 width=8)
-> Seq Scan on metrics metrics_9 (cost=0.00..0.00 rows=1 width=8)
Filter: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Seq Scan on metrics_00 metrics_00_9 (cost=0.00..11.38 rows=37 width=8)
Filter: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Seq Scan on metrics_01 metrics_01_9 (cost=0.00..11.38 rows=37 width=8)
Filter: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Seq Scan on metrics_02 metrics_02_9 (cost=0.00..11.38 rows=37 width=8)
Filter: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Seq Scan on metrics_03 metrics_03_9 (cost=0.00..11.38 rows=37 width=8)
Filter: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Seq Scan on metrics_04 metrics_04_9 (cost=0.00..11.38 rows=37 width=8)
Filter: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Seq Scan on metrics_05 metrics_05_9 (cost=0.00..11.38 rows=37 width=8)
Filter: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Index Scan using index_metrics_06_on_ts_and_capture_interval_name on metrics_06 metrics_06_9 (cost=0.39..281.02 rows=1 width=8)
Index Cond: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Index Scan using index_metrics_07_on_ts_and_capture_interval_name on metrics_07 metrics_07_9 (cost=0.39..2286.23 rows=1 width=8)
Index Cond: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Index Scan using index_metrics_08_on_ts_and_capture_interval_name on metrics_08 metrics_08_9 (cost=0.12..8.14 rows=1 width=8)
Index Cond: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Index Scan using index_metrics_09_on_ts_and_capture_interval_name on metrics_09 metrics_09_9 (cost=0.40..222.58 rows=1 width=8)
Index Cond: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Bitmap Heap Scan on metrics_10 metrics_10_9 (cost=1808.68..6977.71 rows=1566 width=8)
Recheck Cond: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Bitmap Index Scan on index_metrics_10_on_ts_and_capture_interval_name (cost=0.00..1808.29 rows=1566 width=0)
Index Cond: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Seq Scan on metrics_11 metrics_11_9 (cost=0.00..245446.61 rows=487284 width=8)
Filter: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Index Scan using index_metrics_12_on_ts_and_capture_interval_name on metrics_12 metrics_12_9 (cost=0.55..284.03 rows=66 width=8)
Index Cond: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Seq Scan on metrics_13 metrics_13_9 (cost=0.00..486237.14 rows=1823609 width=8)
Filter: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Seq Scan on metrics_14 metrics_14_9 (cost=0.00..103778.50 rows=271425 width=8)
Filter: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Seq Scan on metrics_15 metrics_15_9 (cost=0.00..435378.46 rows=1451402 width=8)
Filter: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Seq Scan on metrics_16 metrics_16_9 (cost=0.00..25891.25 rows=1411022 width=8)
Filter: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Bitmap Heap Scan on metrics_17 metrics_17_9 (cost=15380.68..205479.54 rows=87291 width=8)
Recheck Cond: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Bitmap Index Scan on index_metrics_17_on_ts_and_capture_interval_name (cost=0.00..15358.86 rows=87291 width=0)
Index Cond: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Seq Scan on metrics_18 metrics_18_9 (cost=0.00..424833.28 rows=1949687 width=8)
Filter: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Seq Scan on metrics_19 metrics_19_9 (cost=0.00..493598.59 rows=2990170 width=8)
Filter: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Seq Scan on metrics_20 metrics_20_9 (cost=0.00..492859.35 rows=2080476 width=8)
Filter: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Seq Scan on metrics_21 metrics_21_9 (cost=0.00..496204.62 rows=2088911 width=8)
Filter: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Seq Scan on metrics_22 metrics_22_9 (cost=0.00..496263.41 rows=2103562 width=8)
Filter: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Seq Scan on metrics_23 metrics_23_9 (cost=0.00..496299.85 rows=2080085 width=8)
Filter: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Bitmap Heap Scan on metrics_07 (cost=113.71..117.73 rows=1 width=14)
Recheck Cond: (id = "ANY_subquery_8".id)
-> Bitmap Index Scan on metrics_07_pkey (cost=0.00..113.71 rows=1 width=0)
Index Cond: (id = "ANY_subquery_8".id)
-> Nested Loop (cost=28.78..837.21 rows=1 width=38)
-> HashAggregate (cost=24.69..25.69 rows=100 width=40)
Group Key: "ANY_subquery_9".id
-> Subquery Scan on "ANY_subquery_9" (cost=0.00..24.44 rows=100 width=40)
-> Limit (cost=0.00..23.44 rows=100 width=8)
-> Append (cost=0.00..4412398.56 rows=18826783 width=8)
-> Seq Scan on metrics metrics_24 (cost=0.00..0.00 rows=1 width=8)
Filter: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Seq Scan on metrics_00 metrics_00_10 (cost=0.00..11.38 rows=37 width=8)
Filter: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Seq Scan on metrics_01 metrics_01_10 (cost=0.00..11.38 rows=37 width=8)
Filter: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Seq Scan on metrics_02 metrics_02_10 (cost=0.00..11.38 rows=37 width=8)
Filter: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Seq Scan on metrics_03 metrics_03_10 (cost=0.00..11.38 rows=37 width=8)
Filter: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Seq Scan on metrics_04 metrics_04_10 (cost=0.00..11.38 rows=37 width=8)
Filter: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Seq Scan on metrics_05 metrics_05_10 (cost=0.00..11.38 rows=37 width=8)
Filter: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Index Scan using index_metrics_06_on_ts_and_capture_interval_name on metrics_06 metrics_06_10 (cost=0.39..281.02 rows=1 width=8)
Index Cond: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Index Scan using index_metrics_07_on_ts_and_capture_interval_name on metrics_07 metrics_07_10 (cost=0.39..2286.23 rows=1 width=8)
Index Cond: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Index Scan using index_metrics_08_on_ts_and_capture_interval_name on metrics_08 metrics_08_10 (cost=0.12..8.14 rows=1 width=8)
Index Cond: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Index Scan using index_metrics_09_on_ts_and_capture_interval_name on metrics_09 metrics_09_10 (cost=0.40..222.58 rows=1 width=8)
Index Cond: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Bitmap Heap Scan on metrics_10 metrics_10_10 (cost=1808.68..6977.71 rows=1566 width=8)
Recheck Cond: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Bitmap Index Scan on index_metrics_10_on_ts_and_capture_interval_name (cost=0.00..1808.29 rows=1566 width=0)
Index Cond: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Seq Scan on metrics_11 metrics_11_10 (cost=0.00..245446.61 rows=487284 width=8)
Filter: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Index Scan using index_metrics_12_on_ts_and_capture_interval_name on metrics_12 metrics_12_10 (cost=0.55..284.03 rows=66 width=8)
Index Cond: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Seq Scan on metrics_13 metrics_13_10 (cost=0.00..486237.14 rows=1823609 width=8)
Filter: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Seq Scan on metrics_14 metrics_14_10 (cost=0.00..103778.50 rows=271425 width=8)
Filter: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Seq Scan on metrics_15 metrics_15_10 (cost=0.00..435378.46 rows=1451402 width=8)
Filter: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Seq Scan on metrics_16 metrics_16_10 (cost=0.00..25891.25 rows=1411022 width=8)
Filter: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Bitmap Heap Scan on metrics_17 metrics_17_10 (cost=15380.68..205479.54 rows=87291 width=8)
Recheck Cond: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Bitmap Index Scan on index_metrics_17_on_ts_and_capture_interval_name (cost=0.00..15358.86 rows=87291 width=0)
Index Cond: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Seq Scan on metrics_18 metrics_18_10 (cost=0.00..424833.28 rows=1949687 width=8)
Filter: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Seq Scan on metrics_19 metrics_19_10 (cost=0.00..493598.59 rows=2990170 width=8)
Filter: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Seq Scan on metrics_20 metrics_20_10 (cost=0.00..492859.35 rows=2080476 width=8)
Filter: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Seq Scan on metrics_21 metrics_21_10 (cost=0.00..496204.62 rows=2088911 width=8)
Filter: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Seq Scan on metrics_22 metrics_22_10 (cost=0.00..496263.41 rows=2103562 width=8)
Filter: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Seq Scan on metrics_23 metrics_23_10 (cost=0.00..496299.85 rows=2080085 width=8)
Filter: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Bitmap Heap Scan on metrics_08 (cost=4.09..8.11 rows=1 width=14)
Recheck Cond: (id = "ANY_subquery_9".id)
-> Bitmap Index Scan on metrics_08_pkey (cost=0.00..4.09 rows=1 width=0)
Index Cond: (id = "ANY_subquery_9".id)
-> Nested Loop (cost=79.77..5936.21 rows=100 width=38)
-> HashAggregate (cost=24.69..25.69 rows=100 width=40)
Group Key: "ANY_subquery_10".id
-> Subquery Scan on "ANY_subquery_10" (cost=0.00..24.44 rows=100 width=40)
-> Limit (cost=0.00..23.44 rows=100 width=8)
-> Append (cost=0.00..4412398.56 rows=18826783 width=8)
-> Seq Scan on metrics metrics_25 (cost=0.00..0.00 rows=1 width=8)
Filter: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Seq Scan on metrics_00 metrics_00_11 (cost=0.00..11.38 rows=37 width=8)
Filter: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Seq Scan on metrics_01 metrics_01_11 (cost=0.00..11.38 rows=37 width=8)
Filter: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Seq Scan on metrics_02 metrics_02_11 (cost=0.00..11.38 rows=37 width=8)
Filter: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Seq Scan on metrics_03 metrics_03_11 (cost=0.00..11.38 rows=37 width=8)
Filter: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Seq Scan on metrics_04 metrics_04_11 (cost=0.00..11.38 rows=37 width=8)
Filter: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Seq Scan on metrics_05 metrics_05_11 (cost=0.00..11.38 rows=37 width=8)
Filter: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Index Scan using index_metrics_06_on_ts_and_capture_interval_name on metrics_06 metrics_06_11 (cost=0.39..281.02 rows=1 width=8)
Index Cond: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Index Scan using index_metrics_07_on_ts_and_capture_interval_name on metrics_07 metrics_07_11 (cost=0.39..2286.23 rows=1 width=8)
Index Cond: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Index Scan using index_metrics_08_on_ts_and_capture_interval_name on metrics_08 metrics_08_11 (cost=0.12..8.14 rows=1 width=8)
Index Cond: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Index Scan using index_metrics_09_on_ts_and_capture_interval_name on metrics_09 metrics_09_11 (cost=0.40..222.58 rows=1 width=8)
Index Cond: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Bitmap Heap Scan on metrics_10 metrics_10_11 (cost=1808.68..6977.71 rows=1566 width=8)
Recheck Cond: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Bitmap Index Scan on index_metrics_10_on_ts_and_capture_interval_name (cost=0.00..1808.29 rows=1566 width=0)
Index Cond: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Seq Scan on metrics_11 metrics_11_11 (cost=0.00..245446.61 rows=487284 width=8)
Filter: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Index Scan using index_metrics_12_on_ts_and_capture_interval_name on metrics_12 metrics_12_11 (cost=0.55..284.03 rows=66 width=8)
Index Cond: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Seq Scan on metrics_13 metrics_13_11 (cost=0.00..486237.14 rows=1823609 width=8)
Filter: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Seq Scan on metrics_14 metrics_14_11 (cost=0.00..103778.50 rows=271425 width=8)
Filter: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Seq Scan on metrics_15 metrics_15_11 (cost=0.00..435378.46 rows=1451402 width=8)
Filter: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Seq Scan on metrics_16 metrics_16_11 (cost=0.00..25891.25 rows=1411022 width=8)
Filter: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Bitmap Heap Scan on metrics_17 metrics_17_11 (cost=15380.68..205479.54 rows=87291 width=8)
Recheck Cond: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Bitmap Index Scan on index_metrics_17_on_ts_and_capture_interval_name (cost=0.00..15358.86 rows=87291 width=0)
Index Cond: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Seq Scan on metrics_18 metrics_18_11 (cost=0.00..424833.28 rows=1949687 width=8)
Filter: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Seq Scan on metrics_19 metrics_19_11 (cost=0.00..493598.59 rows=2990170 width=8)
Filter: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Seq Scan on metrics_20 metrics_20_11 (cost=0.00..492859.35 rows=2080476 width=8)
Filter: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Seq Scan on metrics_21 metrics_21_11 (cost=0.00..496204.62 rows=2088911 width=8)
Filter: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Seq Scan on metrics_22 metrics_22_11 (cost=0.00..496263.41 rows=2103562 width=8)
Filter: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Seq Scan on metrics_23 metrics_23_11 (cost=0.00..496299.85 rows=2080085 width=8)
Filter: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Bitmap Heap Scan on metrics_09 (cost=55.08..59.10 rows=1 width=14)
Recheck Cond: (id = "ANY_subquery_10".id)
-> Bitmap Index Scan on metrics_09_pkey (cost=0.00..55.08 rows=1 width=0)
Index Cond: (id = "ANY_subquery_10".id)
-> Nested Loop (cost=25.10..870.19 rows=100 width=38)
-> HashAggregate (cost=24.69..25.69 rows=100 width=40)
Group Key: "ANY_subquery_11".id
-> Subquery Scan on "ANY_subquery_11" (cost=0.00..24.44 rows=100 width=40)
-> Limit (cost=0.00..23.44 rows=100 width=8)
-> Append (cost=0.00..4412398.56 rows=18826783 width=8)
-> Seq Scan on metrics metrics_26 (cost=0.00..0.00 rows=1 width=8)
Filter: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Seq Scan on metrics_00 metrics_00_12 (cost=0.00..11.38 rows=37 width=8)
Filter: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Seq Scan on metrics_01 metrics_01_12 (cost=0.00..11.38 rows=37 width=8)
Filter: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Seq Scan on metrics_02 metrics_02_12 (cost=0.00..11.38 rows=37 width=8)
Filter: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Seq Scan on metrics_03 metrics_03_12 (cost=0.00..11.38 rows=37 width=8)
Filter: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Seq Scan on metrics_04 metrics_04_12 (cost=0.00..11.38 rows=37 width=8)
Filter: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Seq Scan on metrics_05 metrics_05_12 (cost=0.00..11.38 rows=37 width=8)
Filter: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Index Scan using index_metrics_06_on_ts_and_capture_interval_name on metrics_06 metrics_06_12 (cost=0.39..281.02 rows=1 width=8)
Index Cond: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Index Scan using index_metrics_07_on_ts_and_capture_interval_name on metrics_07 metrics_07_12 (cost=0.39..2286.23 rows=1 width=8)
Index Cond: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Index Scan using index_metrics_08_on_ts_and_capture_interval_name on metrics_08 metrics_08_12 (cost=0.12..8.14 rows=1 width=8)
Index Cond: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Index Scan using index_metrics_09_on_ts_and_capture_interval_name on metrics_09 metrics_09_12 (cost=0.40..222.58 rows=1 width=8)
Index Cond: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Bitmap Heap Scan on metrics_10 metrics_10_12 (cost=1808.68..6977.71 rows=1566 width=8)
Recheck Cond: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Bitmap Index Scan on index_metrics_10_on_ts_and_capture_interval_name (cost=0.00..1808.29 rows=1566 width=0)
Index Cond: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Seq Scan on metrics_11 metrics_11_12 (cost=0.00..245446.61 rows=487284 width=8)
Filter: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Index Scan using index_metrics_12_on_ts_and_capture_interval_name on metrics_12 metrics_12_12 (cost=0.55..284.03 rows=66 width=8)
Index Cond: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Seq Scan on metrics_13 metrics_13_12 (cost=0.00..486237.14 rows=1823609 width=8)
Filter: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Seq Scan on metrics_14 metrics_14_12 (cost=0.00..103778.50 rows=271425 width=8)
Filter: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Seq Scan on metrics_15 metrics_15_12 (cost=0.00..435378.46 rows=1451402 width=8)
Filter: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Seq Scan on metrics_16 metrics_16_12 (cost=0.00..25891.25 rows=1411022 width=8)
Filter: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Bitmap Heap Scan on metrics_17 metrics_17_12 (cost=15380.68..205479.54 rows=87291 width=8)
Recheck Cond: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Bitmap Index Scan on index_metrics_17_on_ts_and_capture_interval_name (cost=0.00..15358.86 rows=87291 width=0)
Index Cond: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Seq Scan on metrics_18 metrics_18_12 (cost=0.00..424833.28 rows=1949687 width=8)
Filter: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Seq Scan on metrics_19 metrics_19_12 (cost=0.00..493598.59 rows=2990170 width=8)
Filter: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Seq Scan on metrics_20 metrics_20_12 (cost=0.00..492859.35 rows=2080476 width=8)
Filter: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Seq Scan on metrics_21 metrics_21_12 (cost=0.00..496204.62 rows=2088911 width=8)
Filter: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Seq Scan on metrics_22 metrics_22_12 (cost=0.00..496263.41 rows=2103562 width=8)
Filter: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Seq Scan on metrics_23 metrics_23_12 (cost=0.00..496299.85 rows=2080085 width=8)
Filter: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Index Scan using metrics_10_pkey on metrics_10 (cost=0.42..8.44 rows=1 width=14)
Index Cond: (id = "ANY_subquery_11".id)
-> Nested Loop (cost=25.11..871.19 rows=100 width=38)
-> HashAggregate (cost=24.69..25.69 rows=100 width=40)
Group Key: "ANY_subquery_12".id
-> Subquery Scan on "ANY_subquery_12" (cost=0.00..24.44 rows=100 width=40)
-> Limit (cost=0.00..23.44 rows=100 width=8)
-> Append (cost=0.00..4412398.56 rows=18826783 width=8)
-> Seq Scan on metrics metrics_27 (cost=0.00..0.00 rows=1 width=8)
Filter: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Seq Scan on metrics_00 metrics_00_13 (cost=0.00..11.38 rows=37 width=8)
Filter: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Seq Scan on metrics_01 metrics_01_13 (cost=0.00..11.38 rows=37 width=8)
Filter: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Seq Scan on metrics_02 metrics_02_13 (cost=0.00..11.38 rows=37 width=8)
Filter: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Seq Scan on metrics_03 metrics_03_13 (cost=0.00..11.38 rows=37 width=8)
Filter: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Seq Scan on metrics_04 metrics_04_13 (cost=0.00..11.38 rows=37 width=8)
Filter: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Seq Scan on metrics_05 metrics_05_13 (cost=0.00..11.38 rows=37 width=8)
Filter: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Index Scan using index_metrics_06_on_ts_and_capture_interval_name on metrics_06 metrics_06_13 (cost=0.39..281.02 rows=1 width=8)
Index Cond: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Index Scan using index_metrics_07_on_ts_and_capture_interval_name on metrics_07 metrics_07_13 (cost=0.39..2286.23 rows=1 width=8)
Index Cond: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Index Scan using index_metrics_08_on_ts_and_capture_interval_name on metrics_08 metrics_08_13 (cost=0.12..8.14 rows=1 width=8)
Index Cond: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Index Scan using index_metrics_09_on_ts_and_capture_interval_name on metrics_09 metrics_09_13 (cost=0.40..222.58 rows=1 width=8)
Index Cond: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Bitmap Heap Scan on metrics_10 metrics_10_13 (cost=1808.68..6977.71 rows=1566 width=8)
Recheck Cond: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Bitmap Index Scan on index_metrics_10_on_ts_and_capture_interval_name (cost=0.00..1808.29 rows=1566 width=0)
Index Cond: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Seq Scan on metrics_11 metrics_11_13 (cost=0.00..245446.61 rows=487284 width=8)
Filter: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Index Scan using index_metrics_12_on_ts_and_capture_interval_name on metrics_12 metrics_12_13 (cost=0.55..284.03 rows=66 width=8)
Index Cond: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Seq Scan on metrics_13 metrics_13_13 (cost=0.00..486237.14 rows=1823609 width=8)
Filter: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Seq Scan on metrics_14 metrics_14_13 (cost=0.00..103778.50 rows=271425 width=8)
Filter: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Seq Scan on metrics_15 metrics_15_13 (cost=0.00..435378.46 rows=1451402 width=8)
Filter: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Seq Scan on metrics_16 metrics_16_13 (cost=0.00..25891.25 rows=1411022 width=8)
Filter: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Bitmap Heap Scan on metrics_17 metrics_17_13 (cost=15380.68..205479.54 rows=87291 width=8)
Recheck Cond: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Bitmap Index Scan on index_metrics_17_on_ts_and_capture_interval_name (cost=0.00..15358.86 rows=87291 width=0)
Index Cond: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Seq Scan on metrics_18 metrics_18_13 (cost=0.00..424833.28 rows=1949687 width=8)
Filter: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Seq Scan on metrics_19 metrics_19_13 (cost=0.00..493598.59 rows=2990170 width=8)
Filter: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Seq Scan on metrics_20 metrics_20_13 (cost=0.00..492859.35 rows=2080476 width=8)
Filter: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Seq Scan on metrics_21 metrics_21_13 (cost=0.00..496204.62 rows=2088911 width=8)
Filter: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Seq Scan on metrics_22 metrics_22_13 (cost=0.00..496263.41 rows=2103562 width=8)
Filter: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Seq Scan on metrics_23 metrics_23_13 (cost=0.00..496299.85 rows=2080085 width=8)
Filter: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Index Scan using metrics_11_pkey on metrics_11 (cost=0.43..8.45 rows=1 width=14)
Index Cond: (id = "ANY_subquery_12".id)
-> Nested Loop (cost=25.11..870.94 rows=100 width=38)
-> HashAggregate (cost=24.69..25.69 rows=100 width=40)
Group Key: "ANY_subquery_13".id
-> Subquery Scan on "ANY_subquery_13" (cost=0.00..24.44 rows=100 width=40)
-> Limit (cost=0.00..23.44 rows=100 width=8)
-> Append (cost=0.00..4412398.56 rows=18826783 width=8)
-> Seq Scan on metrics metrics_28 (cost=0.00..0.00 rows=1 width=8)
Filter: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Seq Scan on metrics_00 metrics_00_14 (cost=0.00..11.38 rows=37 width=8)
Filter: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Seq Scan on metrics_01 metrics_01_14 (cost=0.00..11.38 rows=37 width=8)
Filter: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Seq Scan on metrics_02 metrics_02_14 (cost=0.00..11.38 rows=37 width=8)
Filter: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Seq Scan on metrics_03 metrics_03_14 (cost=0.00..11.38 rows=37 width=8)
Filter: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Seq Scan on metrics_04 metrics_04_14 (cost=0.00..11.38 rows=37 width=8)
Filter: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Seq Scan on metrics_05 metrics_05_14 (cost=0.00..11.38 rows=37 width=8)
Filter: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Index Scan using index_metrics_06_on_ts_and_capture_interval_name on metrics_06 metrics_06_14 (cost=0.39..281.02 rows=1 width=8)
Index Cond: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Index Scan using index_metrics_07_on_ts_and_capture_interval_name on metrics_07 metrics_07_14 (cost=0.39..2286.23 rows=1 width=8)
Index Cond: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Index Scan using index_metrics_08_on_ts_and_capture_interval_name on metrics_08 metrics_08_14 (cost=0.12..8.14 rows=1 width=8)
Index Cond: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Index Scan using index_metrics_09_on_ts_and_capture_interval_name on metrics_09 metrics_09_14 (cost=0.40..222.58 rows=1 width=8)
Index Cond: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Bitmap Heap Scan on metrics_10 metrics_10_14 (cost=1808.68..6977.71 rows=1566 width=8)
Recheck Cond: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Bitmap Index Scan on index_metrics_10_on_ts_and_capture_interval_name (cost=0.00..1808.29 rows=1566 width=0)
Index Cond: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Seq Scan on metrics_11 metrics_11_14 (cost=0.00..245446.61 rows=487284 width=8)
Filter: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Index Scan using index_metrics_12_on_ts_and_capture_interval_name on metrics_12 metrics_12_14 (cost=0.55..284.03 rows=66 width=8)
Index Cond: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Seq Scan on metrics_13 metrics_13_14 (cost=0.00..486237.14 rows=1823609 width=8)
Filter: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Seq Scan on metrics_14 metrics_14_14 (cost=0.00..103778.50 rows=271425 width=8)
Filter: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Seq Scan on metrics_15 metrics_15_14 (cost=0.00..435378.46 rows=1451402 width=8)
Filter: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Seq Scan on metrics_16 metrics_16_14 (cost=0.00..25891.25 rows=1411022 width=8)
Filter: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Bitmap Heap Scan on metrics_17 metrics_17_14 (cost=15380.68..205479.54 rows=87291 width=8)
Recheck Cond: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Bitmap Index Scan on index_metrics_17_on_ts_and_capture_interval_name (cost=0.00..15358.86 rows=87291 width=0)
Index Cond: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Seq Scan on metrics_18 metrics_18_14 (cost=0.00..424833.28 rows=1949687 width=8)
Filter: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Seq Scan on metrics_19 metrics_19_14 (cost=0.00..493598.59 rows=2990170 width=8)
Filter: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Seq Scan on metrics_20 metrics_20_14 (cost=0.00..492859.35 rows=2080476 width=8)
Filter: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Seq Scan on metrics_21 metrics_21_14 (cost=0.00..496204.62 rows=2088911 width=8)
Filter: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Seq Scan on metrics_22 metrics_22_14 (cost=0.00..496263.41 rows=2103562 width=8)
Filter: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Seq Scan on metrics_23 metrics_23_14 (cost=0.00..496299.85 rows=2080085 width=8)
Filter: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Index Scan using metrics_12_pkey on metrics_12 (cost=0.42..8.44 rows=1 width=14)
Index Cond: (id = "ANY_subquery_13".id)
-> Nested Loop (cost=24.86..846.19 rows=100 width=38)
-> HashAggregate (cost=24.69..25.69 rows=100 width=40)
Group Key: "ANY_subquery_14".id
-> Subquery Scan on "ANY_subquery_14" (cost=0.00..24.44 rows=100 width=40)
-> Limit (cost=0.00..23.44 rows=100 width=8)
-> Append (cost=0.00..4412398.56 rows=18826783 width=8)
-> Seq Scan on metrics metrics_29 (cost=0.00..0.00 rows=1 width=8)
Filter: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Seq Scan on metrics_00 metrics_00_15 (cost=0.00..11.38 rows=37 width=8)
Filter: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Seq Scan on metrics_01 metrics_01_15 (cost=0.00..11.38 rows=37 width=8)
Filter: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Seq Scan on metrics_02 metrics_02_15 (cost=0.00..11.38 rows=37 width=8)
Filter: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Seq Scan on metrics_03 metrics_03_15 (cost=0.00..11.38 rows=37 width=8)
Filter: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Seq Scan on metrics_04 metrics_04_15 (cost=0.00..11.38 rows=37 width=8)
Filter: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Seq Scan on metrics_05 metrics_05_15 (cost=0.00..11.38 rows=37 width=8)
Filter: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Index Scan using index_metrics_06_on_ts_and_capture_interval_name on metrics_06 metrics_06_15 (cost=0.39..281.02 rows=1 width=8)
Index Cond: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Index Scan using index_metrics_07_on_ts_and_capture_interval_name on metrics_07 metrics_07_15 (cost=0.39..2286.23 rows=1 width=8)
Index Cond: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Index Scan using index_metrics_08_on_ts_and_capture_interval_name on metrics_08 metrics_08_15 (cost=0.12..8.14 rows=1 width=8)
Index Cond: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Index Scan using index_metrics_09_on_ts_and_capture_interval_name on metrics_09 metrics_09_15 (cost=0.40..222.58 rows=1 width=8)
Index Cond: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Bitmap Heap Scan on metrics_10 metrics_10_15 (cost=1808.68..6977.71 rows=1566 width=8)
Recheck Cond: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Bitmap Index Scan on index_metrics_10_on_ts_and_capture_interval_name (cost=0.00..1808.29 rows=1566 width=0)
Index Cond: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Seq Scan on metrics_11 metrics_11_15 (cost=0.00..245446.61 rows=487284 width=8)
Filter: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Index Scan using index_metrics_12_on_ts_and_capture_interval_name on metrics_12 metrics_12_15 (cost=0.55..284.03 rows=66 width=8)
Index Cond: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Seq Scan on metrics_13 metrics_13_15 (cost=0.00..486237.14 rows=1823609 width=8)
Filter: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Seq Scan on metrics_14 metrics_14_15 (cost=0.00..103778.50 rows=271425 width=8)
Filter: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Seq Scan on metrics_15 metrics_15_15 (cost=0.00..435378.46 rows=1451402 width=8)
Filter: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Seq Scan on metrics_16 metrics_16_15 (cost=0.00..25891.25 rows=1411022 width=8)
Filter: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Bitmap Heap Scan on metrics_17 metrics_17_15 (cost=15380.68..205479.54 rows=87291 width=8)
Recheck Cond: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Bitmap Index Scan on index_metrics_17_on_ts_and_capture_interval_name (cost=0.00..15358.86 rows=87291 width=0)
Index Cond: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Seq Scan on metrics_18 metrics_18_15 (cost=0.00..424833.28 rows=1949687 width=8)
Filter: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Seq Scan on metrics_19 metrics_19_15 (cost=0.00..493598.59 rows=2990170 width=8)
Filter: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Seq Scan on metrics_20 metrics_20_15 (cost=0.00..492859.35 rows=2080476 width=8)
Filter: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Seq Scan on metrics_21 metrics_21_15 (cost=0.00..496204.62 rows=2088911 width=8)
Filter: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Seq Scan on metrics_22 metrics_22_15 (cost=0.00..496263.41 rows=2103562 width=8)
Filter: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Seq Scan on metrics_23 metrics_23_15 (cost=0.00..496299.85 rows=2080085 width=8)
Filter: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Index Scan using metrics_13_pkey on metrics_13 (cost=0.18..8.20 rows=1 width=14)
Index Cond: (id = "ANY_subquery_14".id)
-> Nested Loop (cost=25.11..870.69 rows=100 width=38)
-> HashAggregate (cost=24.69..25.69 rows=100 width=40)
Group Key: "ANY_subquery_15".id
-> Subquery Scan on "ANY_subquery_15" (cost=0.00..24.44 rows=100 width=40)
-> Limit (cost=0.00..23.44 rows=100 width=8)
-> Append (cost=0.00..4412398.56 rows=18826783 width=8)
-> Seq Scan on metrics metrics_30 (cost=0.00..0.00 rows=1 width=8)
Filter: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Seq Scan on metrics_00 metrics_00_16 (cost=0.00..11.38 rows=37 width=8)
Filter: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Seq Scan on metrics_01 metrics_01_16 (cost=0.00..11.38 rows=37 width=8)
Filter: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Seq Scan on metrics_02 metrics_02_16 (cost=0.00..11.38 rows=37 width=8)
Filter: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Seq Scan on metrics_03 metrics_03_16 (cost=0.00..11.38 rows=37 width=8)
Filter: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Seq Scan on metrics_04 metrics_04_16 (cost=0.00..11.38 rows=37 width=8)
Filter: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Seq Scan on metrics_05 metrics_05_16 (cost=0.00..11.38 rows=37 width=8)
Filter: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Index Scan using index_metrics_06_on_ts_and_capture_interval_name on metrics_06 metrics_06_16 (cost=0.39..281.02 rows=1 width=8)
Index Cond: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Index Scan using index_metrics_07_on_ts_and_capture_interval_name on metrics_07 metrics_07_16 (cost=0.39..2286.23 rows=1 width=8)
Index Cond: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Index Scan using index_metrics_08_on_ts_and_capture_interval_name on metrics_08 metrics_08_16 (cost=0.12..8.14 rows=1 width=8)
Index Cond: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Index Scan using index_metrics_09_on_ts_and_capture_interval_name on metrics_09 metrics_09_16 (cost=0.40..222.58 rows=1 width=8)
Index Cond: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Bitmap Heap Scan on metrics_10 metrics_10_16 (cost=1808.68..6977.71 rows=1566 width=8)
Recheck Cond: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Bitmap Index Scan on index_metrics_10_on_ts_and_capture_interval_name (cost=0.00..1808.29 rows=1566 width=0)
Index Cond: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Seq Scan on metrics_11 metrics_11_16 (cost=0.00..245446.61 rows=487284 width=8)
Filter: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Index Scan using index_metrics_12_on_ts_and_capture_interval_name on metrics_12 metrics_12_16 (cost=0.55..284.03 rows=66 width=8)
Index Cond: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Seq Scan on metrics_13 metrics_13_16 (cost=0.00..486237.14 rows=1823609 width=8)
Filter: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Seq Scan on metrics_14 metrics_14_16 (cost=0.00..103778.50 rows=271425 width=8)
Filter: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Seq Scan on metrics_15 metrics_15_16 (cost=0.00..435378.46 rows=1451402 width=8)
Filter: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Seq Scan on metrics_16 metrics_16_16 (cost=0.00..25891.25 rows=1411022 width=8)
Filter: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Bitmap Heap Scan on metrics_17 metrics_17_16 (cost=15380.68..205479.54 rows=87291 width=8)
Recheck Cond: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Bitmap Index Scan on index_metrics_17_on_ts_and_capture_interval_name (cost=0.00..15358.86 rows=87291 width=0)
Index Cond: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Seq Scan on metrics_18 metrics_18_16 (cost=0.00..424833.28 rows=1949687 width=8)
Filter: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Seq Scan on metrics_19 metrics_19_16 (cost=0.00..493598.59 rows=2990170 width=8)
Filter: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Seq Scan on metrics_20 metrics_20_16 (cost=0.00..492859.35 rows=2080476 width=8)
Filter: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Seq Scan on metrics_21 metrics_21_16 (cost=0.00..496204.62 rows=2088911 width=8)
Filter: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Seq Scan on metrics_22 metrics_22_16 (cost=0.00..496263.41 rows=2103562 width=8)
Filter: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Seq Scan on metrics_23 metrics_23_16 (cost=0.00..496299.85 rows=2080085 width=8)
Filter: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Index Scan using metrics_14_pkey on metrics_14 (cost=0.42..8.44 rows=1 width=14)
Index Cond: (id = "ANY_subquery_15".id)
-> Nested Loop (cost=25.11..871.19 rows=100 width=38)
-> HashAggregate (cost=24.69..25.69 rows=100 width=40)
Group Key: "ANY_subquery_16".id
-> Subquery Scan on "ANY_subquery_16" (cost=0.00..24.44 rows=100 width=40)
-> Limit (cost=0.00..23.44 rows=100 width=8)
-> Append (cost=0.00..4412398.56 rows=18826783 width=8)
-> Seq Scan on metrics metrics_31 (cost=0.00..0.00 rows=1 width=8)
Filter: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Seq Scan on metrics_00 metrics_00_17 (cost=0.00..11.38 rows=37 width=8)
Filter: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Seq Scan on metrics_01 metrics_01_17 (cost=0.00..11.38 rows=37 width=8)
Filter: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Seq Scan on metrics_02 metrics_02_17 (cost=0.00..11.38 rows=37 width=8)
Filter: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Seq Scan on metrics_03 metrics_03_17 (cost=0.00..11.38 rows=37 width=8)
Filter: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Seq Scan on metrics_04 metrics_04_17 (cost=0.00..11.38 rows=37 width=8)
Filter: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Seq Scan on metrics_05 metrics_05_17 (cost=0.00..11.38 rows=37 width=8)
Filter: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Index Scan using index_metrics_06_on_ts_and_capture_interval_name on metrics_06 metrics_06_17 (cost=0.39..281.02 rows=1 width=8)
Index Cond: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Index Scan using index_metrics_07_on_ts_and_capture_interval_name on metrics_07 metrics_07_17 (cost=0.39..2286.23 rows=1 width=8)
Index Cond: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Index Scan using index_metrics_08_on_ts_and_capture_interval_name on metrics_08 metrics_08_17 (cost=0.12..8.14 rows=1 width=8)
Index Cond: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Index Scan using index_metrics_09_on_ts_and_capture_interval_name on metrics_09 metrics_09_17 (cost=0.40..222.58 rows=1 width=8)
Index Cond: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Bitmap Heap Scan on metrics_10 metrics_10_17 (cost=1808.68..6977.71 rows=1566 width=8)
Recheck Cond: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Bitmap Index Scan on index_metrics_10_on_ts_and_capture_interval_name (cost=0.00..1808.29 rows=1566 width=0)
Index Cond: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Seq Scan on metrics_11 metrics_11_17 (cost=0.00..245446.61 rows=487284 width=8)
Filter: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Index Scan using index_metrics_12_on_ts_and_capture_interval_name on metrics_12 metrics_12_17 (cost=0.55..284.03 rows=66 width=8)
Index Cond: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Seq Scan on metrics_13 metrics_13_17 (cost=0.00..486237.14 rows=1823609 width=8)
Filter: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Seq Scan on metrics_14 metrics_14_17 (cost=0.00..103778.50 rows=271425 width=8)
Filter: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Seq Scan on metrics_15 metrics_15_17 (cost=0.00..435378.46 rows=1451402 width=8)
Filter: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Seq Scan on metrics_16 metrics_16_17 (cost=0.00..25891.25 rows=1411022 width=8)
Filter: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Bitmap Heap Scan on metrics_17 metrics_17_17 (cost=15380.68..205479.54 rows=87291 width=8)
Recheck Cond: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Bitmap Index Scan on index_metrics_17_on_ts_and_capture_interval_name (cost=0.00..15358.86 rows=87291 width=0)
Index Cond: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Seq Scan on metrics_18 metrics_18_17 (cost=0.00..424833.28 rows=1949687 width=8)
Filter: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Seq Scan on metrics_19 metrics_19_17 (cost=0.00..493598.59 rows=2990170 width=8)
Filter: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Seq Scan on metrics_20 metrics_20_17 (cost=0.00..492859.35 rows=2080476 width=8)
Filter: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Seq Scan on metrics_21 metrics_21_17 (cost=0.00..496204.62 rows=2088911 width=8)
Filter: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Seq Scan on metrics_22 metrics_22_17 (cost=0.00..496263.41 rows=2103562 width=8)
Filter: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Seq Scan on metrics_23 metrics_23_17 (cost=0.00..496299.85 rows=2080085 width=8)
Filter: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Index Scan using metrics_15_pkey on metrics_15 (cost=0.43..8.45 rows=1 width=14)
Index Cond: (id = "ANY_subquery_16".id)
-> Nested Loop (cost=25.11..871.19 rows=100 width=38)
-> HashAggregate (cost=24.69..25.69 rows=100 width=40)
Group Key: "ANY_subquery_17".id
-> Subquery Scan on "ANY_subquery_17" (cost=0.00..24.44 rows=100 width=40)
-> Limit (cost=0.00..23.44 rows=100 width=8)
-> Append (cost=0.00..4412398.56 rows=18826783 width=8)
-> Seq Scan on metrics metrics_32 (cost=0.00..0.00 rows=1 width=8)
Filter: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Seq Scan on metrics_00 metrics_00_18 (cost=0.00..11.38 rows=37 width=8)
Filter: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Seq Scan on metrics_01 metrics_01_18 (cost=0.00..11.38 rows=37 width=8)
Filter: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Seq Scan on metrics_02 metrics_02_18 (cost=0.00..11.38 rows=37 width=8)
Filter: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Seq Scan on metrics_03 metrics_03_18 (cost=0.00..11.38 rows=37 width=8)
Filter: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Seq Scan on metrics_04 metrics_04_18 (cost=0.00..11.38 rows=37 width=8)
Filter: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Seq Scan on metrics_05 metrics_05_18 (cost=0.00..11.38 rows=37 width=8)
Filter: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Index Scan using index_metrics_06_on_ts_and_capture_interval_name on metrics_06 metrics_06_18 (cost=0.39..281.02 rows=1 width=8)
Index Cond: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Index Scan using index_metrics_07_on_ts_and_capture_interval_name on metrics_07 metrics_07_18 (cost=0.39..2286.23 rows=1 width=8)
Index Cond: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Index Scan using index_metrics_08_on_ts_and_capture_interval_name on metrics_08 metrics_08_18 (cost=0.12..8.14 rows=1 width=8)
Index Cond: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Index Scan using index_metrics_09_on_ts_and_capture_interval_name on metrics_09 metrics_09_18 (cost=0.40..222.58 rows=1 width=8)
Index Cond: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Bitmap Heap Scan on metrics_10 metrics_10_18 (cost=1808.68..6977.71 rows=1566 width=8)
Recheck Cond: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Bitmap Index Scan on index_metrics_10_on_ts_and_capture_interval_name (cost=0.00..1808.29 rows=1566 width=0)
Index Cond: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Seq Scan on metrics_11 metrics_11_18 (cost=0.00..245446.61 rows=487284 width=8)
Filter: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Index Scan using index_metrics_12_on_ts_and_capture_interval_name on metrics_12 metrics_12_18 (cost=0.55..284.03 rows=66 width=8)
Index Cond: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Seq Scan on metrics_13 metrics_13_18 (cost=0.00..486237.14 rows=1823609 width=8)
Filter: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Seq Scan on metrics_14 metrics_14_18 (cost=0.00..103778.50 rows=271425 width=8)
Filter: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Seq Scan on metrics_15 metrics_15_18 (cost=0.00..435378.46 rows=1451402 width=8)
Filter: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Seq Scan on metrics_16 metrics_16_18 (cost=0.00..25891.25 rows=1411022 width=8)
Filter: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Bitmap Heap Scan on metrics_17 metrics_17_18 (cost=15380.68..205479.54 rows=87291 width=8)
Recheck Cond: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Bitmap Index Scan on index_metrics_17_on_ts_and_capture_interval_name (cost=0.00..15358.86 rows=87291 width=0)
Index Cond: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Seq Scan on metrics_18 metrics_18_18 (cost=0.00..424833.28 rows=1949687 width=8)
Filter: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Seq Scan on metrics_19 metrics_19_18 (cost=0.00..493598.59 rows=2990170 width=8)
Filter: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Seq Scan on metrics_20 metrics_20_18 (cost=0.00..492859.35 rows=2080476 width=8)
Filter: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Seq Scan on metrics_21 metrics_21_18 (cost=0.00..496204.62 rows=2088911 width=8)
Filter: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Seq Scan on metrics_22 metrics_22_18 (cost=0.00..496263.41 rows=2103562 width=8)
Filter: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Seq Scan on metrics_23 metrics_23_18 (cost=0.00..496299.85 rows=2080085 width=8)
Filter: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Index Scan using metrics_16_pkey on metrics_16 (cost=0.43..8.45 rows=1 width=14)
Index Cond: (id = "ANY_subquery_17".id)
-> Nested Loop (cost=24.86..846.19 rows=100 width=38)
-> HashAggregate (cost=24.69..25.69 rows=100 width=40)
Group Key: "ANY_subquery_18".id
-> Subquery Scan on "ANY_subquery_18" (cost=0.00..24.44 rows=100 width=40)
-> Limit (cost=0.00..23.44 rows=100 width=8)
-> Append (cost=0.00..4412398.56 rows=18826783 width=8)
-> Seq Scan on metrics metrics_33 (cost=0.00..0.00 rows=1 width=8)
Filter: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Seq Scan on metrics_00 metrics_00_19 (cost=0.00..11.38 rows=37 width=8)
Filter: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Seq Scan on metrics_01 metrics_01_19 (cost=0.00..11.38 rows=37 width=8)
Filter: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Seq Scan on metrics_02 metrics_02_19 (cost=0.00..11.38 rows=37 width=8)
Filter: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Seq Scan on metrics_03 metrics_03_19 (cost=0.00..11.38 rows=37 width=8)
Filter: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Seq Scan on metrics_04 metrics_04_19 (cost=0.00..11.38 rows=37 width=8)
Filter: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Seq Scan on metrics_05 metrics_05_19 (cost=0.00..11.38 rows=37 width=8)
Filter: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Index Scan using index_metrics_06_on_ts_and_capture_interval_name on metrics_06 metrics_06_19 (cost=0.39..281.02 rows=1 width=8)
Index Cond: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Index Scan using index_metrics_07_on_ts_and_capture_interval_name on metrics_07 metrics_07_19 (cost=0.39..2286.23 rows=1 width=8)
Index Cond: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Index Scan using index_metrics_08_on_ts_and_capture_interval_name on metrics_08 metrics_08_19 (cost=0.12..8.14 rows=1 width=8)
Index Cond: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Index Scan using index_metrics_09_on_ts_and_capture_interval_name on metrics_09 metrics_09_19 (cost=0.40..222.58 rows=1 width=8)
Index Cond: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Bitmap Heap Scan on metrics_10 metrics_10_19 (cost=1808.68..6977.71 rows=1566 width=8)
Recheck Cond: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Bitmap Index Scan on index_metrics_10_on_ts_and_capture_interval_name (cost=0.00..1808.29 rows=1566 width=0)
Index Cond: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Seq Scan on metrics_11 metrics_11_19 (cost=0.00..245446.61 rows=487284 width=8)
Filter: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Index Scan using index_metrics_12_on_ts_and_capture_interval_name on metrics_12 metrics_12_19 (cost=0.55..284.03 rows=66 width=8)
Index Cond: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Seq Scan on metrics_13 metrics_13_19 (cost=0.00..486237.14 rows=1823609 width=8)
Filter: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Seq Scan on metrics_14 metrics_14_19 (cost=0.00..103778.50 rows=271425 width=8)
Filter: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Seq Scan on metrics_15 metrics_15_19 (cost=0.00..435378.46 rows=1451402 width=8)
Filter: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Seq Scan on metrics_16 metrics_16_19 (cost=0.00..25891.25 rows=1411022 width=8)
Filter: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Bitmap Heap Scan on metrics_17 metrics_17_19 (cost=15380.68..205479.54 rows=87291 width=8)
Recheck Cond: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Bitmap Index Scan on index_metrics_17_on_ts_and_capture_interval_name (cost=0.00..15358.86 rows=87291 width=0)
Index Cond: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Seq Scan on metrics_18 metrics_18_19 (cost=0.00..424833.28 rows=1949687 width=8)
Filter: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Seq Scan on metrics_19 metrics_19_19 (cost=0.00..493598.59 rows=2990170 width=8)
Filter: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Seq Scan on metrics_20 metrics_20_19 (cost=0.00..492859.35 rows=2080476 width=8)
Filter: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Seq Scan on metrics_21 metrics_21_19 (cost=0.00..496204.62 rows=2088911 width=8)
Filter: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Seq Scan on metrics_22 metrics_22_19 (cost=0.00..496263.41 rows=2103562 width=8)
Filter: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Seq Scan on metrics_23 metrics_23_19 (cost=0.00..496299.85 rows=2080085 width=8)
Filter: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Index Scan using metrics_17_pkey on metrics_17 (cost=0.18..8.20 rows=1 width=14)
Index Cond: (id = "ANY_subquery_18".id)
-> Nested Loop (cost=25.12..871.44 rows=100 width=38)
-> HashAggregate (cost=24.69..25.69 rows=100 width=40)
Group Key: "ANY_subquery_19".id
-> Subquery Scan on "ANY_subquery_19" (cost=0.00..24.44 rows=100 width=40)
-> Limit (cost=0.00..23.44 rows=100 width=8)
-> Append (cost=0.00..4412398.56 rows=18826783 width=8)
-> Seq Scan on metrics metrics_34 (cost=0.00..0.00 rows=1 width=8)
Filter: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Seq Scan on metrics_00 metrics_00_20 (cost=0.00..11.38 rows=37 width=8)
Filter: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Seq Scan on metrics_01 metrics_01_20 (cost=0.00..11.38 rows=37 width=8)
Filter: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Seq Scan on metrics_02 metrics_02_20 (cost=0.00..11.38 rows=37 width=8)
Filter: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Seq Scan on metrics_03 metrics_03_20 (cost=0.00..11.38 rows=37 width=8)
Filter: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Seq Scan on metrics_04 metrics_04_20 (cost=0.00..11.38 rows=37 width=8)
Filter: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Seq Scan on metrics_05 metrics_05_20 (cost=0.00..11.38 rows=37 width=8)
Filter: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Index Scan using index_metrics_06_on_ts_and_capture_interval_name on metrics_06 metrics_06_20 (cost=0.39..281.02 rows=1 width=8)
Index Cond: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Index Scan using index_metrics_07_on_ts_and_capture_interval_name on metrics_07 metrics_07_20 (cost=0.39..2286.23 rows=1 width=8)
Index Cond: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Index Scan using index_metrics_08_on_ts_and_capture_interval_name on metrics_08 metrics_08_20 (cost=0.12..8.14 rows=1 width=8)
Index Cond: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Index Scan using index_metrics_09_on_ts_and_capture_interval_name on metrics_09 metrics_09_20 (cost=0.40..222.58 rows=1 width=8)
Index Cond: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Bitmap Heap Scan on metrics_10 metrics_10_20 (cost=1808.68..6977.71 rows=1566 width=8)
Recheck Cond: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Bitmap Index Scan on index_metrics_10_on_ts_and_capture_interval_name (cost=0.00..1808.29 rows=1566 width=0)
Index Cond: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Seq Scan on metrics_11 metrics_11_20 (cost=0.00..245446.61 rows=487284 width=8)
Filter: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Index Scan using index_metrics_12_on_ts_and_capture_interval_name on metrics_12 metrics_12_20 (cost=0.55..284.03 rows=66 width=8)
Index Cond: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Seq Scan on metrics_13 metrics_13_20 (cost=0.00..486237.14 rows=1823609 width=8)
Filter: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Seq Scan on metrics_14 metrics_14_20 (cost=0.00..103778.50 rows=271425 width=8)
Filter: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Seq Scan on metrics_15 metrics_15_20 (cost=0.00..435378.46 rows=1451402 width=8)
Filter: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Seq Scan on metrics_16 metrics_16_20 (cost=0.00..25891.25 rows=1411022 width=8)
Filter: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Bitmap Heap Scan on metrics_17 metrics_17_20 (cost=15380.68..205479.54 rows=87291 width=8)
Recheck Cond: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Bitmap Index Scan on index_metrics_17_on_ts_and_capture_interval_name (cost=0.00..15358.86 rows=87291 width=0)
Index Cond: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Seq Scan on metrics_18 metrics_18_20 (cost=0.00..424833.28 rows=1949687 width=8)
Filter: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Seq Scan on metrics_19 metrics_19_20 (cost=0.00..493598.59 rows=2990170 width=8)
Filter: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Seq Scan on metrics_20 metrics_20_20 (cost=0.00..492859.35 rows=2080476 width=8)
Filter: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Seq Scan on metrics_21 metrics_21_20 (cost=0.00..496204.62 rows=2088911 width=8)
Filter: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Seq Scan on metrics_22 metrics_22_20 (cost=0.00..496263.41 rows=2103562 width=8)
Filter: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Seq Scan on metrics_23 metrics_23_20 (cost=0.00..496299.85 rows=2080085 width=8)
Filter: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Index Scan using metrics_18_pkey on metrics_18 (cost=0.43..8.45 rows=1 width=14)
Index Cond: (id = "ANY_subquery_19".id)
-> Nested Loop (cost=25.12..871.69 rows=100 width=38)
-> HashAggregate (cost=24.69..25.69 rows=100 width=40)
Group Key: "ANY_subquery_20".id
-> Subquery Scan on "ANY_subquery_20" (cost=0.00..24.44 rows=100 width=40)
-> Limit (cost=0.00..23.44 rows=100 width=8)
-> Append (cost=0.00..4412398.56 rows=18826783 width=8)
-> Seq Scan on metrics metrics_35 (cost=0.00..0.00 rows=1 width=8)
Filter: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Seq Scan on metrics_00 metrics_00_21 (cost=0.00..11.38 rows=37 width=8)
Filter: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Seq Scan on metrics_01 metrics_01_21 (cost=0.00..11.38 rows=37 width=8)
Filter: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Seq Scan on metrics_02 metrics_02_21 (cost=0.00..11.38 rows=37 width=8)
Filter: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Seq Scan on metrics_03 metrics_03_21 (cost=0.00..11.38 rows=37 width=8)
Filter: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Seq Scan on metrics_04 metrics_04_21 (cost=0.00..11.38 rows=37 width=8)
Filter: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Seq Scan on metrics_05 metrics_05_21 (cost=0.00..11.38 rows=37 width=8)
Filter: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Index Scan using index_metrics_06_on_ts_and_capture_interval_name on metrics_06 metrics_06_21 (cost=0.39..281.02 rows=1 width=8)
Index Cond: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Index Scan using index_metrics_07_on_ts_and_capture_interval_name on metrics_07 metrics_07_21 (cost=0.39..2286.23 rows=1 width=8)
Index Cond: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Index Scan using index_metrics_08_on_ts_and_capture_interval_name on metrics_08 metrics_08_21 (cost=0.12..8.14 rows=1 width=8)
Index Cond: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Index Scan using index_metrics_09_on_ts_and_capture_interval_name on metrics_09 metrics_09_21 (cost=0.40..222.58 rows=1 width=8)
Index Cond: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Bitmap Heap Scan on metrics_10 metrics_10_21 (cost=1808.68..6977.71 rows=1566 width=8)
Recheck Cond: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Bitmap Index Scan on index_metrics_10_on_ts_and_capture_interval_name (cost=0.00..1808.29 rows=1566 width=0)
Index Cond: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Seq Scan on metrics_11 metrics_11_21 (cost=0.00..245446.61 rows=487284 width=8)
Filter: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Index Scan using index_metrics_12_on_ts_and_capture_interval_name on metrics_12 metrics_12_21 (cost=0.55..284.03 rows=66 width=8)
Index Cond: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Seq Scan on metrics_13 metrics_13_21 (cost=0.00..486237.14 rows=1823609 width=8)
Filter: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Seq Scan on metrics_14 metrics_14_21 (cost=0.00..103778.50 rows=271425 width=8)
Filter: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Seq Scan on metrics_15 metrics_15_21 (cost=0.00..435378.46 rows=1451402 width=8)
Filter: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Seq Scan on metrics_16 metrics_16_21 (cost=0.00..25891.25 rows=1411022 width=8)
Filter: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Bitmap Heap Scan on metrics_17 metrics_17_21 (cost=15380.68..205479.54 rows=87291 width=8)
Recheck Cond: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Bitmap Index Scan on index_metrics_17_on_ts_and_capture_interval_name (cost=0.00..15358.86 rows=87291 width=0)
Index Cond: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Seq Scan on metrics_18 metrics_18_21 (cost=0.00..424833.28 rows=1949687 width=8)
Filter: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Seq Scan on metrics_19 metrics_19_21 (cost=0.00..493598.59 rows=2990170 width=8)
Filter: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Seq Scan on metrics_20 metrics_20_21 (cost=0.00..492859.35 rows=2080476 width=8)
Filter: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Seq Scan on metrics_21 metrics_21_21 (cost=0.00..496204.62 rows=2088911 width=8)
Filter: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Seq Scan on metrics_22 metrics_22_21 (cost=0.00..496263.41 rows=2103562 width=8)
Filter: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Seq Scan on metrics_23 metrics_23_21 (cost=0.00..496299.85 rows=2080085 width=8)
Filter: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Index Scan using metrics_19_pkey on metrics_19 (cost=0.43..8.45 rows=1 width=14)
Index Cond: (id = "ANY_subquery_20".id)
-> Nested Loop (cost=25.12..871.69 rows=100 width=38)
-> HashAggregate (cost=24.69..25.69 rows=100 width=40)
Group Key: "ANY_subquery_21".id
-> Subquery Scan on "ANY_subquery_21" (cost=0.00..24.44 rows=100 width=40)
-> Limit (cost=0.00..23.44 rows=100 width=8)
-> Append (cost=0.00..4412398.56 rows=18826783 width=8)
-> Seq Scan on metrics metrics_36 (cost=0.00..0.00 rows=1 width=8)
Filter: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Seq Scan on metrics_00 metrics_00_22 (cost=0.00..11.38 rows=37 width=8)
Filter: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Seq Scan on metrics_01 metrics_01_22 (cost=0.00..11.38 rows=37 width=8)
Filter: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Seq Scan on metrics_02 metrics_02_22 (cost=0.00..11.38 rows=37 width=8)
Filter: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Seq Scan on metrics_03 metrics_03_22 (cost=0.00..11.38 rows=37 width=8)
Filter: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Seq Scan on metrics_04 metrics_04_22 (cost=0.00..11.38 rows=37 width=8)
Filter: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Seq Scan on metrics_05 metrics_05_22 (cost=0.00..11.38 rows=37 width=8)
Filter: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Index Scan using index_metrics_06_on_ts_and_capture_interval_name on metrics_06 metrics_06_22 (cost=0.39..281.02 rows=1 width=8)
Index Cond: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Index Scan using index_metrics_07_on_ts_and_capture_interval_name on metrics_07 metrics_07_22 (cost=0.39..2286.23 rows=1 width=8)
Index Cond: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Index Scan using index_metrics_08_on_ts_and_capture_interval_name on metrics_08 metrics_08_22 (cost=0.12..8.14 rows=1 width=8)
Index Cond: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Index Scan using index_metrics_09_on_ts_and_capture_interval_name on metrics_09 metrics_09_22 (cost=0.40..222.58 rows=1 width=8)
Index Cond: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Bitmap Heap Scan on metrics_10 metrics_10_22 (cost=1808.68..6977.71 rows=1566 width=8)
Recheck Cond: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Bitmap Index Scan on index_metrics_10_on_ts_and_capture_interval_name (cost=0.00..1808.29 rows=1566 width=0)
Index Cond: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Seq Scan on metrics_11 metrics_11_22 (cost=0.00..245446.61 rows=487284 width=8)
Filter: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Index Scan using index_metrics_12_on_ts_and_capture_interval_name on metrics_12 metrics_12_22 (cost=0.55..284.03 rows=66 width=8)
Index Cond: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Seq Scan on metrics_13 metrics_13_22 (cost=0.00..486237.14 rows=1823609 width=8)
Filter: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Seq Scan on metrics_14 metrics_14_22 (cost=0.00..103778.50 rows=271425 width=8)
Filter: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Seq Scan on metrics_15 metrics_15_22 (cost=0.00..435378.46 rows=1451402 width=8)
Filter: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Seq Scan on metrics_16 metrics_16_22 (cost=0.00..25891.25 rows=1411022 width=8)
Filter: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Bitmap Heap Scan on metrics_17 metrics_17_22 (cost=15380.68..205479.54 rows=87291 width=8)
Recheck Cond: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Bitmap Index Scan on index_metrics_17_on_ts_and_capture_interval_name (cost=0.00..15358.86 rows=87291 width=0)
Index Cond: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Seq Scan on metrics_18 metrics_18_22 (cost=0.00..424833.28 rows=1949687 width=8)
Filter: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Seq Scan on metrics_19 metrics_19_22 (cost=0.00..493598.59 rows=2990170 width=8)
Filter: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Seq Scan on metrics_20 metrics_20_22 (cost=0.00..492859.35 rows=2080476 width=8)
Filter: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Seq Scan on metrics_21 metrics_21_22 (cost=0.00..496204.62 rows=2088911 width=8)
Filter: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Seq Scan on metrics_22 metrics_22_22 (cost=0.00..496263.41 rows=2103562 width=8)
Filter: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Seq Scan on metrics_23 metrics_23_22 (cost=0.00..496299.85 rows=2080085 width=8)
Filter: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Index Scan using metrics_20_pkey on metrics_20 (cost=0.43..8.45 rows=1 width=14)
Index Cond: (id = "ANY_subquery_21".id)
-> Nested Loop (cost=25.12..871.69 rows=100 width=38)
-> HashAggregate (cost=24.69..25.69 rows=100 width=40)
Group Key: "ANY_subquery_22".id
-> Subquery Scan on "ANY_subquery_22" (cost=0.00..24.44 rows=100 width=40)
-> Limit (cost=0.00..23.44 rows=100 width=8)
-> Append (cost=0.00..4412398.56 rows=18826783 width=8)
-> Seq Scan on metrics metrics_37 (cost=0.00..0.00 rows=1 width=8)
Filter: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Seq Scan on metrics_00 metrics_00_23 (cost=0.00..11.38 rows=37 width=8)
Filter: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Seq Scan on metrics_01 metrics_01_23 (cost=0.00..11.38 rows=37 width=8)
Filter: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Seq Scan on metrics_02 metrics_02_23 (cost=0.00..11.38 rows=37 width=8)
Filter: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Seq Scan on metrics_03 metrics_03_23 (cost=0.00..11.38 rows=37 width=8)
Filter: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Seq Scan on metrics_04 metrics_04_23 (cost=0.00..11.38 rows=37 width=8)
Filter: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Seq Scan on metrics_05 metrics_05_23 (cost=0.00..11.38 rows=37 width=8)
Filter: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Index Scan using index_metrics_06_on_ts_and_capture_interval_name on metrics_06 metrics_06_23 (cost=0.39..281.02 rows=1 width=8)
Index Cond: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Index Scan using index_metrics_07_on_ts_and_capture_interval_name on metrics_07 metrics_07_23 (cost=0.39..2286.23 rows=1 width=8)
Index Cond: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Index Scan using index_metrics_08_on_ts_and_capture_interval_name on metrics_08 metrics_08_23 (cost=0.12..8.14 rows=1 width=8)
Index Cond: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Index Scan using index_metrics_09_on_ts_and_capture_interval_name on metrics_09 metrics_09_23 (cost=0.40..222.58 rows=1 width=8)
Index Cond: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Bitmap Heap Scan on metrics_10 metrics_10_23 (cost=1808.68..6977.71 rows=1566 width=8)
Recheck Cond: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Bitmap Index Scan on index_metrics_10_on_ts_and_capture_interval_name (cost=0.00..1808.29 rows=1566 width=0)
Index Cond: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Seq Scan on metrics_11 metrics_11_23 (cost=0.00..245446.61 rows=487284 width=8)
Filter: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Index Scan using index_metrics_12_on_ts_and_capture_interval_name on metrics_12 metrics_12_23 (cost=0.55..284.03 rows=66 width=8)
Index Cond: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Seq Scan on metrics_13 metrics_13_23 (cost=0.00..486237.14 rows=1823609 width=8)
Filter: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Seq Scan on metrics_14 metrics_14_23 (cost=0.00..103778.50 rows=271425 width=8)
Filter: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Seq Scan on metrics_15 metrics_15_23 (cost=0.00..435378.46 rows=1451402 width=8)
Filter: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Seq Scan on metrics_16 metrics_16_23 (cost=0.00..25891.25 rows=1411022 width=8)
Filter: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Bitmap Heap Scan on metrics_17 metrics_17_23 (cost=15380.68..205479.54 rows=87291 width=8)
Recheck Cond: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Bitmap Index Scan on index_metrics_17_on_ts_and_capture_interval_name (cost=0.00..15358.86 rows=87291 width=0)
Index Cond: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Seq Scan on metrics_18 metrics_18_23 (cost=0.00..424833.28 rows=1949687 width=8)
Filter: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Seq Scan on metrics_19 metrics_19_23 (cost=0.00..493598.59 rows=2990170 width=8)
Filter: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Seq Scan on metrics_20 metrics_20_23 (cost=0.00..492859.35 rows=2080476 width=8)
Filter: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Seq Scan on metrics_21 metrics_21_23 (cost=0.00..496204.62 rows=2088911 width=8)
Filter: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Seq Scan on metrics_22 metrics_22_23 (cost=0.00..496263.41 rows=2103562 width=8)
Filter: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Seq Scan on metrics_23 metrics_23_23 (cost=0.00..496299.85 rows=2080085 width=8)
Filter: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Index Scan using metrics_21_pkey on metrics_21 (cost=0.43..8.45 rows=1 width=14)
Index Cond: (id = "ANY_subquery_22".id)
-> Nested Loop (cost=25.12..871.69 rows=100 width=38)
-> HashAggregate (cost=24.69..25.69 rows=100 width=40)
Group Key: "ANY_subquery_23".id
-> Subquery Scan on "ANY_subquery_23" (cost=0.00..24.44 rows=100 width=40)
-> Limit (cost=0.00..23.44 rows=100 width=8)
-> Append (cost=0.00..4412398.56 rows=18826783 width=8)
-> Seq Scan on metrics metrics_38 (cost=0.00..0.00 rows=1 width=8)
Filter: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Seq Scan on metrics_00 metrics_00_24 (cost=0.00..11.38 rows=37 width=8)
Filter: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Seq Scan on metrics_01 metrics_01_24 (cost=0.00..11.38 rows=37 width=8)
Filter: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Seq Scan on metrics_02 metrics_02_24 (cost=0.00..11.38 rows=37 width=8)
Filter: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Seq Scan on metrics_03 metrics_03_24 (cost=0.00..11.38 rows=37 width=8)
Filter: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Seq Scan on metrics_04 metrics_04_24 (cost=0.00..11.38 rows=37 width=8)
Filter: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Seq Scan on metrics_05 metrics_05_24 (cost=0.00..11.38 rows=37 width=8)
Filter: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Index Scan using index_metrics_06_on_ts_and_capture_interval_name on metrics_06 metrics_06_24 (cost=0.39..281.02 rows=1 width=8)
Index Cond: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Index Scan using index_metrics_07_on_ts_and_capture_interval_name on metrics_07 metrics_07_24 (cost=0.39..2286.23 rows=1 width=8)
Index Cond: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Index Scan using index_metrics_08_on_ts_and_capture_interval_name on metrics_08 metrics_08_24 (cost=0.12..8.14 rows=1 width=8)
Index Cond: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Index Scan using index_metrics_09_on_ts_and_capture_interval_name on metrics_09 metrics_09_24 (cost=0.40..222.58 rows=1 width=8)
Index Cond: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Bitmap Heap Scan on metrics_10 metrics_10_24 (cost=1808.68..6977.71 rows=1566 width=8)
Recheck Cond: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Bitmap Index Scan on index_metrics_10_on_ts_and_capture_interval_name (cost=0.00..1808.29 rows=1566 width=0)
Index Cond: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Seq Scan on metrics_11 metrics_11_24 (cost=0.00..245446.61 rows=487284 width=8)
Filter: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Index Scan using index_metrics_12_on_ts_and_capture_interval_name on metrics_12 metrics_12_24 (cost=0.55..284.03 rows=66 width=8)
Index Cond: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Seq Scan on metrics_13 metrics_13_24 (cost=0.00..486237.14 rows=1823609 width=8)
Filter: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Seq Scan on metrics_14 metrics_14_24 (cost=0.00..103778.50 rows=271425 width=8)
Filter: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Seq Scan on metrics_15 metrics_15_24 (cost=0.00..435378.46 rows=1451402 width=8)
Filter: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Seq Scan on metrics_16 metrics_16_24 (cost=0.00..25891.25 rows=1411022 width=8)
Filter: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Bitmap Heap Scan on metrics_17 metrics_17_24 (cost=15380.68..205479.54 rows=87291 width=8)
Recheck Cond: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Bitmap Index Scan on index_metrics_17_on_ts_and_capture_interval_name (cost=0.00..15358.86 rows=87291 width=0)
Index Cond: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Seq Scan on metrics_18 metrics_18_24 (cost=0.00..424833.28 rows=1949687 width=8)
Filter: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Seq Scan on metrics_19 metrics_19_24 (cost=0.00..493598.59 rows=2990170 width=8)
Filter: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Seq Scan on metrics_20 metrics_20_24 (cost=0.00..492859.35 rows=2080476 width=8)
Filter: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Seq Scan on metrics_21 metrics_21_24 (cost=0.00..496204.62 rows=2088911 width=8)
Filter: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Seq Scan on metrics_22 metrics_22_24 (cost=0.00..496263.41 rows=2103562 width=8)
Filter: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Seq Scan on metrics_23 metrics_23_24 (cost=0.00..496299.85 rows=2080085 width=8)
Filter: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Index Scan using metrics_22_pkey on metrics_22 (cost=0.43..8.45 rows=1 width=14)
Index Cond: (id = "ANY_subquery_23".id)
-> Nested Loop (cost=25.12..871.69 rows=100 width=38)
-> HashAggregate (cost=24.69..25.69 rows=100 width=40)
Group Key: "ANY_subquery_24".id
-> Subquery Scan on "ANY_subquery_24" (cost=0.00..24.44 rows=100 width=40)
-> Limit (cost=0.00..23.44 rows=100 width=8)
-> Append (cost=0.00..4412398.56 rows=18826783 width=8)
-> Seq Scan on metrics metrics_39 (cost=0.00..0.00 rows=1 width=8)
Filter: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Seq Scan on metrics_00 metrics_00_25 (cost=0.00..11.38 rows=37 width=8)
Filter: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Seq Scan on metrics_01 metrics_01_25 (cost=0.00..11.38 rows=37 width=8)
Filter: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Seq Scan on metrics_02 metrics_02_25 (cost=0.00..11.38 rows=37 width=8)
Filter: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Seq Scan on metrics_03 metrics_03_25 (cost=0.00..11.38 rows=37 width=8)
Filter: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Seq Scan on metrics_04 metrics_04_25 (cost=0.00..11.38 rows=37 width=8)
Filter: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Seq Scan on metrics_05 metrics_05_25 (cost=0.00..11.38 rows=37 width=8)
Filter: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Index Scan using index_metrics_06_on_ts_and_capture_interval_name on metrics_06 metrics_06_25 (cost=0.39..281.02 rows=1 width=8)
Index Cond: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Index Scan using index_metrics_07_on_ts_and_capture_interval_name on metrics_07 metrics_07_25 (cost=0.39..2286.23 rows=1 width=8)
Index Cond: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Index Scan using index_metrics_08_on_ts_and_capture_interval_name on metrics_08 metrics_08_25 (cost=0.12..8.14 rows=1 width=8)
Index Cond: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Index Scan using index_metrics_09_on_ts_and_capture_interval_name on metrics_09 metrics_09_25 (cost=0.40..222.58 rows=1 width=8)
Index Cond: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Bitmap Heap Scan on metrics_10 metrics_10_25 (cost=1808.68..6977.71 rows=1566 width=8)
Recheck Cond: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Bitmap Index Scan on index_metrics_10_on_ts_and_capture_interval_name (cost=0.00..1808.29 rows=1566 width=0)
Index Cond: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Seq Scan on metrics_11 metrics_11_25 (cost=0.00..245446.61 rows=487284 width=8)
Filter: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Index Scan using index_metrics_12_on_ts_and_capture_interval_name on metrics_12 metrics_12_25 (cost=0.55..284.03 rows=66 width=8)
Index Cond: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Seq Scan on metrics_13 metrics_13_25 (cost=0.00..486237.14 rows=1823609 width=8)
Filter: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Seq Scan on metrics_14 metrics_14_25 (cost=0.00..103778.50 rows=271425 width=8)
Filter: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Seq Scan on metrics_15 metrics_15_25 (cost=0.00..435378.46 rows=1451402 width=8)
Filter: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Seq Scan on metrics_16 metrics_16_25 (cost=0.00..25891.25 rows=1411022 width=8)
Filter: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Bitmap Heap Scan on metrics_17 metrics_17_25 (cost=15380.68..205479.54 rows=87291 width=8)
Recheck Cond: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Bitmap Index Scan on index_metrics_17_on_ts_and_capture_interval_name (cost=0.00..15358.86 rows=87291 width=0)
Index Cond: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Seq Scan on metrics_18 metrics_18_25 (cost=0.00..424833.28 rows=1949687 width=8)
Filter: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Seq Scan on metrics_19 metrics_19_25 (cost=0.00..493598.59 rows=2990170 width=8)
Filter: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Seq Scan on metrics_20 metrics_20_25 (cost=0.00..492859.35 rows=2080476 width=8)
Filter: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Seq Scan on metrics_21 metrics_21_25 (cost=0.00..496204.62 rows=2088911 width=8)
Filter: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Seq Scan on metrics_22 metrics_22_25 (cost=0.00..496263.41 rows=2103562 width=8)
Filter: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Seq Scan on metrics_23 metrics_23_25 (cost=0.00..496299.85 rows=2080085 width=8)
Filter: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Index Scan using metrics_23_pkey on metrics_23 (cost=0.43..8.45 rows=1 width=14)
Index Cond: (id = "ANY_subquery_24".id)
(1577 rows)
explain DELETE FROM "metrics_21"
WHERE "metrics_21"."id" IN (
SELECT "metrics_21"."id"
FROM "metrics_21"
WHERE ("metrics_21"."timestamp" <= '2018-02-01 19:56:37.519979')
LIMIT 100
);
QUERY PLAN
--------------------------------------------------------------------------------------------------------------------
Delete on metrics_21 (cost=25.44..872.00 rows=100 width=38)
-> Nested Loop (cost=25.44..872.00 rows=100 width=38)
-> HashAggregate (cost=25.00..26.00 rows=100 width=40)
Group Key: "ANY_subquery".id
-> Subquery Scan on "ANY_subquery" (cost=0.00..24.75 rows=100 width=40)
-> Limit (cost=0.00..23.75 rows=100 width=8)
-> Seq Scan on metrics_21 metrics_21_1 (cost=0.00..496204.62 rows=2088911 width=8)
Filter: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Index Scan using metrics_21_pkey on metrics_21 (cost=0.43..8.45 rows=1 width=14)
Index Cond: (id = "ANY_subquery".id)
explain DELETE FROM "metrics_21"
WHERE "metrics_21"."id" = any(array(
SELECT "metrics_21"."id"
FROM "metrics_21"
WHERE ("metrics_21"."timestamp" <= '2018-02-01 19:56:37.519979')
LIMIT 100
));
QUERY PLAN
----------------------------------------------------------------------------------------------------
Delete on metrics_21 (cost=24.19..72.35 rows=10 width=6)
InitPlan 1 (returns $0)
-> Limit (cost=0.00..23.75 rows=100 width=8)
-> Seq Scan on metrics_21 metrics_21_1 (cost=0.00..496204.62 rows=2088911 width=8)
Filter: ("timestamp" <= '2018-02-01 19:56:37.519979'::timestamp without time zone)
-> Index Scan using metrics_21_pkey on metrics_21 (cost=0.43..48.59 rows=10 width=6)
Index Cond: (id = ANY ($0))
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
You can’t perform that action at this time.