explain.depesz.com

PostgreSQL's explain analyze made readable

Result: oCcq : blocking_analytics2

Settings
# exclusive inclusive rows x rows loops node
1. 0.073 2.790 ↑ 5.5 163 1

Limit (cost=0.00..150.73 rows=900 width=432) (actual time=0.102..2.790 rows=163 loops=1)

  • Buffers: shared hit=16
2. 1.715 2.717 ↑ 5.5 163 1

Result (cost=0.00..141.73 rows=900 width=432) (actual time=0.101..2.717 rows=163 loops=1)

  • Buffers: shared hit=16
3. 0.791 1.002 ↑ 5.5 163 1

ProjectSet (cost=0.00..15.73 rows=900 width=112) (actual time=0.056..1.002 rows=163 loops=1)

  • Buffers: shared hit=16
4. 0.055 0.211 ↓ 18.1 163 1

Append (cost=0.00..11.14 rows=9 width=80) (actual time=0.042..0.211 rows=163 loops=1)

  • Buffers: shared hit=16
5. 0.020 0.020 ↓ 0.0 0 1

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

  • Filter: ((endtime >= 1549178971) AND (endtime <= 1549265371))
6. 0.088 0.102 ↓ 32.5 130 1

Bitmap Heap Scan on blocking_1549144800 (cost=1.29..5.51 rows=4 width=80) (actual time=0.021..0.102 rows=130 loops=1)

  • Recheck Cond: ((endtime >= 1549178971) AND (endtime <= 1549265371))
  • Heap Blocks: exact=10
  • Buffers: shared hit=11
7. 0.014 0.014 ↓ 32.5 130 1

Bitmap Index Scan on route_blocking_1549144800_endtime_idx (cost=0.00..1.29 rows=4 width=0) (actual time=0.013..0.014 rows=130 loops=1)

  • Index Cond: ((endtime >= 1549178971) AND (endtime <= 1549265371))
  • Buffers: shared hit=1
8. 0.026 0.034 ↓ 8.2 33 1

Bitmap Heap Scan on blocking_1549231200 (cost=1.29..5.50 rows=4 width=80) (actual time=0.014..0.034 rows=33 loops=1)

  • Recheck Cond: ((endtime >= 1549178971) AND (endtime <= 1549265371))
  • Heap Blocks: exact=4
  • Buffers: shared hit=5
9. 0.008 0.008 ↓ 8.2 33 1

Bitmap Index Scan on route_blocking_1549231200_endtime_idx (cost=0.00..1.29 rows=4 width=0) (actual time=0.008..0.008 rows=33 loops=1)

  • Index Cond: ((endtime >= 1549178971) AND (endtime <= 1549265371))
  • Buffers: shared hit=1