explain.depesz.com

PostgreSQL's explain analyze made readable

Result: GO5N

Settings
# exclusive inclusive rows x rows loops node
1. 0.154 6,348.259 ↓ 37.0 148 1

Sort (cost=225,353.84..225,353.86 rows=4 width=48) (actual time=6,348.204..6,348.259 rows=148 loops=1)

  • Sort Key: (time_bucket_gapfill('00:10:00'::interval, _qw."time"))
  • Sort Method: quicksort Memory: 45kB
2.          

CTE q_patch_details

3. 20.709 454.629 ↓ 60.9 8,216 1

Nested Loop (cost=100,743.66..103,955.38 rows=135 width=116) (actual time=336.705..454.629 rows=8,216 loops=1)

4. 14.671 356.370 ↓ 293.8 12,925 1

GroupAggregate (cost=100,743.24..100,744.67 rows=44 width=108) (actual time=335.907..356.370 rows=12,925 loops=1)

  • Group Key: ((l_1.labels ->> 'cms_id'::text)), ((l_1.labels ->> 'zone'::text)), ((l_1.labels ->> 'patch_id'::text))
5. 39.718 341.699 ↓ 293.8 12,925 1

Sort (cost=100,743.24..100,743.35 rows=44 width=108) (actual time=335.898..341.699 rows=12,925 loops=1)

  • Sort Key: ((l_1.labels ->> 'cms_id'::text)), ((l_1.labels ->> 'zone'::text)), ((l_1.labels ->> 'patch_id'::text))
  • Sort Method: quicksort Memory: 2202kB
6. 30.782 301.981 ↓ 293.8 12,925 1

Hash Join (cost=100,344.40..100,742.04 rows=44 width=108) (actual time=63.284..301.981 rows=12,925 loops=1)

  • Hash Cond: ((l_1.labels ->> 'cms_id'::text) = _q.cms_id)
7. 210.977 260.210 ↓ 440.3 38,304 1

Bitmap Heap Scan on metrics_labels l_1 (cost=330.53..727.60 rows=87 width=224) (actual time=51.289..260.210 rows=38,304 loops=1)

  • Recheck Cond: (labels @> '{"public": "true"}'::jsonb)
  • Rows Removed by Index Recheck: 135539
  • Filter: ((NOT (labels @> '{"patch_id": ""}'::jsonb)) AND (metric_name = 'gfn_gamepipeline_metrics'::text) AND ((labels ->> 'patch_id'::text) <> ALL ('{43cfed9e-769d-11e9-87dd-0cc47a95867e,d13a6d36-7bcc-11e9-892f-0cc47a95867e}'::text[])))
  • Rows Removed by Filter: 188030
  • Heap Blocks: exact=12998
8. 49.233 49.233 ↓ 1,002.4 361,873 1

Bitmap Index Scan on metrics_labels_labels_idx (cost=0.00..330.51 rows=361 width=0) (actual time=49.233..49.233 rows=361,873 loops=1)

  • Index Cond: (labels @> '{"public": "true"}'::jsonb)
9. 0.055 10.989 ↑ 1.0 100 1

Hash (cost=100,012.62..100,012.62 rows=100 width=32) (actual time=10.988..10.989 rows=100 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 13kB
10. 0.078 10.934 ↑ 1.0 100 1

Subquery Scan on _q (cost=100,011.37..100,012.62 rows=100 width=32) (actual time=10.736..10.934 rows=100 loops=1)

11. 0.092 10.856 ↑ 1.0 100 1

Limit (cost=100,011.37..100,011.62 rows=100 width=48) (actual time=10.734..10.856 rows=100 loops=1)

12. 0.129 10.764 ↑ 1.8 121 1

Sort (cost=100,011.31..100,011.85 rows=214 width=48) (actual time=10.717..10.764 rows=121 loops=1)

  • Sort Key: (sum(m_62.value)) DESC
  • Sort Method: quicksort Memory: 34kB
13. 0.439 10.635 ↑ 1.7 123 1

GroupAggregate (cost=99,974.64..100,003.03 rows=214 width=48) (actual time=9.913..10.635 rows=123 loops=1)

  • Group Key: ((l_2.labels ->> 'cms_id'::text))
14. 1.182 10.196 ↑ 4.3 800 1

Sort (cost=99,974.64..99,983.21 rows=3,429 width=40) (actual time=9.901..10.196 rows=800 loops=1)

  • Sort Key: ((l_2.labels ->> 'cms_id'::text))
  • Sort Method: quicksort Memory: 86kB
15. 1.903 9.014 ↑ 4.3 800 1

Nested Loop (cost=0.99..99,773.29 rows=3,429 width=40) (actual time=0.135..9.014 rows=800 loops=1)

16. 0.321 0.321 ↑ 1.1 194 1

Index Scan using metrics_labels_metric_name_idx on metrics_labels l_2 (cost=0.55..239.44 rows=214 width=64) (actual time=0.027..0.321 rows=194 loops=1)

  • Index Cond: (metric_name = 'playtime_24hrs_duration_hours'::text)
17. 1.746 6.790 ↑ 66.8 4 194

Custom Scan (ChunkAppend) on metrics_values m_62 (cost=0.44..462.40 rows=267 width=12) (actual time=0.015..0.035 rows=4 loops=194)

  • Chunks excluded during startup: 111
18. 0.582 0.582 ↑ 6.0 1 194

Index Scan using _hyper_48_2967_chunk_metrics_values_labels_id_idx on _hyper_48_2967_chunk m_63 (cost=0.44..8.01 rows=6 width=12) (actual time=0.003..0.003 rows=1 loops=194)

  • Index Cond: ((labels_id = l_2.id) AND ("time" >= (date_trunc('minutes'::text, '2019-11-07 19:01:50.678+00'::timestamp with time zone) - '168:00:00'::interval)) AND ("time" <= (date_trunc('minutes'::text, '2019-11-08 01:01:50.678+00'::timestamp with time zone) + '00:01:00'::interval)))
19. 0.582 0.582 ↑ 19.0 1 194

Index Scan using _hyper_48_2985_chunk_metrics_values_labels_id_idx on _hyper_48_2985_chunk m_64 (cost=0.44..20.28 rows=19 width=12) (actual time=0.003..0.003 rows=1 loops=194)

  • Index Cond: ((labels_id = l_2.id) AND ("time" >= (date_trunc('minutes'::text, '2019-11-07 19:01:50.678+00'::timestamp with time zone) - '168:00:00'::interval)) AND ("time" <= (date_trunc('minutes'::text, '2019-11-08 01:01:50.678+00'::timestamp with time zone) + '00:01:00'::interval)))
20. 0.582 0.582 ↑ 23.0 1 194

Index Scan using _hyper_48_3003_chunk_metrics_values_labels_id_idx on _hyper_48_3003_chunk m_65 (cost=0.44..24.44 rows=23 width=12) (actual time=0.003..0.003 rows=1 loops=194)

  • Index Cond: ((labels_id = l_2.id) AND ("time" >= (date_trunc('minutes'::text, '2019-11-07 19:01:50.678+00'::timestamp with time zone) - '168:00:00'::interval)) AND ("time" <= (date_trunc('minutes'::text, '2019-11-08 01:01:50.678+00'::timestamp with time zone) + '00:01:00'::interval)))
21. 0.582 0.582 ↑ 24.0 1 194

Index Scan using _hyper_48_3021_chunk_metrics_values_labels_id_idx on _hyper_48_3021_chunk m_66 (cost=0.44..25.30 rows=24 width=12) (actual time=0.003..0.003 rows=1 loops=194)

  • Index Cond: ((labels_id = l_2.id) AND ("time" >= (date_trunc('minutes'::text, '2019-11-07 19:01:50.678+00'::timestamp with time zone) - '168:00:00'::interval)) AND ("time" <= (date_trunc('minutes'::text, '2019-11-08 01:01:50.678+00'::timestamp with time zone) + '00:01:00'::interval)))
22. 0.582 0.582 ↑ 20.0 1 194

Index Scan using _hyper_48_3040_chunk_metrics_values_labels_id_idx on _hyper_48_3040_chunk m_67 (cost=0.44..21.10 rows=20 width=12) (actual time=0.003..0.003 rows=1 loops=194)

  • Index Cond: ((labels_id = l_2.id) AND ("time" >= (date_trunc('minutes'::text, '2019-11-07 19:01:50.678+00'::timestamp with time zone) - '168:00:00'::interval)) AND ("time" <= (date_trunc('minutes'::text, '2019-11-08 01:01:50.678+00'::timestamp with time zone) + '00:01:00'::interval)))
23. 0.582 0.582 ↑ 21.0 1 194

Index Scan using _hyper_48_3060_chunk_metrics_values_labels_id_idx on _hyper_48_3060_chunk m_68 (cost=0.44..22.05 rows=21 width=12) (actual time=0.003..0.003 rows=1 loops=194)

  • Index Cond: ((labels_id = l_2.id) AND ("time" >= (date_trunc('minutes'::text, '2019-11-07 19:01:50.678+00'::timestamp with time zone) - '168:00:00'::interval)) AND ("time" <= (date_trunc('minutes'::text, '2019-11-08 01:01:50.678+00'::timestamp with time zone) + '00:01:00'::interval)))
24. 0.582 0.582 ↑ 20.0 1 194

Index Scan using _hyper_48_3078_chunk_metrics_values_labels_id_idx on _hyper_48_3078_chunk m_69 (cost=0.44..21.14 rows=20 width=12) (actual time=0.003..0.003 rows=1 loops=194)

  • Index Cond: ((labels_id = l_2.id) AND ("time" >= (date_trunc('minutes'::text, '2019-11-07 19:01:50.678+00'::timestamp with time zone) - '168:00:00'::interval)) AND ("time" <= (date_trunc('minutes'::text, '2019-11-08 01:01:50.678+00'::timestamp with time zone) + '00:01:00'::interval)))
25. 0.582 0.582 ↑ 21.0 1 194

Index Scan using _hyper_48_3095_chunk_metrics_values_labels_id_idx on _hyper_48_3095_chunk m_70 (cost=0.44..21.95 rows=21 width=12) (actual time=0.003..0.003 rows=1 loops=194)

  • Index Cond: ((labels_id = l_2.id) AND ("time" >= (date_trunc('minutes'::text, '2019-11-07 19:01:50.678+00'::timestamp with time zone) - '168:00:00'::interval)) AND ("time" <= (date_trunc('minutes'::text, '2019-11-08 01:01:50.678+00'::timestamp with time zone) + '00:01:00'::interval)))
26. 0.388 0.388 ↓ 0.0 0 194

Index Scan using _hyper_48_3112_chunk_metrics_values_labels_id_idx on _hyper_48_3112_chunk m_71 (cost=0.43..2.95 rows=2 width=12) (actual time=0.002..0.002 rows=0 loops=194)

  • Index Cond: ((labels_id = l_2.id) AND ("time" >= (date_trunc('minutes'::text, '2019-11-07 19:01:50.678+00'::timestamp with time zone) - '168:00:00'::interval)) AND ("time" <= (date_trunc('minutes'::text, '2019-11-08 01:01:50.678+00'::timestamp with time zone) + '00:01:00'::interval)))
27. 12.925 77.550 ↑ 22.0 1 12,925

Append (cost=0.42..72.74 rows=22 width=12) (actual time=0.005..0.006 rows=1 loops=12,925)

28. 25.850 25.850 ↓ 0.0 0 12,925

Index Scan using _hyper_14_3109_chunk_metrics_values_labels_id_idx on _hyper_14_3109_chunk _mv (cost=0.42..21.76 rows=9 width=12) (actual time=0.002..0.002 rows=0 loops=12,925)

  • Index Cond: ((labels_id = (min(l_1.id))) AND ("time" >= '2019-11-07 19:01:50.678+00'::timestamp with time zone) AND ("time" <= '2019-11-08 01:01:50.678+00'::timestamp with time zone))
  • Filter: (value = '2'::double precision)
29. 38.775 38.775 ↑ 13.0 1 12,925

Index Scan using _hyper_14_3092_chunk_metrics_values_labels_id_idx on _hyper_14_3092_chunk _mv_1 (cost=0.43..50.98 rows=13 width=12) (actual time=0.002..0.003 rows=1 loops=12,925)

  • Index Cond: ((labels_id = (min(l_1.id))) AND ("time" >= '2019-11-07 19:01:50.678+00'::timestamp with time zone) AND ("time" <= '2019-11-08 01:01:50.678+00'::timestamp with time zone))
  • Filter: (value = '2'::double precision)
30. 0.078 6,348.105 ↓ 37.0 148 1

Custom Scan (GapFill) (cost=121,398.41..121,398.42 rows=4 width=0) (actual time=6,348.018..6,348.105 rows=148 loops=1)

31. 0.055 6,348.027 ↓ 7.8 31 1

Sort (cost=121,398.41..121,398.42 rows=4 width=0) (actual time=6,348.014..6,348.027 rows=31 loops=1)

  • Sort Key: _qw.name, (time_bucket_gapfill('00:10:00'::interval, _qw."time"))
  • Sort Method: quicksort Memory: 29kB
32. 1.085 6,347.972 ↓ 7.8 31 1

GroupAggregate (cost=121,398.28..121,398.37 rows=4 width=0) (actual time=6,346.146..6,347.972 rows=31 loops=1)

  • Group Key: (time_bucket_gapfill('00:10:00'::interval, _qw."time")), _qw.name
33. 2.239 6,346.887 ↓ 542.8 2,171 1

Sort (cost=121,398.28..121,398.29 rows=4 width=48) (actual time=6,346.078..6,346.887 rows=2,171 loops=1)

  • Sort Key: (time_bucket_gapfill('00:10:00'::interval, _qw."time")), _qw.name
  • Sort Method: quicksort Memory: 402kB
34. 1.801 6,344.648 ↓ 542.8 2,171 1

Subquery Scan on _qw (cost=121,398.18..121,398.24 rows=4 width=48) (actual time=6,341.964..6,344.648 rows=2,171 loops=1)

35. 3.607 6,342.847 ↓ 542.8 2,171 1

Sort (cost=121,398.18..121,398.19 rows=4 width=48) (actual time=6,341.960..6,342.847 rows=2,171 loops=1)

  • Sort Key: q."time", (COALESCE(date_part('epoch'::text, (q."time" - (min(q.start_time)))), '0'::double precision))
  • Sort Method: quicksort Memory: 402kB
36. 9.231 6,339.240 ↓ 542.8 2,171 1

Nested Loop (cost=22,942.41..121,398.14 rows=4 width=48) (actual time=564.665..6,339.240 rows=2,171 loops=1)

37. 1,043.052 6,319.154 ↓ 542.8 2,171 1

Hash Join (cost=22,942.13..121,395.83 rows=4 width=80) (actual time=564.631..6,319.154 rows=2,171 loops=1)

  • Hash Cond: ((m.labels_id = l.id) AND (q.patch_id = (l.labels ->> 'patch_id'::text)))
38. 1,209.001 5,186.603 ↓ 11.7 1,549,678 1

Nested Loop (cost=4.82..92,776.19 rows=132,525 width=84) (actual time=472.180..5,186.603 rows=1,549,678 loops=1)

39. 19.819 483.559 ↓ 58.7 7,923 1

HashAggregate (cost=4.39..5.74 rows=135 width=80) (actual time=471.512..483.559 rows=7,923 loops=1)

  • Group Key: q."time", q.cms_id, q.patch_id
  • Filter: (COALESCE(date_part('epoch'::text, (q."time" - min(q.start_time))), '0'::double precision) > '0'::double precision)
  • Rows Removed by Filter: 17
40. 463.740 463.740 ↓ 60.9 8,216 1

CTE Scan on q_patch_details q (cost=0.00..2.70 rows=135 width=80) (actual time=336.709..463.740 rows=8,216 loops=1)

41. 1,568.754 3,494.043 ↑ 72.6 196 7,923

Append (cost=0.43..544.95 rows=14,223 width=12) (actual time=0.188..0.441 rows=196 loops=7,923)

42. 15.846 15.846 ↓ 0.0 0 7,923

Index Scan using _hyper_14_1915_chunk_metrics_values_time_idx on _hyper_14_1915_chunk m (cost=0.43..5.42 rows=136 width=12) (actual time=0.002..0.002 rows=0 loops=7,923)

  • Index Cond: ("time" = q."time")
43. 15.846 15.846 ↓ 0.0 0 7,923

Index Scan using _hyper_14_1929_chunk_metrics_values_time_idx on _hyper_14_1929_chunk m_1 (cost=0.43..5.56 rows=142 width=12) (actual time=0.002..0.002 rows=0 loops=7,923)

  • Index Cond: ("time" = q."time")
44. 15.846 15.846 ↓ 0.0 0 7,923

Index Scan using _hyper_14_1945_chunk_metrics_values_time_idx on _hyper_14_1945_chunk m_2 (cost=0.43..5.54 rows=145 width=12) (actual time=0.002..0.002 rows=0 loops=7,923)

  • Index Cond: ("time" = q."time")
45. 15.846 15.846 ↓ 0.0 0 7,923

Index Scan using _hyper_14_1960_chunk_metrics_values_time_idx on _hyper_14_1960_chunk m_3 (cost=0.43..6.87 rows=157 width=12) (actual time=0.002..0.002 rows=0 loops=7,923)

  • Index Cond: ("time" = q."time")
46. 15.846 15.846 ↓ 0.0 0 7,923

Index Scan using _hyper_14_1974_chunk_metrics_values_time_idx on _hyper_14_1974_chunk m_4 (cost=0.43..6.87 rows=160 width=12) (actual time=0.002..0.002 rows=0 loops=7,923)

  • Index Cond: ("time" = q."time")
47. 23.769 23.769 ↓ 0.0 0 7,923

Index Scan using _hyper_14_1989_chunk_metrics_values_time_idx on _hyper_14_1989_chunk m_5 (cost=0.43..7.15 rows=175 width=12) (actual time=0.003..0.003 rows=0 loops=7,923)

  • Index Cond: ("time" = q."time")
48. 15.846 15.846 ↓ 0.0 0 7,923

Index Scan using _hyper_14_2006_chunk_metrics_values_time_idx on _hyper_14_2006_chunk m_6 (cost=0.43..7.00 rows=162 width=12) (actual time=0.002..0.002 rows=0 loops=7,923)

  • Index Cond: ("time" = q."time")
49. 15.846 15.846 ↓ 0.0 0 7,923

Index Scan using _hyper_14_2021_chunk_metrics_values_time_idx on _hyper_14_2021_chunk m_7 (cost=0.43..7.03 rows=163 width=12) (actual time=0.002..0.002 rows=0 loops=7,923)

  • Index Cond: ("time" = q."time")
50. 15.846 15.846 ↓ 0.0 0 7,923

Index Scan using _hyper_14_2035_chunk_metrics_values_time_idx on _hyper_14_2035_chunk m_8 (cost=0.43..6.99 rows=160 width=12) (actual time=0.002..0.002 rows=0 loops=7,923)

  • Index Cond: ("time" = q."time")
51. 15.846 15.846 ↓ 0.0 0 7,923

Index Scan using _hyper_14_2049_chunk_metrics_values_time_idx on _hyper_14_2049_chunk m_9 (cost=0.43..6.85 rows=167 width=12) (actual time=0.002..0.002 rows=0 loops=7,923)

  • Index Cond: ("time" = q."time")
52. 15.846 15.846 ↓ 0.0 0 7,923

Index Scan using _hyper_14_2080_chunk_metrics_values_time_idx on _hyper_14_2080_chunk m_10 (cost=0.43..6.83 rows=166 width=12) (actual time=0.002..0.002 rows=0 loops=7,923)

  • Index Cond: ("time" = q."time")
53. 15.846 15.846 ↓ 0.0 0 7,923

Index Scan using _hyper_14_2097_chunk_metrics_values_time_idx on _hyper_14_2097_chunk m_11 (cost=0.43..6.93 rows=174 width=12) (actual time=0.002..0.002 rows=0 loops=7,923)

  • Index Cond: ("time" = q."time")
54. 15.846 15.846 ↓ 0.0 0 7,923

Index Scan using _hyper_14_2112_chunk_metrics_values_time_idx on _hyper_14_2112_chunk m_12 (cost=0.43..8.85 rows=219 width=12) (actual time=0.002..0.002 rows=0 loops=7,923)

  • Index Cond: ("time" = q."time")
55. 15.846 15.846 ↓ 0.0 0 7,923

Index Scan using _hyper_14_2131_chunk_metrics_values_time_idx on _hyper_14_2131_chunk m_13 (cost=0.43..9.23 rows=236 width=12) (actual time=0.002..0.002 rows=0 loops=7,923)

  • Index Cond: ("time" = q."time")
56. 15.846 15.846 ↓ 0.0 0 7,923

Index Scan using _hyper_14_2146_chunk_metrics_values_time_idx on _hyper_14_2146_chunk m_14 (cost=0.43..9.17 rows=236 width=12) (actual time=0.002..0.002 rows=0 loops=7,923)

  • Index Cond: ("time" = q."time")
57. 15.846 15.846 ↓ 0.0 0 7,923

Index Scan using _hyper_14_2160_chunk_metrics_values_time_idx on _hyper_14_2160_chunk m_15 (cost=0.43..9.30 rows=243 width=12) (actual time=0.002..0.002 rows=0 loops=7,923)

  • Index Cond: ("time" = q."time")
58. 15.846 15.846 ↓ 0.0 0 7,923

Index Scan using _hyper_14_2175_chunk_metrics_values_time_idx on _hyper_14_2175_chunk m_16 (cost=0.43..9.52 rows=256 width=12) (actual time=0.002..0.002 rows=0 loops=7,923)

  • Index Cond: ("time" = q."time")
59. 15.846 15.846 ↓ 0.0 0 7,923

Index Scan using _hyper_14_2193_chunk_metrics_values_time_idx on _hyper_14_2193_chunk m_17 (cost=0.43..9.22 rows=240 width=12) (actual time=0.002..0.002 rows=0 loops=7,923)

  • Index Cond: ("time" = q."time")
60. 15.846 15.846 ↓ 0.0 0 7,923

Index Scan using _hyper_14_2208_chunk_metrics_values_time_idx on _hyper_14_2208_chunk m_18 (cost=0.43..9.31 rows=241 width=12) (actual time=0.002..0.002 rows=0 loops=7,923)

  • Index Cond: ("time" = q."time")
61. 15.846 15.846 ↓ 0.0 0 7,923

Index Scan using _hyper_14_2228_chunk_metrics_values_time_idx on _hyper_14_2228_chunk m_19 (cost=0.43..9.17 rows=236 width=12) (actual time=0.002..0.002 rows=0 loops=7,923)

  • Index Cond: ("time" = q."time")
62. 15.846 15.846 ↓ 0.0 0 7,923

Index Scan using _hyper_14_2247_chunk_metrics_values_time_idx on _hyper_14_2247_chunk m_20 (cost=0.43..8.80 rows=217 width=12) (actual time=0.002..0.002 rows=0 loops=7,923)

  • Index Cond: ("time" = q."time")
63. 15.846 15.846 ↓ 0.0 0 7,923

Index Scan using _hyper_14_2261_chunk_metrics_values_time_idx on _hyper_14_2261_chunk m_21 (cost=0.43..8.81 rows=217 width=12) (actual time=0.002..0.002 rows=0 loops=7,923)

  • Index Cond: ("time" = q."time")
64. 15.846 15.846 ↓ 0.0 0 7,923

Index Scan using _hyper_14_2277_chunk_metrics_values_time_idx on _hyper_14_2277_chunk m_22 (cost=0.43..9.11 rows=231 width=12) (actual time=0.002..0.002 rows=0 loops=7,923)

  • Index Cond: ("time" = q."time")
65. 15.846 15.846 ↓ 0.0 0 7,923

Index Scan using _hyper_14_2293_chunk_metrics_values_time_idx on _hyper_14_2293_chunk m_23 (cost=0.43..9.14 rows=237 width=12) (actual time=0.002..0.002 rows=0 loops=7,923)

  • Index Cond: ("time" = q."time")
66. 15.846 15.846 ↓ 0.0 0 7,923

Index Scan using _hyper_14_2313_chunk_metrics_values_time_idx on _hyper_14_2313_chunk m_24 (cost=0.43..9.15 rows=234 width=12) (actual time=0.002..0.002 rows=0 loops=7,923)

  • Index Cond: ("time" = q."time")
67. 15.846 15.846 ↓ 0.0 0 7,923

Index Scan using _hyper_14_2328_chunk_metrics_values_time_idx on _hyper_14_2328_chunk m_25 (cost=0.43..9.15 rows=238 width=12) (actual time=0.002..0.002 rows=0 loops=7,923)

  • Index Cond: ("time" = q."time")
68. 15.846 15.846 ↓ 0.0 0 7,923

Index Scan using _hyper_14_2344_chunk_metrics_values_time_idx on _hyper_14_2344_chunk m_26 (cost=0.43..8.97 rows=226 width=12) (actual time=0.002..0.002 rows=0 loops=7,923)

  • Index Cond: ("time" = q."time")
69. 15.846 15.846 ↓ 0.0 0 7,923

Index Scan using _hyper_14_2357_chunk_metrics_values_time_idx on _hyper_14_2357_chunk m_27 (cost=0.43..9.18 rows=233 width=12) (actual time=0.002..0.002 rows=0 loops=7,923)

  • Index Cond: ("time" = q."time")
70. 15.846 15.846 ↓ 0.0 0 7,923

Index Scan using _hyper_14_2370_chunk_metrics_values_time_idx on _hyper_14_2370_chunk m_28 (cost=0.43..9.21 rows=239 width=12) (actual time=0.002..0.002 rows=0 loops=7,923)

  • Index Cond: ("time" = q."time")
71. 15.846 15.846 ↓ 0.0 0 7,923

Index Scan using _hyper_14_2385_chunk_metrics_values_time_idx on _hyper_14_2385_chunk m_29 (cost=0.43..9.25 rows=241 width=12) (actual time=0.002..0.002 rows=0 loops=7,923)

  • Index Cond: ("time" = q."time")
72. 15.846 15.846 ↓ 0.0 0 7,923

Index Scan using _hyper_14_2401_chunk_metrics_values_time_idx on _hyper_14_2401_chunk m_30 (cost=0.43..9.71 rows=264 width=12) (actual time=0.002..0.002 rows=0 loops=7,923)

  • Index Cond: ("time" = q."time")
73. 15.846 15.846 ↓ 0.0 0 7,923

Index Scan using _hyper_14_2419_chunk_metrics_values_time_idx on _hyper_14_2419_chunk m_31 (cost=0.43..9.73 rows=266 width=12) (actual time=0.002..0.002 rows=0 loops=7,923)

  • Index Cond: ("time" = q."time")
74. 15.846 15.846 ↓ 0.0 0 7,923

Index Scan using _hyper_14_2435_chunk_metrics_values_time_idx on _hyper_14_2435_chunk m_32 (cost=0.43..10.03 rows=286 width=12) (actual time=0.002..0.002 rows=0 loops=7,923)

  • Index Cond: ("time" = q."time")
75. 15.846 15.846 ↓ 0.0 0 7,923

Index Scan using _hyper_14_2453_chunk_metrics_values_time_idx on _hyper_14_2453_chunk m_33 (cost=0.43..9.93 rows=272 width=12) (actual time=0.002..0.002 rows=0 loops=7,923)

  • Index Cond: ("time" = q."time")
76. 15.846 15.846 ↓ 0.0 0 7,923

Index Scan using _hyper_14_2478_chunk_metrics_values_time_idx on _hyper_14_2478_chunk m_34 (cost=0.43..9.61 rows=256 width=12) (actual time=0.002..0.002 rows=0 loops=7,923)

  • Index Cond: ("time" = q."time")
77. 15.846 15.846 ↓ 0.0 0 7,923

Index Scan using _hyper_14_2513_chunk_metrics_values_time_idx on _hyper_14_2513_chunk m_35 (cost=0.43..9.53 rows=256 width=12) (actual time=0.002..0.002 rows=0 loops=7,923)

  • Index Cond: ("time" = q."time")
78. 15.846 15.846 ↓ 0.0 0 7,923

Index Scan using _hyper_14_2527_chunk_metrics_values_time_idx on _hyper_14_2527_chunk m_36 (cost=0.43..9.60 rows=259 width=12) (actual time=0.002..0.002 rows=0 loops=7,923)

  • Index Cond: ("time" = q."time")
79. 15.846 15.846 ↓ 0.0 0 7,923

Index Scan using _hyper_14_2544_chunk_metrics_values_time_idx on _hyper_14_2544_chunk m_37 (cost=0.43..9.42 rows=249 width=12) (actual time=0.002..0.002 rows=0 loops=7,923)

  • Index Cond: ("time" = q."time")
80. 15.846 15.846 ↓ 0.0 0 7,923

Index Scan using _hyper_14_2560_chunk_metrics_values_time_idx on _hyper_14_2560_chunk m_38 (cost=0.43..9.79 rows=264 width=12) (actual time=0.002..0.002 rows=0 loops=7,923)

  • Index Cond: ("time" = q."time")
81. 23.769 23.769 ↓ 0.0 0 7,923

Index Scan using _hyper_14_2579_chunk_metrics_values_time_idx on _hyper_14_2579_chunk m_39 (cost=0.43..9.94 rows=282 width=12) (actual time=0.003..0.003 rows=0 loops=7,923)

  • Index Cond: ("time" = q."time")
82. 15.846 15.846 ↓ 0.0 0 7,923

Index Scan using _hyper_14_2733_chunk_metrics_values_time_idx on _hyper_14_2733_chunk m_40 (cost=0.43..10.14 rows=284 width=12) (actual time=0.002..0.002 rows=0 loops=7,923)

  • Index Cond: ("time" = q."time")
83. 15.846 15.846 ↓ 0.0 0 7,923

Index Scan using _hyper_14_2751_chunk_metrics_values_time_idx on _hyper_14_2751_chunk m_41 (cost=0.43..9.85 rows=267 width=12) (actual time=0.002..0.002 rows=0 loops=7,923)

  • Index Cond: ("time" = q."time")
84. 15.846 15.846 ↓ 0.0 0 7,923

Index Scan using _hyper_14_2770_chunk_metrics_values_time_idx on _hyper_14_2770_chunk m_42 (cost=0.43..9.59 rows=252 width=12) (actual time=0.002..0.002 rows=0 loops=7,923)

  • Index Cond: ("time" = q."time")
85. 15.846 15.846 ↓ 0.0 0 7,923

Index Scan using _hyper_14_2786_chunk_metrics_values_time_idx on _hyper_14_2786_chunk m_43 (cost=0.43..9.60 rows=255 width=12) (actual time=0.002..0.002 rows=0 loops=7,923)

  • Index Cond: ("time" = q."time")
86. 15.846 15.846 ↓ 0.0 0 7,923

Index Scan using _hyper_14_2804_chunk_metrics_values_time_idx on _hyper_14_2804_chunk m_44 (cost=0.43..9.70 rows=257 width=12) (actual time=0.002..0.002 rows=0 loops=7,923)

  • Index Cond: ("time" = q."time")
87. 15.846 15.846 ↓ 0.0 0 7,923

Index Scan using _hyper_14_2823_chunk_metrics_values_time_idx on _hyper_14_2823_chunk m_45 (cost=0.43..11.78 rows=324 width=12) (actual time=0.002..0.002 rows=0 loops=7,923)

  • Index Cond: ("time" = q."time")
88. 15.846 15.846 ↓ 0.0 0 7,923

Index Scan using _hyper_14_2843_chunk_metrics_values_time_idx on _hyper_14_2843_chunk m_46 (cost=0.43..12.02 rows=313 width=12) (actual time=0.002..0.002 rows=0 loops=7,923)

  • Index Cond: ("time" = q."time")
89. 15.846 15.846 ↓ 0.0 0 7,923

Index Scan using _hyper_14_2861_chunk_metrics_values_time_idx on _hyper_14_2861_chunk m_47 (cost=0.43..9.88 rows=273 width=12) (actual time=0.002..0.002 rows=0 loops=7,923)

  • Index Cond: ("time" = q."time")
90. 15.846 15.846 ↓ 0.0 0 7,923

Index Scan using _hyper_14_2879_chunk_metrics_values_time_idx on _hyper_14_2879_chunk m_48 (cost=0.43..9.18 rows=234 width=12) (actual time=0.002..0.002 rows=0 loops=7,923)

  • Index Cond: ("time" = q."time")
91. 15.846 15.846 ↓ 0.0 0 7,923

Index Scan using _hyper_14_2897_chunk_metrics_values_time_idx on _hyper_14_2897_chunk m_49 (cost=0.43..9.10 rows=228 width=12) (actual time=0.002..0.002 rows=0 loops=7,923)

  • Index Cond: ("time" = q."time")
92. 15.846 15.846 ↓ 0.0 0 7,923

Index Scan using _hyper_14_2913_chunk_metrics_values_time_idx on _hyper_14_2913_chunk m_50 (cost=0.43..9.35 rows=243 width=12) (actual time=0.002..0.002 rows=0 loops=7,923)

  • Index Cond: ("time" = q."time")
93. 15.846 15.846 ↓ 0.0 0 7,923

Index Scan using _hyper_14_2930_chunk_metrics_values_time_idx on _hyper_14_2930_chunk m_51 (cost=0.43..9.50 rows=256 width=12) (actual time=0.002..0.002 rows=0 loops=7,923)

  • Index Cond: ("time" = q."time")
94. 15.846 15.846 ↓ 0.0 0 7,923

Index Scan using _hyper_14_2948_chunk_metrics_values_time_idx on _hyper_14_2948_chunk m_52 (cost=0.43..9.88 rows=274 width=12) (actual time=0.002..0.002 rows=0 loops=7,923)

  • Index Cond: ("time" = q."time")
95. 15.846 15.846 ↓ 0.0 0 7,923

Index Scan using _hyper_14_2964_chunk_metrics_values_time_idx on _hyper_14_2964_chunk m_53 (cost=0.43..9.82 rows=269 width=12) (actual time=0.002..0.002 rows=0 loops=7,923)

  • Index Cond: ("time" = q."time")
96. 15.846 15.846 ↓ 0.0 0 7,923

Index Scan using _hyper_14_2982_chunk_metrics_values_time_idx on _hyper_14_2982_chunk m_54 (cost=0.43..9.78 rows=264 width=12) (actual time=0.002..0.002 rows=0 loops=7,923)

  • Index Cond: ("time" = q."time")
97. 15.846 15.846 ↓ 0.0 0 7,923

Index Scan using _hyper_14_3000_chunk_metrics_values_time_idx on _hyper_14_3000_chunk m_55 (cost=0.43..9.49 rows=250 width=12) (actual time=0.002..0.002 rows=0 loops=7,923)

  • Index Cond: ("time" = q."time")
98. 15.846 15.846 ↓ 0.0 0 7,923

Index Scan using _hyper_14_3018_chunk_metrics_values_time_idx on _hyper_14_3018_chunk m_56 (cost=0.43..7.41 rows=195 width=12) (actual time=0.002..0.002 rows=0 loops=7,923)

  • Index Cond: ("time" = q."time")
99. 15.846 15.846 ↓ 0.0 0 7,923

Index Scan using _hyper_14_3037_chunk_metrics_values_time_idx on _hyper_14_3037_chunk m_57 (cost=0.43..7.40 rows=192 width=12) (actual time=0.002..0.002 rows=0 loops=7,923)

  • Index Cond: ("time" = q."time")
100. 15.846 15.846 ↓ 0.0 0 7,923

Index Scan using _hyper_14_3056_chunk_metrics_values_time_idx on _hyper_14_3056_chunk m_58 (cost=0.43..7.65 rows=209 width=12) (actual time=0.002..0.002 rows=0 loops=7,923)

  • Index Cond: ("time" = q."time")
101. 15.846 15.846 ↓ 0.0 0 7,923

Index Scan using _hyper_14_3075_chunk_metrics_values_time_idx on _hyper_14_3075_chunk m_59 (cost=0.43..8.81 rows=215 width=12) (actual time=0.002..0.002 rows=0 loops=7,923)

  • Index Cond: ("time" = q."time")
102. 768.531 768.531 ↑ 1.2 159 7,923

Index Scan using _hyper_14_3092_chunk_metrics_values_time_idx on _hyper_14_3092_chunk m_60 (cost=0.43..7.32 rows=190 width=12) (actual time=0.007..0.097 rows=159 loops=7,923)

  • Index Cond: ("time" = q."time")
103. 190.152 190.152 ↑ 5.4 37 7,923

Index Scan using _hyper_14_3109_chunk_metrics_values_time_idx on _hyper_14_3109_chunk m_61 (cost=0.42..6.82 rows=198 width=12) (actual time=0.003..0.024 rows=37 loops=7,923)

  • Index Cond: ("time" = q."time")
104. 41.824 89.499 ↓ 1.0 46,896 1

Hash (cost=20,902.38..20,902.38 rows=45,929 width=216) (actual time=89.498..89.499 rows=46,896 loops=1)

  • Buckets: 32768 Batches: 2 Memory Usage: 5690kB
105. 43.306 47.675 ↓ 1.0 46,896 1

Bitmap Heap Scan on metrics_labels l (cost=828.27..20,902.38 rows=45,929 width=216) (actual time=5.828..47.675 rows=46,896 loops=1)

  • Recheck Cond: (metric_name = 'version_id'::text)
  • Heap Blocks: exact=9886
106. 4.369 4.369 ↓ 1.0 46,896 1

Bitmap Index Scan on metrics_labels_metric_name_idx (cost=0.00..816.79 rows=45,929 width=0) (actual time=4.368..4.369 rows=46,896 loops=1)

  • Index Cond: (metric_name = 'version_id'::text)
107. 10.855 10.855 ↑ 1.0 1 2,171

Index Scan using game_meta_info_pkey on game_meta_info gmi (cost=0.28..0.57 rows=1 width=30) (actual time=0.005..0.005 rows=1 loops=2,171)

  • Index Cond: (cms_id = q.cms_id)
Planning time : 22.688 ms
Execution time : 6,350.951 ms