explain.depesz.com

PostgreSQL's explain analyze made readable

Result: qpLR : rundata_analytics2

Settings
# exclusive inclusive rows x rows loops node
1. 0.026 0.215 ↑ 1.0 1 1

Aggregate (cost=8.06..8.07 rows=1 width=16) (actual time=0.214..0.215 rows=1 loops=1)

  • Buffers: shared hit=62
2. 0.028 0.189 ↑ 1.1 60 1

Limit (cost=0.00..7.02 rows=69 width=192) (actual time=0.052..0.189 rows=60 loops=1)

  • Buffers: shared hit=62
3. 0.033 0.161 ↑ 1.1 60 1

Result (cost=0.00..7.02 rows=69 width=192) (actual time=0.050..0.161 rows=60 loops=1)

  • Buffers: shared hit=62
4. 0.029 0.128 ↑ 1.1 60 1

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

  • Buffers: shared hit=62
5. 0.028 0.028 ↓ 0.0 0 1

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

  • Filter: ((endtime >= 1549362337) AND (endtime <= 1549364137))
6. 0.071 0.071 ↑ 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=0.019..0.071 rows=60 loops=1)

  • Index Cond: ((endtime >= 1549362337) AND (endtime <= 1549364137))
  • Heap Fetches: 60
  • Buffers: shared hit=62