explain.depesz.com

PostgreSQL's explain analyze made readable

Result: MNC2

Settings
# exclusive inclusive rows x rows loops node
1. 0.012 9.604 ↓ 0.0 1 1

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

2. 9.160 9.592 ↓ 0.0 32 1

Custom Scan (Citus Adaptive) (cost=0.00..0.00 rows=0 width=0) (actual time=9.590..9.592 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.192 0.432 ↑ 1.0 1 1

Aggregate (cost=74.24..74.25 rows=1 width=8) (actual time=0.432..0.432 rows=1 loops=1)

  • Buffers: shared hit=42
4. 0.240 0.240 ↑ 1.0 2,564 1

Seq Scan on http_request_102008 http_request (cost=0.00..67.79 rows=2,579 width=0) (actual time=0.008..0.240 rows=2,564 loops=1)

  • Buffers: shared hit=42
Planning time : 0.571 ms
Execution time : 9.631 ms