explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 3Bys : plain_changes

Settings
# exclusive inclusive rows x rows loops node
1. 0.320 121.530 ↓ 11.0 1,000 1

Limit (cost=0.00..85.83 rows=91 width=80) (actual time=62.342..121.530 rows=1,000 loops=1)

  • Buffers: shared hit=1 read=82
  • I/O Timings: read=119.860
2. 0.320 121.210 ↓ 11.0 1,000 1

Append (cost=0.00..85.83 rows=91 width=80) (actual time=62.340..121.210 rows=1,000 loops=1)

  • Buffers: shared hit=1 read=82
  • I/O Timings: read=119.860
3. 0.017 0.017 ↓ 0.0 0 1

Seq Scan on changes (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))
4. 68.244 120.873 ↓ 15.9 1,000 1

Bitmap Heap Scan on changes_1549144800 (cost=2.03..59.31 rows=63 width=80) (actual time=62.322..120.873 rows=1,000 loops=1)

  • Recheck Cond: ((endtime >= 1549178971) AND (endtime <= 1549265371))
  • Heap Blocks: exact=77
  • Buffers: shared hit=1 read=82
  • I/O Timings: read=119.860
5. 52.629 52.629 ↓ 24.5 1,544 1

Bitmap Index Scan on route_changes_1549144800_endtime_idx (cost=0.00..2.01 rows=63 width=0) (actual time=52.629..52.629 rows=1,544 loops=1)

  • Index Cond: ((endtime >= 1549178971) AND (endtime <= 1549265371))
  • Buffers: shared hit=1 read=5
  • I/O Timings: read=52.520
6. 0.000 0.000 ↓ 0.0 0

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

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

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

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