explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 2JIs

Settings
# exclusive inclusive rows x rows loops node
1. 0.004 7.461 ↓ 0.0 15 1

Limit (cost=0.00..0.00 rows=0 width=0) (actual time=7.458..7.461 rows=15 loops=1)

2. 7.444 7.457 ↓ 0.0 15 1

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

  • Task Count: 32
  • Tasks Shown: One of 32
  • -> Task
  • Node: host=10.0.0.230 port=5432 dbname=citus
3. 0.001 0.013 ↑ 7.5 2 1

Limit (cost=0.00..1.67 rows=15 width=20) (actual time=0.012..0.013 rows=2 loops=1)

  • Buffers: shared hit=1
4. 0.012 0.012 ↑ 113.5 2 1

Seq Scan on http_request_1min_102040 http_request_1min (cost=0.00..25.30 rows=227 width=20) (actual time=0.011..0.012 rows=2 loops=1)

  • Filter: (ingest_time > (date_trunc('minute'::text, now()) - '00:05:00'::interval))
  • Rows Removed by Filter: 11
  • Buffers: shared hit=1
Planning time : 0.904 ms
Execution time : 7.479 ms