explain.depesz.com

PostgreSQL's explain analyze made readable

Result: mTKZ

Settings
# exclusive inclusive rows x rows loops node
1. 0.341 3.407 ↓ 0.0 1 1

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

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

Aggregate (cost=702.89..702.90 rows=1 width=8) (actual time=3.066..3.066 rows=1 loops=1)

  • Buffers: shared hit=388
3. 2.439 2.439 ↓ 1.0 7,849 1

Seq Scan on http_request_102038 http_request (cost=0.00..683.29 rows=7,842 width=0) (actual time=0.007..2.439 rows=7,849 loops=1)

  • Filter: (site_id = 29)
  • Rows Removed by Filter: 15790
  • Buffers: shared hit=388
Planning time : 0.058 ms
Execution time : 3.420 ms