explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 5gs1p

Settings
# exclusive inclusive rows x rows loops node
1. 0.022 18.909 ↓ 0.0 1 1

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

2. 15.984 18.887 ↓ 0.0 32 1

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

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

Aggregate (cost=324.82..324.83 rows=1 width=8) (actual time=2.903..2.903 rows=1 loops=1)

  • Buffers: shared hit=185
4. 1.758 1.758 ↑ 1.0 11,165 1

Seq Scan on http_request_102008 http_request (cost=0.00..296.86 rows=11,186 width=0) (actual time=0.008..1.758 rows=11,165 loops=1)

  • Buffers: shared hit=185
Planning time : 0.496 ms
Execution time : 18.932 ms