explain.depesz.com

PostgreSQL's explain analyze made readable

Result: w1oi : Optimization for: rundata_analytics; plan #u7yU

Settings

Optimization path:

# exclusive inclusive rows x rows loops node
1. 0.022 22.676 ↑ 1.0 1 1

Aggregate (cost=7.37..7.38 rows=1 width=16) (actual time=22.676..22.676 rows=1 loops=1)

  • Buffers: shared hit=58 read=4
  • I/O Timings: read=22.491
2. 0.019 22.654 ↑ 1.1 60 1

Limit (cost=0.00..6.33 rows=69 width=8) (actual time=22.204..22.654 rows=60 loops=1)

  • Buffers: shared hit=58 read=4
  • I/O Timings: read=22.491
3. 0.021 22.635 ↑ 1.1 60 1

Append (cost=0.00..6.33 rows=69 width=8) (actual time=22.202..22.635 rows=60 loops=1)

  • Buffers: shared hit=58 read=4
  • I/O Timings: read=22.491
4. 0.012 0.012 ↓ 0.0 0 1

Seq Scan on rundata (cost=0.00..0.00 rows=1 width=8) (actual time=0.012..0.012 rows=0 loops=1)

  • Filter: ((endtime >= 1549362337) AND (endtime <= 1549364137))
5. 22.602 22.602 ↑ 1.1 60 1

Index Only Scan using route_rundata_1549317600_endtime_idx on rundata_1549317600 (cost=0.28..5.99 rows=68 width=8) (actual time=22.187..22.602 rows=60 loops=1)

  • Index Cond: ((endtime >= 1549362337) AND (endtime <= 1549364137))
  • Heap Fetches: 60
  • Buffers: shared hit=58 read=4
  • I/O Timings: read=22.491