explain.depesz.com

PostgreSQL's explain analyze made readable

Result: lal : base_blocking

Settings
# exclusive inclusive rows x rows loops node
1. 0.091 5.634 ↑ 5.5 163 1

Limit (cost=0.00..177.73 rows=900 width=432) (actual time=0.202..5.634 rows=163 loops=1)

  • Buffers: shared hit=16
2. 1.762 5.543 ↑ 5.5 163 1

Subquery Scan on v (cost=0.00..177.73 rows=900 width=432) (actual time=0.200..5.543 rows=163 loops=1)

  • Buffers: shared hit=16
3. 2.773 3.781 ↑ 5.5 163 1

Result (cost=0.00..96.73 rows=900 width=400) (actual time=0.163..3.781 rows=163 loops=1)

  • Buffers: shared hit=16
4. 0.721 1.008 ↑ 5.5 163 1

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

  • Buffers: shared hit=16
5. 0.065 0.287 ↓ 18.1 163 1

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

  • Buffers: shared hit=16
6. 0.022 0.022 ↓ 0.0 0 1

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

  • Filter: ((endtime >= 1549178971) AND (endtime <= 1549265371))
7. 0.125 0.150 ↓ 32.5 130 1

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

  • Recheck Cond: ((endtime >= 1549178971) AND (endtime <= 1549265371))
  • Heap Blocks: exact=10
  • Buffers: shared hit=11
8. 0.025 0.025 ↓ 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.025..0.025 rows=130 loops=1)

  • Index Cond: ((endtime >= 1549178971) AND (endtime <= 1549265371))
  • Buffers: shared hit=1
9. 0.037 0.050 ↓ 8.2 33 1

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

  • Recheck Cond: ((endtime >= 1549178971) AND (endtime <= 1549265371))
  • Heap Blocks: exact=4
  • Buffers: shared hit=5
10. 0.013 0.013 ↓ 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.013..0.013 rows=33 loops=1)

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