explain.depesz.com

PostgreSQL's explain analyze made readable

Result: wGHX : blocking_analytics

Settings

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 0.078 111.896 ↑ 5.5 163 1

Limit (cost=0.01..105.56 rows=900 width=432) (actual time=38.048..111.896 rows=163 loops=1)

  • Buffers: shared hit=1 read=15 dirtied=4
  • I/O Timings: read=79.299
2. 31.610 111.818 ↑ 5.5 163 1

Nested Loop (cost=0.01..105.56 rows=900 width=432) (actual time=38.045..111.818 rows=163 loops=1)

  • Buffers: shared hit=1 read=15 dirtied=4
  • I/O Timings: read=79.299
3. 0.057 79.719 ↓ 18.1 163 1

Append (cost=0.00..11.05 rows=9 width=80) (actual time=8.352..79.719 rows=163 loops=1)

  • Buffers: shared hit=1 read=15 dirtied=4
  • I/O Timings: read=79.299
4. 0.021 0.021 ↓ 0.0 0 1

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

  • Filter: ((endtime >= 1549178971) AND (endtime <= 1549265371))
5. 69.110 69.135 ↓ 32.5 130 1

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

  • Recheck Cond: ((endtime >= 1549178971) AND (endtime <= 1549265371))
  • Heap Blocks: exact=10
  • Buffers: shared read=11
  • I/O Timings: read=68.875
6. 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 read=1
  • I/O Timings: read=0.006
7. 10.478 10.506 ↓ 8.2 33 1

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

  • Recheck Cond: ((endtime >= 1549178971) AND (endtime <= 1549265371))
  • Heap Blocks: exact=4
  • Buffers: shared hit=1 read=4 dirtied=4
  • I/O Timings: read=10.423
8. 0.028 0.028 ↓ 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.028..0.028 rows=33 loops=1)

  • Index Cond: ((endtime >= 1549178971) AND (endtime <= 1549265371))
  • Buffers: shared hit=1
9. 0.489 0.489 ↑ 100.0 1 163

Function Scan on jsonb_each esme (cost=0.01..1.00 rows=100 width=64) (actual time=0.003..0.003 rows=1 loops=163)