explain.depesz.com

PostgreSQL's explain analyze made readable

Result: sC8P

Settings
# exclusive inclusive rows x rows loops node
1. 0.010 5.617 ↓ 0.0 1 1

Aggregate (cost=0.00..0.00 rows=0 width=0) (actual time=5.617..5.617 rows=1 loops=1)

2. 5.586 5.607 ↓ 0.0 32 1

Custom Scan (Citus Adaptive) (cost=0.00..0.00 rows=0 width=0) (actual time=5.604..5.607 rows=32 loops=1)

  • Task Count: 32
  • Tasks Shown: One of 32
  • -> Task
  • Node: host=10.0.0.230 port=5432 dbname=citus
3. 0.008 0.021 ↑ 1.0 1 1

Aggregate (cost=18.50..18.51 rows=1 width=8) (actual time=0.021..0.021 rows=1 loops=1)

  • Buffers: shared hit=4
4. 0.013 0.013 ↑ 8.8 77 1

Seq Scan on http_request_1min_102040 http_request_1min (cost=0.00..16.80 rows=680 width=0) (actual time=0.006..0.013 rows=77 loops=1)

  • Buffers: shared hit=4
Planning time : 0.693 ms
Execution time : 5.641 ms