explain.depesz.com

PostgreSQL's explain analyze made readable

Result: MKPo : rundata_analytics

Settings

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 0.344 5.002 ↓ 15.6 1,000 1

Limit (cost=0.00..65.33 rows=64 width=192) (actual time=0.141..5.002 rows=1,000 loops=1)

  • Buffers: shared hit=40
2. 3.806 4.658 ↓ 15.6 1,000 1

Result (cost=0.00..65.33 rows=64 width=192) (actual time=0.139..4.658 rows=1,000 loops=1)

  • Buffers: shared hit=40
3. 0.318 0.852 ↓ 15.6 1,000 1

Append (cost=0.00..61.01 rows=64 width=80) (actual time=0.113..0.852 rows=1,000 loops=1)

  • Buffers: shared hit=40
4. 0.017 0.017 ↓ 0.0 0 1

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

  • Filter: ((endtime >= 1549178971) AND (endtime <= 1549265371))
5. 0.433 0.517 ↓ 27.8 1,000 1

Bitmap Heap Scan on rundata_1549144800 (cost=1.75..34.64 rows=36 width=80) (actual time=0.094..0.517 rows=1,000 loops=1)

  • Recheck Cond: ((endtime >= 1549178971) AND (endtime <= 1549265371))
  • Heap Blocks: exact=34
  • Buffers: shared hit=40
6. 0.084 0.084 ↓ 48.3 1,740 1

Bitmap Index Scan on route_rundata_1549144800_endtime_idx (cost=0.00..1.74 rows=36 width=0) (actual time=0.084..0.084 rows=1,740 loops=1)

  • Index Cond: ((endtime >= 1549178971) AND (endtime <= 1549265371))
  • Buffers: shared hit=6
7. 0.000 0.000 ↓ 0.0 0

Bitmap Heap Scan on rundata_1549231200 (cost=1.66..26.06 rows=27 width=80) (never executed)

  • Recheck Cond: ((endtime >= 1549178971) AND (endtime <= 1549265371))
8. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on route_rundata_1549231200_endtime_idx (cost=0.00..1.65 rows=27 width=0) (never executed)

  • Index Cond: ((endtime >= 1549178971) AND (endtime <= 1549265371))