explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 5M38 : chnages_interval

Settings
# exclusive inclusive rows x rows loops node
1. 0.002 538.862 ↓ 0.0 0 1

Limit (cost=0.00..44.63 rows=1,000 width=104) (actual time=538.862..538.862 rows=0 loops=1)

  • Buffers: shared hit=2 read=184 dirtied=55
  • I/O Timings: read=534.663
2. 0.001 538.860 ↓ 0.0 0 1

Result (cost=0.00..315.15 rows=9,100 width=104) (actual time=538.860..538.860 rows=0 loops=1)

  • Buffers: shared hit=2 read=184 dirtied=55
  • I/O Timings: read=534.663
3. 0.638 538.859 ↓ 0.0 0 1

ProjectSet (cost=0.00..133.15 rows=9,100 width=72) (actual time=538.859..538.859 rows=0 loops=1)

  • Buffers: shared hit=2 read=184 dirtied=55
  • I/O Timings: read=534.663
4. 0.804 538.221 ↓ 27.0 2,453 1

Append (cost=0.00..86.74 rows=91 width=72) (actual time=207.490..538.221 rows=2,453 loops=1)

  • Buffers: shared hit=2 read=184 dirtied=55
  • I/O Timings: read=534.663
5. 0.021 0.021 ↓ 0.0 0 1

Seq Scan on changes b (cost=0.00..0.00 rows=1 width=72) (actual time=0.020..0.021 rows=0 loops=1)

  • Filter: ((endtime >= 1549178971) AND (endtime <= 1549265371))
6. 311.924 447.190 ↓ 24.5 1,544 1

Bitmap Heap Scan on changes_1549144800 b_1 (cost=2.03..59.31 rows=63 width=72) (actual time=207.467..447.190 rows=1,544 loops=1)

  • Recheck Cond: ((endtime >= 1549178971) AND (endtime <= 1549265371))
  • Heap Blocks: exact=117
  • Buffers: shared read=123
  • I/O Timings: read=445.801
7. 135.266 135.266 ↓ 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=135.265..135.266 rows=1,544 loops=1)

  • Index Cond: ((endtime >= 1549178971) AND (endtime <= 1549265371))
  • Buffers: shared read=6
  • I/O Timings: read=135.162
8. 90.130 90.206 ↓ 33.7 909 1

Bitmap Heap Scan on changes_1549231200 b_2 (cost=1.66..26.07 rows=27 width=72) (actual time=21.010..90.206 rows=909 loops=1)

  • Recheck Cond: ((endtime >= 1549178971) AND (endtime <= 1549265371))
  • Heap Blocks: exact=59
  • Buffers: shared hit=2 read=61 dirtied=55
  • I/O Timings: read=88.862
9. 0.076 0.076 ↓ 33.7 909 1

Bitmap Index Scan on route_changes_1549231200_endtime_idx (cost=0.00..1.65 rows=27 width=0) (actual time=0.075..0.076 rows=909 loops=1)

  • Index Cond: ((endtime >= 1549178971) AND (endtime <= 1549265371))
  • Buffers: shared hit=2 read=2
  • I/O Timings: read=0.012