-
-
Save kbrock/171a4aff5b8c8d76cf947cf448473612 to your computer and use it in GitHub Desktop.
explain deleting from metrics
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
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) |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
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) |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
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