explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Opii : rundata_interval

Settings
# exclusive inclusive rows x rows loops node
1. 0.692 4.499 ↑ 1.0 1 1

Aggregate (cost=242.05..242.06 rows=1 width=16) (actual time=4.499..4.499 rows=1 loops=1)

  • Buffers: shared hit=1592
2. 0.823 3.807 ↓ 1.0 2,878 1

Limit (cost=0.00..199.98 rows=2,805 width=192) (actual time=0.030..3.807 rows=2,878 loops=1)

  • Buffers: shared hit=1592
3. 0.966 2.984 ↓ 1.0 2,878 1

Result (cost=0.00..199.98 rows=2,805 width=192) (actual time=0.029..2.984 rows=2,878 loops=1)

  • Buffers: shared hit=1592
4. 0.831 2.018 ↓ 1.0 2,878 1

Append (cost=0.00..171.93 rows=2,805 width=8) (actual time=0.027..2.018 rows=2,878 loops=1)

  • Buffers: shared hit=1592
5. 0.013 0.013 ↓ 0.0 0 1

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

  • Filter: ((endtime >= 1549443562) AND (endtime <= 1549529962))
6. 0.721 0.721 ↑ 1.0 1,559 1

Index Only Scan using route_rundata_1549404000_endtime_idx on rundata_1549404000 (cost=0.28..93.23 rows=1,559 width=8) (actual time=0.013..0.721 rows=1,559 loops=1)

  • Index Cond: ((endtime >= 1549443562) AND (endtime <= 1549529962))
  • Heap Fetches: 1559
  • Buffers: shared hit=1546
7. 0.453 0.453 ↓ 1.1 1,319 1

Seq Scan on rundata_1549490400 (cost=0.00..64.67 rows=1,245 width=8) (actual time=0.006..0.453 rows=1,319 loops=1)

  • Filter: ((endtime >= 1549443562) AND (endtime <= 1549529962))
  • Rows Removed by Filter: 13
  • Buffers: shared hit=46