explain.depesz.com

PostgreSQL's explain analyze made readable

Result: OhTn

Settings
# exclusive inclusive rows x rows loops node
1. 0.003 11.290 ↓ 0.0 15 1

Limit (cost=0.00..0.00 rows=0 width=0) (actual time=11.288..11.290 rows=15 loops=1)

2. 0.035 11.287 ↓ 0.0 15 1

Sort (cost=0.00..0.00 rows=0 width=0) (actual time=11.287..11.287 rows=15 loops=1)

  • Sort Key: remote_scan.minute
  • Sort Method: top-N heapsort Memory: 26kB
3. 0.227 11.252 ↓ 0.0 141 1

HashAggregate (cost=0.00..0.00 rows=0 width=0) (actual time=11.115..11.252 rows=141 loops=1)

  • Group Key: remote_scan.minute, remote_scan.site_id
4. 10.715 11.025 ↓ 0.0 141 1

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

  • Task Count: 32
  • Tasks Shown: One of 32
  • -> Task
  • Node: host=10.0.0.230 port=5432 dbname=citus
5. 0.002 0.310 ↑ 1.7 9 1

Limit (cost=26.05..26.69 rows=15 width=52) (actual time=0.278..0.310 rows=9 loops=1)

  • Buffers: shared hit=9
6. 0.035 0.308 ↑ 19.0 9 1

GroupAggregate (cost=26.05..33.32 rows=171 width=52) (actual time=0.277..0.308 rows=9 loops=1)

  • Group Key: (date_trunc('minute'::text, ingest_time)), site_id
  • Buffers: shared hit=9
7. 0.046 0.273 ↑ 1.3 128 1

Sort (cost=26.05..26.48 rows=171 width=20) (actual time=0.266..0.273 rows=128 loops=1)

  • Sort Key: (date_trunc('minute'::text, ingest_time)), site_id
  • Sort Method: quicksort Memory: 35kB
  • Buffers: shared hit=9
8. 0.227 0.227 ↑ 1.3 128 1

Seq Scan on http_request_102008 http_request (cost=0.00..19.71 rows=171 width=20) (actual time=0.129..0.227 rows=128 loops=1)

  • Filter: (date_trunc('minute'::text, ingest_time) > (now() - '00:05:00'::interval))
  • Rows Removed by Filter: 421
  • Buffers: shared hit=9
Planning time : 1.690 ms
Execution time : 11.405 ms