explain.depesz.com

PostgreSQL's explain analyze made readable

Result: cdee

Settings
# exclusive inclusive rows x rows loops node
1. 0.004 17.565 ↓ 0.0 15 1

Limit (cost=0.00..0.00 rows=0 width=0) (actual time=17.561..17.565 rows=15 loops=1)

2. 0.036 17.561 ↓ 0.0 15 1

Sort (cost=0.00..0.00 rows=0 width=0) (actual time=17.561..17.561 rows=15 loops=1)

  • Sort Key: remote_scan.minute
  • Sort Method: top-N heapsort Memory: 26kB
3. 0.242 17.525 ↓ 0.0 160 1

HashAggregate (cost=0.00..0.00 rows=0 width=0) (actual time=17.387..17.525 rows=160 loops=1)

  • Group Key: remote_scan.minute, remote_scan.site_id
4. 11.596 17.283 ↓ 0.0 160 1

Custom Scan (Citus Adaptive) (cost=0.00..0.00 rows=0 width=0) (actual time=17.272..17.283 rows=160 loops=1)

  • Task Count: 32
  • Tasks Shown: All
  • -> Task
  • Node: host=10.0.0.230 port=5432 dbname=citus
  • -> Task
  • Node: host=10.0.0.235 port=5432 dbname=citus
  • -> Task
  • Node: host=10.0.0.230 port=5432 dbname=citus
  • -> Task
  • Node: host=10.0.0.235 port=5432 dbname=citus
  • -> Task
  • Node: host=10.0.0.230 port=5432 dbname=citus
  • -> Task
  • Node: host=10.0.0.235 port=5432 dbname=citus
  • -> Task
  • Node: host=10.0.0.230 port=5432 dbname=citus
  • -> Task
  • Node: host=10.0.0.235 port=5432 dbname=citus
  • -> Task
  • Node: host=10.0.0.230 port=5432 dbname=citus
  • -> Task
  • Node: host=10.0.0.235 port=5432 dbname=citus
  • -> Task
  • Node: host=10.0.0.230 port=5432 dbname=citus
  • -> Task
  • Node: host=10.0.0.235 port=5432 dbname=citus
  • -> Task
  • Node: host=10.0.0.230 port=5432 dbname=citus
  • -> Task
  • Node: host=10.0.0.235 port=5432 dbname=citus
  • -> Task
  • Node: host=10.0.0.230 port=5432 dbname=citus
  • -> Task
  • Node: host=10.0.0.235 port=5432 dbname=citus
  • -> Task
  • Node: host=10.0.0.230 port=5432 dbname=citus
  • -> Task
  • Node: host=10.0.0.235 port=5432 dbname=citus
  • -> Task
  • Node: host=10.0.0.230 port=5432 dbname=citus
  • -> Task
  • Node: host=10.0.0.235 port=5432 dbname=citus
  • -> Task
  • Node: host=10.0.0.230 port=5432 dbname=citus
  • -> Task
  • Node: host=10.0.0.235 port=5432 dbname=citus
  • -> Task
  • Node: host=10.0.0.230 port=5432 dbname=citus
  • -> Task
  • Node: host=10.0.0.235 port=5432 dbname=citus
  • -> Task
  • Node: host=10.0.0.230 port=5432 dbname=citus
  • -> Task
  • Node: host=10.0.0.235 port=5432 dbname=citus
  • -> Task
  • Node: host=10.0.0.230 port=5432 dbname=citus
  • -> Task
  • Node: host=10.0.0.235 port=5432 dbname=citus
  • -> Task
  • Node: host=10.0.0.230 port=5432 dbname=citus
  • -> Task
  • Node: host=10.0.0.235 port=5432 dbname=citus
  • -> Task
  • Node: host=10.0.0.230 port=5432 dbname=citus
  • -> Task
  • Node: host=10.0.0.235 port=5432 dbname=citus
5. 0.002 0.468 ↑ 1.5 10 1

Limit (cost=29.09..29.72 rows=15 width=52) (actual time=0.417..0.468 rows=10 loops=1)

  • Buffers: shared hit=10
6. 0.055 0.466 ↑ 19.0 10 1

GroupAggregate (cost=29.09..37.16 rows=190 width=52) (actual time=0.416..0.466 rows=10 loops=1)

  • Group Key: (date_trunc('minute'::text, ingest_time)), site_id
  • Buffers: shared hit=10
7. 0.092 0.411 ↑ 1.3 151 1

Sort (cost=29.09..29.56 rows=190 width=20) (actual time=0.398..0.411 rows=151 loops=1)

  • Sort Key: (date_trunc('minute'::text, ingest_time)), site_id
  • Sort Method: quicksort Memory: 36kB
  • Buffers: shared hit=10
8. 0.319 0.319 ↑ 1.3 151 1

Seq Scan on http_request_102008 http_request (cost=0.00..21.90 rows=190 width=20) (actual time=0.167..0.319 rows=151 loops=1)

  • Filter: (date_trunc('minute'::text, ingest_time) > (now() - '00:05:00'::interval))
  • Rows Removed by Filter: 421
  • Buffers: shared hit=10
9. 0.003 0.704 ↑ 1.0 15 1

Limit (cost=42.68..43.32 rows=15 width=52) (actual time=0.638..0.704 rows=15 loops=1)

  • Buffers: shared hit=14
10. 0.063 0.701 ↑ 18.5 15 1

GroupAggregate (cost=42.68..54.50 rows=278 width=52) (actual time=0.637..0.701 rows=15 loops=1)

  • Group Key: (date_trunc('minute'::text, ingest_time)), site_id
  • Buffers: shared hit=14
11. 0.169 0.638 ↑ 1.3 221 1

Sort (cost=42.68..43.38 rows=278 width=20) (actual time=0.621..0.638 rows=221 loops=1)

  • Sort Key: (date_trunc('minute'::text, ingest_time)), site_id
  • Sort Method: quicksort Memory: 42kB
  • Buffers: shared hit=14
12. 0.469 0.469 ↑ 1.3 221 1

Seq Scan on http_request_102009 http_request (cost=0.00..31.39 rows=278 width=20) (actual time=0.283..0.469 rows=221 loops=1)

  • Filter: (date_trunc('minute'::text, ingest_time) > (now() - '00:05:00'::interval))
  • Rows Removed by Filter: 596
  • Buffers: shared hit=14
13. 0.000 0.100 ↑ 3.0 5 1

Limit (cost=13.22..13.86 rows=15 width=52) (actual time=0.088..0.100 rows=5 loops=1)

  • Buffers: shared hit=5
14. 0.017 0.100 ↑ 17.4 5 1

GroupAggregate (cost=13.22..16.92 rows=87 width=52) (actual time=0.088..0.100 rows=5 loops=1)

  • Group Key: (date_trunc('minute'::text, ingest_time)), site_id
  • Buffers: shared hit=5
15. 0.013 0.083 ↑ 1.3 68 1

Sort (cost=13.22..13.44 rows=87 width=20) (actual time=0.081..0.083 rows=68 loops=1)

  • Sort Key: (date_trunc('minute'::text, ingest_time)), site_id
  • Sort Method: quicksort Memory: 30kB
  • Buffers: shared hit=5
16. 0.070 0.070 ↑ 1.3 68 1

Seq Scan on http_request_102010 http_request (cost=0.00..10.42 rows=87 width=20) (actual time=0.046..0.070 rows=68 loops=1)

  • Filter: (date_trunc('minute'::text, ingest_time) > (now() - '00:05:00'::interval))
  • Rows Removed by Filter: 214
  • Buffers: shared hit=5
17. 0.003 0.418 ↑ 1.5 10 1

Limit (cost=27.12..27.76 rows=15 width=52) (actual time=0.356..0.418 rows=10 loops=1)

  • Buffers: shared hit=9
18. 0.061 0.415 ↑ 18.1 10 1

GroupAggregate (cost=27.12..34.81 rows=181 width=52) (actual time=0.355..0.415 rows=10 loops=1)

  • Group Key: (date_trunc('minute'::text, ingest_time)), site_id
  • Buffers: shared hit=9
19. 0.065 0.354 ↑ 1.3 140 1

Sort (cost=27.12..27.57 rows=181 width=20) (actual time=0.341..0.354 rows=140 loops=1)

  • Sort Key: (date_trunc('minute'::text, ingest_time)), site_id
  • Sort Method: quicksort Memory: 35kB
  • Buffers: shared hit=9
20. 0.289 0.289 ↑ 1.3 140 1

Seq Scan on http_request_102011 http_request (cost=0.00..20.33 rows=181 width=20) (actual time=0.167..0.289 rows=140 loops=1)

  • Filter: (date_trunc('minute'::text, ingest_time) > (now() - '00:05:00'::interval))
  • Rows Removed by Filter: 397
  • Buffers: shared hit=9
21. 0.001 0.099 ↑ 3.0 5 1

Limit (cost=12.75..13.39 rows=15 width=52) (actual time=0.086..0.099 rows=5 loops=1)

  • Buffers: shared hit=5
22. 0.017 0.098 ↑ 16.4 5 1

GroupAggregate (cost=12.75..16.24 rows=82 width=52) (actual time=0.086..0.098 rows=5 loops=1)

  • Group Key: (date_trunc('minute'::text, ingest_time)), site_id
  • Buffers: shared hit=5
23. 0.014 0.081 ↑ 1.1 77 1

Sort (cost=12.75..12.96 rows=82 width=20) (actual time=0.078..0.081 rows=77 loops=1)

  • Sort Key: (date_trunc('minute'::text, ingest_time)), site_id
  • Sort Method: quicksort Memory: 31kB
  • Buffers: shared hit=5
24. 0.067 0.067 ↑ 1.1 77 1

Seq Scan on http_request_102012 http_request (cost=0.00..10.15 rows=82 width=20) (actual time=0.039..0.067 rows=77 loops=1)

  • Filter: (date_trunc('minute'::text, ingest_time) > (now() - '00:05:00'::interval))
  • Rows Removed by Filter: 178
  • Buffers: shared hit=5
25. 0.001 0.007 ↓ 0.0 0 1

Limit (cost=28.72..29.53 rows=15 width=52) (actual time=0.007..0.007 rows=0 loops=1)

26. 0.000 0.006 ↓ 0.0 0 1

GroupAggregate (cost=28.72..36.03 rows=136 width=52) (actual time=0.006..0.006 rows=0 loops=1)

  • Group Key: (date_trunc('minute'::text, ingest_time)), site_id
27. 0.003 0.006 ↓ 0.0 0 1

Sort (cost=28.72..29.19 rows=187 width=20) (actual time=0.006..0.006 rows=0 loops=1)

  • Sort Key: (date_trunc('minute'::text, ingest_time)), site_id
  • Sort Method: quicksort Memory: 25kB
28. 0.003 0.003 ↓ 0.0 0 1

Seq Scan on http_request_102013 http_request (cost=0.00..21.67 rows=187 width=20) (actual time=0.003..0.003 rows=0 loops=1)

  • Filter: (date_trunc('minute'::text, ingest_time) > (now() - '00:05:00'::interval))
29. 0.000 0.141 ↑ 3.0 5 1

Limit (cost=13.36..14.00 rows=15 width=52) (actual time=0.123..0.141 rows=5 loops=1)

  • Buffers: shared hit=5
30. 0.022 0.141 ↑ 17.6 5 1

GroupAggregate (cost=13.36..17.10 rows=88 width=52) (actual time=0.123..0.141 rows=5 loops=1)

  • Group Key: (date_trunc('minute'::text, ingest_time)), site_id
  • Buffers: shared hit=5
31. 0.019 0.119 ↑ 1.3 70 1

Sort (cost=13.36..13.58 rows=88 width=20) (actual time=0.115..0.119 rows=70 loops=1)

  • Sort Key: (date_trunc('minute'::text, ingest_time)), site_id
  • Sort Method: quicksort Memory: 30kB
  • Buffers: shared hit=5
32. 0.100 0.100 ↑ 1.3 70 1

Seq Scan on http_request_102014 http_request (cost=0.00..10.52 rows=88 width=20) (actual time=0.065..0.100 rows=70 loops=1)

  • Filter: (date_trunc('minute'::text, ingest_time) > (now() - '00:05:00'::interval))
  • Rows Removed by Filter: 208
  • Buffers: shared hit=5
33. 0.000 0.007 ↓ 0.0 0 1

Limit (cost=28.72..29.53 rows=15 width=52) (actual time=0.007..0.007 rows=0 loops=1)

34. 0.001 0.007 ↓ 0.0 0 1

GroupAggregate (cost=28.72..36.03 rows=136 width=52) (actual time=0.007..0.007 rows=0 loops=1)

  • Group Key: (date_trunc('minute'::text, ingest_time)), site_id
35. 0.002 0.006 ↓ 0.0 0 1

Sort (cost=28.72..29.19 rows=187 width=20) (actual time=0.006..0.006 rows=0 loops=1)

  • Sort Key: (date_trunc('minute'::text, ingest_time)), site_id
  • Sort Method: quicksort Memory: 25kB
36. 0.004 0.004 ↓ 0.0 0 1

Seq Scan on http_request_102015 http_request (cost=0.00..21.67 rows=187 width=20) (actual time=0.004..0.004 rows=0 loops=1)

  • Filter: (date_trunc('minute'::text, ingest_time) > (now() - '00:05:00'::interval))
37. 0.003 0.404 ↑ 1.0 15 1

Limit (cost=42.55..43.19 rows=15 width=52) (actual time=0.352..0.404 rows=15 loops=1)

  • Buffers: shared hit=14
38. 0.046 0.401 ↑ 18.5 15 1

GroupAggregate (cost=42.55..54.32 rows=277 width=52) (actual time=0.352..0.401 rows=15 loops=1)

  • Group Key: (date_trunc('minute'::text, ingest_time)), site_id
  • Buffers: shared hit=14
39. 0.060 0.355 ↑ 1.2 237 1

Sort (cost=42.55..43.24 rows=277 width=20) (actual time=0.344..0.355 rows=237 loops=1)

  • Sort Key: (date_trunc('minute'::text, ingest_time)), site_id
  • Sort Method: quicksort Memory: 43kB
  • Buffers: shared hit=14
40. 0.295 0.295 ↑ 1.2 237 1

Seq Scan on http_request_102016 http_request (cost=0.00..31.31 rows=277 width=20) (actual time=0.184..0.295 rows=237 loops=1)

  • Filter: (date_trunc('minute'::text, ingest_time) > (now() - '00:05:00'::interval))
  • Rows Removed by Filter: 583
  • Buffers: shared hit=14
41. 0.001 0.132 ↑ 3.0 5 1

Limit (cost=14.76..15.40 rows=15 width=52) (actual time=0.117..0.132 rows=5 loops=1)

  • Buffers: shared hit=5
42. 0.020 0.131 ↑ 20.4 5 1

GroupAggregate (cost=14.76..19.09 rows=102 width=52) (actual time=0.116..0.131 rows=5 loops=1)

  • Group Key: (date_trunc('minute'::text, ingest_time)), site_id
  • Buffers: shared hit=5
43. 0.017 0.111 ↑ 1.5 69 1

Sort (cost=14.76..15.01 rows=102 width=20) (actual time=0.107..0.111 rows=69 loops=1)

  • Sort Key: (date_trunc('minute'::text, ingest_time)), site_id
  • Sort Method: quicksort Memory: 30kB
  • Buffers: shared hit=5
44. 0.094 0.094 ↑ 1.5 69 1

Seq Scan on http_request_102017 http_request (cost=0.00..11.36 rows=102 width=20) (actual time=0.059..0.094 rows=69 loops=1)

  • Filter: (date_trunc('minute'::text, ingest_time) > (now() - '00:05:00'::interval))
  • Rows Removed by Filter: 201
  • Buffers: shared hit=5
45. 0.001 0.106 ↑ 3.0 5 1

Limit (cost=12.75..13.39 rows=15 width=52) (actual time=0.093..0.106 rows=5 loops=1)

  • Buffers: shared hit=5
46. 0.016 0.105 ↑ 16.4 5 1

GroupAggregate (cost=12.75..16.24 rows=82 width=52) (actual time=0.093..0.105 rows=5 loops=1)

  • Group Key: (date_trunc('minute'::text, ingest_time)), site_id
  • Buffers: shared hit=5
47. 0.014 0.089 ↑ 1.4 60 1

Sort (cost=12.75..12.96 rows=82 width=20) (actual time=0.086..0.089 rows=60 loops=1)

  • Sort Key: (date_trunc('minute'::text, ingest_time)), site_id
  • Sort Method: quicksort Memory: 29kB
  • Buffers: shared hit=5
48. 0.075 0.075 ↑ 1.4 60 1

Seq Scan on http_request_102018 http_request (cost=0.00..10.15 rows=82 width=20) (actual time=0.051..0.075 rows=60 loops=1)

  • Filter: (date_trunc('minute'::text, ingest_time) > (now() - '00:05:00'::interval))
  • Rows Removed by Filter: 209
  • Buffers: shared hit=5
49. 0.000 0.006 ↓ 0.0 0 1

Limit (cost=28.72..29.53 rows=15 width=52) (actual time=0.006..0.006 rows=0 loops=1)

50. 0.001 0.006 ↓ 0.0 0 1

GroupAggregate (cost=28.72..36.03 rows=136 width=52) (actual time=0.006..0.006 rows=0 loops=1)

  • Group Key: (date_trunc('minute'::text, ingest_time)), site_id
51. 0.002 0.005 ↓ 0.0 0 1

Sort (cost=28.72..29.19 rows=187 width=20) (actual time=0.005..0.005 rows=0 loops=1)

  • Sort Key: (date_trunc('minute'::text, ingest_time)), site_id
  • Sort Method: quicksort Memory: 25kB
52. 0.003 0.003 ↓ 0.0 0 1

Seq Scan on http_request_102019 http_request (cost=0.00..21.67 rows=187 width=20) (actual time=0.003..0.003 rows=0 loops=1)

  • Filter: (date_trunc('minute'::text, ingest_time) > (now() - '00:05:00'::interval))
53. 0.001 0.006 ↓ 0.0 0 1

Limit (cost=28.72..29.53 rows=15 width=52) (actual time=0.006..0.006 rows=0 loops=1)

54. 0.000 0.005 ↓ 0.0 0 1

GroupAggregate (cost=28.72..36.03 rows=136 width=52) (actual time=0.005..0.005 rows=0 loops=1)

  • Group Key: (date_trunc('minute'::text, ingest_time)), site_id
55. 0.002 0.005 ↓ 0.0 0 1

Sort (cost=28.72..29.19 rows=187 width=20) (actual time=0.005..0.005 rows=0 loops=1)

  • Sort Key: (date_trunc('minute'::text, ingest_time)), site_id
  • Sort Method: quicksort Memory: 25kB
56. 0.003 0.003 ↓ 0.0 0 1

Seq Scan on http_request_102020 http_request (cost=0.00..21.67 rows=187 width=20) (actual time=0.003..0.003 rows=0 loops=1)

  • Filter: (date_trunc('minute'::text, ingest_time) > (now() - '00:05:00'::interval))
57. 0.002 0.251 ↑ 1.5 10 1

Limit (cost=26.33..26.97 rows=15 width=52) (actual time=0.219..0.251 rows=10 loops=1)

  • Buffers: shared hit=9
58. 0.031 0.249 ↑ 17.4 10 1

GroupAggregate (cost=26.33..33.73 rows=174 width=52) (actual time=0.219..0.249 rows=10 loops=1)

  • Group Key: (date_trunc('minute'::text, ingest_time)), site_id
  • Buffers: shared hit=9
59. 0.040 0.218 ↑ 1.3 133 1

Sort (cost=26.33..26.77 rows=174 width=20) (actual time=0.212..0.218 rows=133 loops=1)

  • Sort Key: (date_trunc('minute'::text, ingest_time)), site_id
  • Sort Method: quicksort Memory: 35kB
  • Buffers: shared hit=9
60. 0.178 0.178 ↑ 1.3 133 1

Seq Scan on http_request_102021 http_request (cost=0.00..19.86 rows=174 width=20) (actual time=0.119..0.178 rows=133 loops=1)

  • Filter: (date_trunc('minute'::text, ingest_time) > (now() - '00:05:00'::interval))
  • Rows Removed by Filter: 416
  • Buffers: shared hit=9
61. 0.001 0.006 ↓ 0.0 0 1

Limit (cost=28.72..29.53 rows=15 width=52) (actual time=0.006..0.006 rows=0 loops=1)

62. 0.000 0.005 ↓ 0.0 0 1

GroupAggregate (cost=28.72..36.03 rows=136 width=52) (actual time=0.005..0.005 rows=0 loops=1)

  • Group Key: (date_trunc('minute'::text, ingest_time)), site_id
63. 0.002 0.005 ↓ 0.0 0 1

Sort (cost=28.72..29.19 rows=187 width=20) (actual time=0.005..0.005 rows=0 loops=1)

  • Sort Key: (date_trunc('minute'::text, ingest_time)), site_id
  • Sort Method: quicksort Memory: 25kB
64. 0.003 0.003 ↓ 0.0 0 1

Seq Scan on http_request_102022 http_request (cost=0.00..21.67 rows=187 width=20) (actual time=0.003..0.003 rows=0 loops=1)

  • Filter: (date_trunc('minute'::text, ingest_time) > (now() - '00:05:00'::interval))
65. 0.001 0.167 ↑ 3.0 5 1

Limit (cost=12.81..13.45 rows=15 width=52) (actual time=0.152..0.167 rows=5 loops=1)

  • Buffers: shared hit=5
66. 0.019 0.166 ↑ 16.6 5 1

GroupAggregate (cost=12.81..16.34 rows=83 width=52) (actual time=0.151..0.166 rows=5 loops=1)

  • Group Key: (date_trunc('minute'::text, ingest_time)), site_id
  • Buffers: shared hit=5
67. 0.016 0.147 ↑ 1.2 70 1

Sort (cost=12.81..13.02 rows=83 width=20) (actual time=0.143..0.147 rows=70 loops=1)

  • Sort Key: (date_trunc('minute'::text, ingest_time)), site_id
  • Sort Method: quicksort Memory: 30kB
  • Buffers: shared hit=5
68. 0.131 0.131 ↑ 1.2 70 1

Seq Scan on http_request_102023 http_request (cost=0.00..10.17 rows=83 width=20) (actual time=0.077..0.131 rows=70 loops=1)

  • Filter: (date_trunc('minute'::text, ingest_time) > (now() - '00:05:00'::interval))
  • Rows Removed by Filter: 190
  • Buffers: shared hit=5
69. 0.001 0.006 ↓ 0.0 0 1

Limit (cost=28.72..29.53 rows=15 width=52) (actual time=0.006..0.006 rows=0 loops=1)

70. 0.000 0.005 ↓ 0.0 0 1

GroupAggregate (cost=28.72..36.03 rows=136 width=52) (actual time=0.005..0.005 rows=0 loops=1)

  • Group Key: (date_trunc('minute'::text, ingest_time)), site_id
71. 0.002 0.005 ↓ 0.0 0 1

Sort (cost=28.72..29.19 rows=187 width=20) (actual time=0.005..0.005 rows=0 loops=1)

  • Sort Key: (date_trunc('minute'::text, ingest_time)), site_id
  • Sort Method: quicksort Memory: 25kB
72. 0.003 0.003 ↓ 0.0 0 1

Seq Scan on http_request_102024 http_request (cost=0.00..21.67 rows=187 width=20) (actual time=0.003..0.003 rows=0 loops=1)

  • Filter: (date_trunc('minute'::text, ingest_time) > (now() - '00:05:00'::interval))
73. 0.000 0.006 ↓ 0.0 0 1

Limit (cost=28.72..29.53 rows=15 width=52) (actual time=0.006..0.006 rows=0 loops=1)

74. 0.001 0.006 ↓ 0.0 0 1

GroupAggregate (cost=28.72..36.03 rows=136 width=52) (actual time=0.006..0.006 rows=0 loops=1)

  • Group Key: (date_trunc('minute'::text, ingest_time)), site_id
75. 0.002 0.005 ↓ 0.0 0 1

Sort (cost=28.72..29.19 rows=187 width=20) (actual time=0.005..0.005 rows=0 loops=1)

  • Sort Key: (date_trunc('minute'::text, ingest_time)), site_id
  • Sort Method: quicksort Memory: 25kB
76. 0.003 0.003 ↓ 0.0 0 1

Seq Scan on http_request_102025 http_request (cost=0.00..21.67 rows=187 width=20) (actual time=0.003..0.003 rows=0 loops=1)

  • Filter: (date_trunc('minute'::text, ingest_time) > (now() - '00:05:00'::interval))
77. 0.001 0.006 ↓ 0.0 0 1

Limit (cost=28.72..29.53 rows=15 width=52) (actual time=0.006..0.006 rows=0 loops=1)

78. 0.000 0.005 ↓ 0.0 0 1

GroupAggregate (cost=28.72..36.03 rows=136 width=52) (actual time=0.005..0.005 rows=0 loops=1)

  • Group Key: (date_trunc('minute'::text, ingest_time)), site_id
79. 0.002 0.005 ↓ 0.0 0 1

Sort (cost=28.72..29.19 rows=187 width=20) (actual time=0.005..0.005 rows=0 loops=1)

  • Sort Key: (date_trunc('minute'::text, ingest_time)), site_id
  • Sort Method: quicksort Memory: 25kB
80. 0.003 0.003 ↓ 0.0 0 1

Seq Scan on http_request_102026 http_request (cost=0.00..21.67 rows=187 width=20) (actual time=0.003..0.003 rows=0 loops=1)

  • Filter: (date_trunc('minute'::text, ingest_time) > (now() - '00:05:00'::interval))
81. 0.002 0.660 ↑ 3.0 5 1

Limit (cost=13.16..13.80 rows=15 width=52) (actual time=0.635..0.660 rows=5 loops=1)

  • Buffers: shared hit=5
82. 0.030 0.658 ↑ 17.2 5 1

GroupAggregate (cost=13.16..16.81 rows=86 width=52) (actual time=0.634..0.658 rows=5 loops=1)

  • Group Key: (date_trunc('minute'::text, ingest_time)), site_id
  • Buffers: shared hit=5
83. 0.035 0.628 ↑ 1.1 75 1

Sort (cost=13.16..13.37 rows=86 width=20) (actual time=0.622..0.628 rows=75 loops=1)

  • Sort Key: (date_trunc('minute'::text, ingest_time)), site_id
  • Sort Method: quicksort Memory: 30kB
  • Buffers: shared hit=5
84. 0.593 0.593 ↑ 1.1 75 1

Seq Scan on http_request_102027 http_request (cost=0.00..10.39 rows=86 width=20) (actual time=0.516..0.593 rows=75 loops=1)

  • Filter: (date_trunc('minute'::text, ingest_time) > (now() - '00:05:00'::interval))
  • Rows Removed by Filter: 208
  • Buffers: shared hit=5
85. 0.002 0.235 ↑ 3.0 5 1

Limit (cost=13.73..14.37 rows=15 width=52) (actual time=0.115..0.235 rows=5 loops=1)

  • Buffers: shared hit=5
86. 0.020 0.233 ↑ 18.4 5 1

GroupAggregate (cost=13.73..17.64 rows=92 width=52) (actual time=0.115..0.233 rows=5 loops=1)

  • Group Key: (date_trunc('minute'::text, ingest_time)), site_id
  • Buffers: shared hit=5
87. 0.117 0.213 ↑ 1.2 76 1

Sort (cost=13.73..13.96 rows=92 width=20) (actual time=0.108..0.213 rows=76 loops=1)

  • Sort Key: (date_trunc('minute'::text, ingest_time)), site_id
  • Sort Method: quicksort Memory: 30kB
  • Buffers: shared hit=5
88. 0.096 0.096 ↑ 1.2 76 1

Seq Scan on http_request_102028 http_request (cost=0.00..10.73 rows=92 width=20) (actual time=0.049..0.096 rows=76 loops=1)

  • Filter: (date_trunc('minute'::text, ingest_time) > (now() - '00:05:00'::interval))
  • Rows Removed by Filter: 228
  • Buffers: shared hit=5
89. 0.001 0.133 ↑ 3.0 5 1

Limit (cost=12.55..13.19 rows=15 width=52) (actual time=0.118..0.133 rows=5 loops=1)

  • Buffers: shared hit=5
90. 0.019 0.132 ↑ 16.0 5 1

GroupAggregate (cost=12.55..15.95 rows=80 width=52) (actual time=0.118..0.132 rows=5 loops=1)

  • Group Key: (date_trunc('minute'::text, ingest_time)), site_id
  • Buffers: shared hit=5
91. 0.019 0.113 ↑ 1.3 63 1

Sort (cost=12.55..12.75 rows=80 width=20) (actual time=0.108..0.113 rows=63 loops=1)

  • Sort Key: (date_trunc('minute'::text, ingest_time)), site_id
  • Sort Method: quicksort Memory: 29kB
  • Buffers: shared hit=5
92. 0.094 0.094 ↑ 1.3 63 1

Seq Scan on http_request_102029 http_request (cost=0.00..10.02 rows=80 width=20) (actual time=0.062..0.094 rows=63 loops=1)

  • Filter: (date_trunc('minute'::text, ingest_time) > (now() - '00:05:00'::interval))
  • Rows Removed by Filter: 194
  • Buffers: shared hit=5
93. 0.001 0.006 ↓ 0.0 0 1

Limit (cost=28.72..29.53 rows=15 width=52) (actual time=0.006..0.006 rows=0 loops=1)

94. 0.000 0.005 ↓ 0.0 0 1

GroupAggregate (cost=28.72..36.03 rows=136 width=52) (actual time=0.005..0.005 rows=0 loops=1)

  • Group Key: (date_trunc('minute'::text, ingest_time)), site_id
95. 0.002 0.005 ↓ 0.0 0 1

Sort (cost=28.72..29.19 rows=187 width=20) (actual time=0.005..0.005 rows=0 loops=1)

  • Sort Key: (date_trunc('minute'::text, ingest_time)), site_id
  • Sort Method: quicksort Memory: 25kB
96. 0.003 0.003 ↓ 0.0 0 1

Seq Scan on http_request_102030 http_request (cost=0.00..21.67 rows=187 width=20) (actual time=0.003..0.003 rows=0 loops=1)

  • Filter: (date_trunc('minute'::text, ingest_time) > (now() - '00:05:00'::interval))
97. 0.001 0.160 ↑ 3.0 5 1

Limit (cost=14.76..15.40 rows=15 width=52) (actual time=0.145..0.160 rows=5 loops=1)

  • Buffers: shared hit=5
98. 0.019 0.159 ↑ 20.4 5 1

GroupAggregate (cost=14.76..19.09 rows=102 width=52) (actual time=0.145..0.159 rows=5 loops=1)

  • Group Key: (date_trunc('minute'::text, ingest_time)), site_id
  • Buffers: shared hit=5
99. 0.017 0.140 ↑ 1.6 65 1

Sort (cost=14.76..15.01 rows=102 width=20) (actual time=0.136..0.140 rows=65 loops=1)

  • Sort Key: (date_trunc('minute'::text, ingest_time)), site_id
  • Sort Method: quicksort Memory: 30kB
  • Buffers: shared hit=5
100. 0.123 0.123 ↑ 1.6 65 1

Seq Scan on http_request_102031 http_request (cost=0.00..11.36 rows=102 width=20) (actual time=0.093..0.123 rows=65 loops=1)

  • Filter: (date_trunc('minute'::text, ingest_time) > (now() - '00:05:00'::interval))
  • Rows Removed by Filter: 199
  • Buffers: shared hit=5
101. 0.000 0.103 ↑ 3.0 5 1

Limit (cost=12.85..13.49 rows=15 width=52) (actual time=0.092..0.103 rows=5 loops=1)

  • Buffers: shared hit=5
102. 0.016 0.103 ↑ 16.6 5 1

GroupAggregate (cost=12.85..16.38 rows=83 width=52) (actual time=0.091..0.103 rows=5 loops=1)

  • Group Key: (date_trunc('minute'::text, ingest_time)), site_id
  • Buffers: shared hit=5
103. 0.014 0.087 ↑ 1.1 74 1

Sort (cost=12.85..13.06 rows=83 width=20) (actual time=0.084..0.087 rows=74 loops=1)

  • Sort Key: (date_trunc('minute'::text, ingest_time)), site_id
  • Sort Method: quicksort Memory: 30kB
  • Buffers: shared hit=5
104. 0.073 0.073 ↑ 1.1 74 1

Seq Scan on http_request_102032 http_request (cost=0.00..10.21 rows=83 width=20) (actual time=0.046..0.073 rows=74 loops=1)

  • Filter: (date_trunc('minute'::text, ingest_time) > (now() - '00:05:00'::interval))
  • Rows Removed by Filter: 210
  • Buffers: shared hit=5
105. 0.001 0.164 ↑ 3.0 5 1

Limit (cost=12.61..13.25 rows=15 width=52) (actual time=0.145..0.164 rows=5 loops=1)

  • Buffers: shared hit=5
106. 0.022 0.163 ↑ 16.2 5 1

GroupAggregate (cost=12.61..16.05 rows=81 width=52) (actual time=0.145..0.163 rows=5 loops=1)

  • Group Key: (date_trunc('minute'::text, ingest_time)), site_id
  • Buffers: shared hit=5
107. 0.027 0.141 ↓ 1.0 84 1

Sort (cost=12.61..12.81 rows=81 width=20) (actual time=0.137..0.141 rows=84 loops=1)

  • Sort Key: (date_trunc('minute'::text, ingest_time)), site_id
  • Sort Method: quicksort Memory: 31kB
  • Buffers: shared hit=5
108. 0.114 0.114 ↓ 1.0 84 1

Seq Scan on http_request_102033 http_request (cost=0.00..10.04 rows=81 width=20) (actual time=0.056..0.114 rows=84 loops=1)

  • Filter: (date_trunc('minute'::text, ingest_time) > (now() - '00:05:00'::interval))
  • Rows Removed by Filter: 180
  • Buffers: shared hit=5
109. 0.000 0.005 ↓ 0.0 0 1

Limit (cost=28.72..29.53 rows=15 width=52) (actual time=0.005..0.005 rows=0 loops=1)

110. 0.001 0.005 ↓ 0.0 0 1

GroupAggregate (cost=28.72..36.03 rows=136 width=52) (actual time=0.005..0.005 rows=0 loops=1)

  • Group Key: (date_trunc('minute'::text, ingest_time)), site_id
111. 0.001 0.004 ↓ 0.0 0 1

Sort (cost=28.72..29.19 rows=187 width=20) (actual time=0.004..0.004 rows=0 loops=1)

  • Sort Key: (date_trunc('minute'::text, ingest_time)), site_id
  • Sort Method: quicksort Memory: 25kB
112. 0.003 0.003 ↓ 0.0 0 1

Seq Scan on http_request_102034 http_request (cost=0.00..21.67 rows=187 width=20) (actual time=0.002..0.003 rows=0 loops=1)

  • Filter: (date_trunc('minute'::text, ingest_time) > (now() - '00:05:00'::interval))
113. 0.001 0.006 ↓ 0.0 0 1

Limit (cost=28.72..29.53 rows=15 width=52) (actual time=0.006..0.006 rows=0 loops=1)

114. 0.000 0.005 ↓ 0.0 0 1

GroupAggregate (cost=28.72..36.03 rows=136 width=52) (actual time=0.005..0.005 rows=0 loops=1)

  • Group Key: (date_trunc('minute'::text, ingest_time)), site_id
115. 0.002 0.005 ↓ 0.0 0 1

Sort (cost=28.72..29.19 rows=187 width=20) (actual time=0.005..0.005 rows=0 loops=1)

  • Sort Key: (date_trunc('minute'::text, ingest_time)), site_id
  • Sort Method: quicksort Memory: 25kB
116. 0.003 0.003 ↓ 0.0 0 1

Seq Scan on http_request_102035 http_request (cost=0.00..21.67 rows=187 width=20) (actual time=0.003..0.003 rows=0 loops=1)

  • Filter: (date_trunc('minute'::text, ingest_time) > (now() - '00:05:00'::interval))
117. 0.002 0.616 ↑ 1.0 15 1

Limit (cost=42.42..43.06 rows=15 width=52) (actual time=0.520..0.616 rows=15 loops=1)

  • Buffers: shared hit=14
118. 0.074 0.614 ↑ 18.4 15 1

GroupAggregate (cost=42.42..54.15 rows=276 width=52) (actual time=0.519..0.614 rows=15 loops=1)

  • Group Key: (date_trunc('minute'::text, ingest_time)), site_id
  • Buffers: shared hit=14
119. 0.085 0.540 ↑ 1.3 213 1

Sort (cost=42.42..43.11 rows=276 width=20) (actual time=0.513..0.540 rows=213 loops=1)

  • Sort Key: (date_trunc('minute'::text, ingest_time)), site_id
  • Sort Method: quicksort Memory: 41kB
  • Buffers: shared hit=14
120. 0.455 0.455 ↑ 1.3 213 1

Seq Scan on http_request_102036 http_request (cost=0.00..31.23 rows=276 width=20) (actual time=0.333..0.455 rows=213 loops=1)

  • Filter: (date_trunc('minute'::text, ingest_time) > (now() - '00:05:00'::interval))
  • Rows Removed by Filter: 589
  • Buffers: shared hit=14
121. 0.001 0.153 ↑ 3.0 5 1

Limit (cost=13.16..13.80 rows=15 width=52) (actual time=0.135..0.153 rows=5 loops=1)

  • Buffers: shared hit=5
122. 0.022 0.152 ↑ 17.2 5 1

GroupAggregate (cost=13.16..16.81 rows=86 width=52) (actual time=0.135..0.152 rows=5 loops=1)

  • Group Key: (date_trunc('minute'::text, ingest_time)), site_id
  • Buffers: shared hit=5
123. 0.026 0.130 ↑ 1.2 73 1

Sort (cost=13.16..13.37 rows=86 width=20) (actual time=0.126..0.130 rows=73 loops=1)

  • Sort Key: (date_trunc('minute'::text, ingest_time)), site_id
  • Sort Method: quicksort Memory: 30kB
  • Buffers: shared hit=5
124. 0.104 0.104 ↑ 1.2 73 1

Seq Scan on http_request_102037 http_request (cost=0.00..10.39 rows=86 width=20) (actual time=0.064..0.104 rows=73 loops=1)

  • Filter: (date_trunc('minute'::text, ingest_time) > (now() - '00:05:00'::interval))
  • Rows Removed by Filter: 207
  • Buffers: shared hit=5
125. 0.002 0.273 ↑ 1.0 15 1

Limit (cost=38.45..39.09 rows=15 width=52) (actual time=0.233..0.273 rows=15 loops=1)

  • Buffers: shared hit=13
126. 0.037 0.271 ↑ 16.6 15 1

GroupAggregate (cost=38.45..49.04 rows=249 width=52) (actual time=0.233..0.271 rows=15 loops=1)

  • Group Key: (date_trunc('minute'::text, ingest_time)), site_id
  • Buffers: shared hit=13
127. 0.044 0.234 ↑ 1.2 203 1

Sort (cost=38.45..39.08 rows=249 width=20) (actual time=0.225..0.234 rows=203 loops=1)

  • Sort Key: (date_trunc('minute'::text, ingest_time)), site_id
  • Sort Method: quicksort Memory: 40kB
  • Buffers: shared hit=13
128. 0.190 0.190 ↑ 1.2 203 1

Seq Scan on http_request_102038 http_request (cost=0.00..28.54 rows=249 width=20) (actual time=0.115..0.190 rows=203 loops=1)

  • Filter: (date_trunc('minute'::text, ingest_time) > (now() - '00:05:00'::interval))
  • Rows Removed by Filter: 581
  • Buffers: shared hit=13
129. 0.001 0.133 ↑ 3.0 5 1

Limit (cost=10.30..10.94 rows=15 width=52) (actual time=0.117..0.133 rows=5 loops=1)

  • Buffers: shared hit=4
130. 0.018 0.132 ↑ 13.6 5 1

GroupAggregate (cost=10.30..13.19 rows=68 width=52) (actual time=0.117..0.132 rows=5 loops=1)

  • Group Key: (date_trunc('minute'::text, ingest_time)), site_id
  • Buffers: shared hit=4
131. 0.017 0.114 ↑ 1.0 65 1

Sort (cost=10.30..10.47 rows=68 width=20) (actual time=0.110..0.114 rows=65 loops=1)

  • Sort Key: (date_trunc('minute'::text, ingest_time)), site_id
  • Sort Method: quicksort Memory: 30kB
  • Buffers: shared hit=4
132. 0.097 0.097 ↑ 1.0 65 1

Seq Scan on http_request_102039 http_request (cost=0.00..8.23 rows=68 width=20) (actual time=0.050..0.097 rows=65 loops=1)

  • Filter: (date_trunc('minute'::text, ingest_time) > (now() - '00:05:00'::interval))
  • Rows Removed by Filter: 180
  • Buffers: shared hit=4
Planning time : 2.145 ms
Execution time : 17.628 ms