explain.depesz.com

PostgreSQL's explain analyze made readable

Result: yyT3

Settings
# exclusive inclusive rows x rows loops node
1. 0.723 0.752 ↓ 0.0 1 1

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

  • Task Count: 1
  • Tasks Shown: All
  • -> Task
  • Node: host=10.0.0.230 port=5432 dbname=citus
2. 0.005 0.029 ↑ 1.0 1 1

Aggregate (cost=7.54..7.55 rows=1 width=8) (actual time=0.029..0.029 rows=1 loops=1)

  • Buffers: shared hit=6
3. 0.024 0.024 ↓ 1.2 44 1

Seq Scan on http_request_1min_102070 http_request_1min (cost=0.00..7.45 rows=38 width=0) (actual time=0.015..0.024 rows=44 loops=1)

  • Filter: (site_id = 29)
  • Rows Removed by Filter: 92
  • Buffers: shared hit=6
Planning time : 0.058 ms
Execution time : 0.765 ms