explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Koap

Settings
# exclusive inclusive rows x rows loops node
1. 0.011 8.863 ↓ 0.0 1 1

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

2. 8.833 8.852 ↓ 0.0 32 1

Custom Scan (Citus Adaptive) (cost=0.00..0.00 rows=0 width=0) (actual time=8.849..8.852 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.007 0.019 ↑ 1.0 1 1

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

  • Buffers: shared hit=4
4. 0.012 0.012 ↑ 8.2 83 1

Seq Scan on http_request_1min_102040 http_request_1min (cost=0.00..16.80 rows=680 width=0) (actual time=0.005..0.012 rows=83 loops=1)

  • Buffers: shared hit=4
Planning time : 0.531 ms
Execution time : 8.890 ms