explain.depesz.com

PostgreSQL's explain analyze made readable

Result: GIq5

Settings
# exclusive inclusive rows x rows loops node
1. 0.003 6.618 ↓ 0.0 5 1

Limit (cost=0.00..0.00 rows=0 width=0) (actual time=6.616..6.618 rows=5 loops=1)

2. 6.279 6.615 ↓ 0.0 5 1

Custom Scan (Citus Adaptive) (cost=0.00..0.00 rows=0 width=0) (actual time=6.615..6.615 rows=5 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
3. 0.000 0.009 ↓ 0.0 0 1

Limit (cost=0.00..1.46 rows=15 width=36) (actual time=0.009..0.009 rows=0 loops=1)

  • Buffers: shared hit=1
4. 0.009 0.009 ↓ 0.0 0 1

Seq Scan on http_request_1min_102040 http_request_1min (cost=0.00..29.94 rows=307 width=36) (actual time=0.009..0.009 rows=0 loops=1)

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

Limit (cost=0.00..1.46 rows=15 width=36) (actual time=0.011..0.011 rows=0 loops=1)

  • Buffers: shared hit=1
6. 0.011 0.011 ↓ 0.0 0 1

Seq Scan on http_request_1min_102041 http_request_1min (cost=0.00..29.94 rows=307 width=36) (actual time=0.011..0.011 rows=0 loops=1)

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

Limit (cost=0.00..1.46 rows=15 width=36) (actual time=0.008..0.008 rows=0 loops=1)

  • Buffers: shared hit=1
8. 0.007 0.007 ↓ 0.0 0 1

Seq Scan on http_request_1min_102042 http_request_1min (cost=0.00..29.94 rows=307 width=36) (actual time=0.007..0.007 rows=0 loops=1)

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

Limit (cost=0.00..1.46 rows=15 width=36) (actual time=0.011..0.011 rows=0 loops=1)

  • Buffers: shared hit=1
10. 0.010 0.010 ↓ 0.0 0 1

Seq Scan on http_request_1min_102043 http_request_1min (cost=0.00..29.94 rows=307 width=36) (actual time=0.010..0.010 rows=0 loops=1)

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

Limit (cost=0.00..1.46 rows=15 width=36) (actual time=0.027..0.027 rows=0 loops=1)

  • Buffers: shared hit=1
12. 0.026 0.026 ↓ 0.0 0 1

Seq Scan on http_request_1min_102044 http_request_1min (cost=0.00..29.94 rows=307 width=36) (actual time=0.026..0.026 rows=0 loops=1)

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

Limit (cost=0.00..1.46 rows=15 width=36) (actual time=0.004..0.004 rows=0 loops=1)

14. 0.003 0.003 ↓ 0.0 0 1

Seq Scan on http_request_1min_102045 http_request_1min (cost=0.00..29.94 rows=307 width=36) (actual time=0.003..0.003 rows=0 loops=1)

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

Limit (cost=0.00..1.46 rows=15 width=36) (actual time=0.008..0.008 rows=0 loops=1)

  • Buffers: shared hit=1
16. 0.007 0.007 ↓ 0.0 0 1

Seq Scan on http_request_1min_102046 http_request_1min (cost=0.00..29.94 rows=307 width=36) (actual time=0.007..0.007 rows=0 loops=1)

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

Limit (cost=0.00..1.46 rows=15 width=36) (actual time=0.005..0.005 rows=0 loops=1)

18. 0.005 0.005 ↓ 0.0 0 1

Seq Scan on http_request_1min_102047 http_request_1min (cost=0.00..29.94 rows=307 width=36) (actual time=0.004..0.005 rows=0 loops=1)

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

Limit (cost=0.00..1.46 rows=15 width=36) (actual time=0.010..0.010 rows=0 loops=1)

  • Buffers: shared hit=1
20. 0.010 0.010 ↓ 0.0 0 1

Seq Scan on http_request_1min_102048 http_request_1min (cost=0.00..29.94 rows=307 width=36) (actual time=0.010..0.010 rows=0 loops=1)

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

Limit (cost=0.00..1.46 rows=15 width=36) (actual time=0.011..0.011 rows=0 loops=1)

  • Buffers: shared hit=1
22. 0.010 0.010 ↓ 0.0 0 1

Seq Scan on http_request_1min_102049 http_request_1min (cost=0.00..29.94 rows=307 width=36) (actual time=0.010..0.010 rows=0 loops=1)

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

Limit (cost=0.00..1.46 rows=15 width=36) (actual time=0.016..0.016 rows=0 loops=1)

  • Buffers: shared hit=1
24. 0.010 0.010 ↓ 0.0 0 1

Seq Scan on http_request_1min_102050 http_request_1min (cost=0.00..29.94 rows=307 width=36) (actual time=0.010..0.010 rows=0 loops=1)

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

Limit (cost=0.00..1.46 rows=15 width=36) (actual time=0.004..0.004 rows=0 loops=1)

26. 0.004 0.004 ↓ 0.0 0 1

Seq Scan on http_request_1min_102051 http_request_1min (cost=0.00..29.94 rows=307 width=36) (actual time=0.003..0.004 rows=0 loops=1)

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

Limit (cost=0.00..1.46 rows=15 width=36) (actual time=0.003..0.003 rows=0 loops=1)

28. 0.003 0.003 ↓ 0.0 0 1

Seq Scan on http_request_1min_102052 http_request_1min (cost=0.00..29.94 rows=307 width=36) (actual time=0.003..0.003 rows=0 loops=1)

  • Filter: (ingest_time > (date_trunc('minute'::text, now()) - '00:05:00'::interval))
29. 0.001 0.016 ↑ 5.0 3 1

Limit (cost=0.00..1.46 rows=15 width=36) (actual time=0.014..0.016 rows=3 loops=1)

  • Buffers: shared hit=1
30. 0.015 0.015 ↑ 102.3 3 1

Seq Scan on http_request_1min_102053 http_request_1min (cost=0.00..29.94 rows=307 width=36) (actual time=0.013..0.015 rows=3 loops=1)

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

Limit (cost=0.00..1.46 rows=15 width=36) (actual time=0.003..0.003 rows=0 loops=1)

32. 0.003 0.003 ↓ 0.0 0 1

Seq Scan on http_request_1min_102054 http_request_1min (cost=0.00..29.94 rows=307 width=36) (actual time=0.003..0.003 rows=0 loops=1)

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

Limit (cost=0.00..1.46 rows=15 width=36) (actual time=0.010..0.010 rows=0 loops=1)

  • Buffers: shared hit=1
34. 0.010 0.010 ↓ 0.0 0 1

Seq Scan on http_request_1min_102055 http_request_1min (cost=0.00..29.94 rows=307 width=36) (actual time=0.010..0.010 rows=0 loops=1)

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

Limit (cost=0.00..1.46 rows=15 width=36) (actual time=0.003..0.003 rows=0 loops=1)

36. 0.003 0.003 ↓ 0.0 0 1

Seq Scan on http_request_1min_102056 http_request_1min (cost=0.00..29.94 rows=307 width=36) (actual time=0.003..0.003 rows=0 loops=1)

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

Limit (cost=0.00..1.46 rows=15 width=36) (actual time=0.006..0.006 rows=0 loops=1)

38. 0.005 0.005 ↓ 0.0 0 1

Seq Scan on http_request_1min_102057 http_request_1min (cost=0.00..29.94 rows=307 width=36) (actual time=0.005..0.005 rows=0 loops=1)

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

Limit (cost=0.00..1.46 rows=15 width=36) (actual time=0.003..0.003 rows=0 loops=1)

40. 0.003 0.003 ↓ 0.0 0 1

Seq Scan on http_request_1min_102058 http_request_1min (cost=0.00..29.94 rows=307 width=36) (actual time=0.003..0.003 rows=0 loops=1)

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

Limit (cost=0.00..1.46 rows=15 width=36) (actual time=0.011..0.011 rows=0 loops=1)

  • Buffers: shared hit=1
42. 0.010 0.010 ↓ 0.0 0 1

Seq Scan on http_request_1min_102059 http_request_1min (cost=0.00..29.94 rows=307 width=36) (actual time=0.010..0.010 rows=0 loops=1)

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

Limit (cost=0.00..1.46 rows=15 width=36) (actual time=0.034..0.034 rows=0 loops=1)

  • Buffers: shared hit=1
44. 0.034 0.034 ↓ 0.0 0 1

Seq Scan on http_request_1min_102060 http_request_1min (cost=0.00..29.94 rows=307 width=36) (actual time=0.034..0.034 rows=0 loops=1)

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

Limit (cost=0.00..1.46 rows=15 width=36) (actual time=0.012..0.013 rows=1 loops=1)

  • Buffers: shared hit=1
46. 0.012 0.012 ↑ 307.0 1 1

Seq Scan on http_request_1min_102061 http_request_1min (cost=0.00..29.94 rows=307 width=36) (actual time=0.012..0.012 rows=1 loops=1)

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

Limit (cost=0.00..1.46 rows=15 width=36) (actual time=0.003..0.003 rows=0 loops=1)

48. 0.003 0.003 ↓ 0.0 0 1

Seq Scan on http_request_1min_102062 http_request_1min (cost=0.00..29.94 rows=307 width=36) (actual time=0.003..0.003 rows=0 loops=1)

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

Limit (cost=0.00..1.46 rows=15 width=36) (actual time=0.011..0.011 rows=0 loops=1)

  • Buffers: shared hit=1
50. 0.010 0.010 ↓ 0.0 0 1

Seq Scan on http_request_1min_102063 http_request_1min (cost=0.00..29.94 rows=307 width=36) (actual time=0.010..0.010 rows=0 loops=1)

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

Limit (cost=0.00..1.46 rows=15 width=36) (actual time=0.008..0.008 rows=0 loops=1)

  • Buffers: shared hit=1
52. 0.008 0.008 ↓ 0.0 0 1

Seq Scan on http_request_1min_102064 http_request_1min (cost=0.00..29.94 rows=307 width=36) (actual time=0.007..0.008 rows=0 loops=1)

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

Limit (cost=0.00..1.46 rows=15 width=36) (actual time=0.010..0.010 rows=0 loops=1)

  • Buffers: shared hit=1
54. 0.009 0.009 ↓ 0.0 0 1

Seq Scan on http_request_1min_102065 http_request_1min (cost=0.00..29.94 rows=307 width=36) (actual time=0.009..0.009 rows=0 loops=1)

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

Limit (cost=0.00..1.46 rows=15 width=36) (actual time=0.003..0.003 rows=0 loops=1)

56. 0.003 0.003 ↓ 0.0 0 1

Seq Scan on http_request_1min_102066 http_request_1min (cost=0.00..29.94 rows=307 width=36) (actual time=0.003..0.003 rows=0 loops=1)

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

Limit (cost=0.00..1.46 rows=15 width=36) (actual time=0.004..0.004 rows=0 loops=1)

58. 0.004 0.004 ↓ 0.0 0 1

Seq Scan on http_request_1min_102067 http_request_1min (cost=0.00..29.94 rows=307 width=36) (actual time=0.004..0.004 rows=0 loops=1)

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

Limit (cost=0.00..1.46 rows=15 width=36) (actual time=0.010..0.010 rows=0 loops=1)

  • Buffers: shared hit=1
60. 0.009 0.009 ↓ 0.0 0 1

Seq Scan on http_request_1min_102068 http_request_1min (cost=0.00..29.94 rows=307 width=36) (actual time=0.009..0.009 rows=0 loops=1)

  • Filter: (ingest_time > (date_trunc('minute'::text, now()) - '00:05:00'::interval))
  • Rows Removed by Filter: 15
  • Buffers: shared hit=1
61. 0.001 0.038 ↑ 15.0 1 1

Limit (cost=0.00..1.46 rows=15 width=36) (actual time=0.037..0.038 rows=1 loops=1)

  • Buffers: shared hit=1
62. 0.037 0.037 ↑ 307.0 1 1

Seq Scan on http_request_1min_102069 http_request_1min (cost=0.00..29.94 rows=307 width=36) (actual time=0.036..0.037 rows=1 loops=1)

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

Limit (cost=0.00..1.46 rows=15 width=36) (actual time=0.013..0.013 rows=0 loops=1)

  • Buffers: shared hit=1
64. 0.013 0.013 ↓ 0.0 0 1

Seq Scan on http_request_1min_102070 http_request_1min (cost=0.00..29.94 rows=307 width=36) (actual time=0.013..0.013 rows=0 loops=1)

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

Limit (cost=0.00..1.46 rows=15 width=36) (actual time=0.010..0.010 rows=0 loops=1)

  • Buffers: shared hit=1
66. 0.009 0.009 ↓ 0.0 0 1

Seq Scan on http_request_1min_102071 http_request_1min (cost=0.00..29.94 rows=307 width=36) (actual time=0.009..0.009 rows=0 loops=1)

  • Filter: (ingest_time > (date_trunc('minute'::text, now()) - '00:05:00'::interval))
  • Rows Removed by Filter: 5
  • Buffers: shared hit=1
Planning time : 1.144 ms
Execution time : 6.638 ms