explain.depesz.com

PostgreSQL's explain analyze made readable

Result: mqDO : rundata_base

Settings
# exclusive inclusive rows x rows loops node
1. 0.644 90.087 ↓ 15.6 1,000 1

Limit (cost=0.00..67.73 rows=64 width=192) (actual time=51.824..90.087 rows=1,000 loops=1)

  • Buffers: shared hit=10 read=30
  • I/O Timings: read=75.863
2. 11.948 89.443 ↓ 15.6 1,000 1

Result (cost=0.00..67.73 rows=64 width=192) (actual time=51.822..89.443 rows=1,000 loops=1)

  • Buffers: shared hit=10 read=30
  • I/O Timings: read=75.863
3. 0.482 77.495 ↓ 15.6 1,000 1

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

  • Buffers: shared hit=10 read=30
  • I/O Timings: read=75.863
4. 0.012 0.012 ↓ 0.0 0 1

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

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

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

  • Recheck Cond: ((endtime >= 1549178971) AND (endtime <= 1549265371))
  • Heap Blocks: exact=34
  • Buffers: shared hit=10 read=30
  • I/O Timings: read=75.863
6. 47.637 47.637 ↓ 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=47.637..47.637 rows=1,740 loops=1)

  • Index Cond: ((endtime >= 1549178971) AND (endtime <= 1549265371))
  • Buffers: shared hit=4 read=2
  • I/O Timings: read=47.517
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))