Postgrest Multi-Version Latency Testing (20 concurrent requests)

postgrest-single_table_selects.md

Postgrest 0.3.2: -H "Prefer: plurality=singular" "http://127.0.0.1:3000/numbers?telephone_number=eq.%2B442099123456"

Summary:
  Total:        6.6562 secs
  Slowest:      0.1074 secs
  Fastest:      0.0021 secs
  Average:      0.0265 secs
  Requests/sec: 751.1826

Response time histogram:
  0.002 [1]     |
  0.013 [55]    |∎
  0.023 [1814]  |∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎
  0.034 [2427]  |∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎
  0.044 [582]   |∎∎∎∎∎∎∎∎∎∎
  0.055 [84]    |∎
  0.065 [17]    |
  0.076 [0]     |
  0.086 [5]     |
  0.097 [6]     |
  0.107 [9]     |

Latency distribution:
  10% in 0.0186 secs
  25% in 0.0214 secs
  50% in 0.0252 secs
  75% in 0.0299 secs
  90% in 0.0360 secs
  95% in 0.0404 secs
  99% in 0.0489 secs

Details (average, fastest, slowest):
  DNS+dialup:	 0.0000 secs, 0.0000 secs, 0.0086 secs
  DNS-lookup:	 0.0000 secs, 0.0000 secs, 0.0000 secs
  req write:	 0.0001 secs, 0.0000 secs, 0.0097 secs
  resp wait:	 0.0260 secs, 0.0019 secs, 0.1031 secs
  resp read:	 0.0003 secs, 0.0001 secs, 0.0072 secs

Postgrest 0.4.0: -H "Accept: application/vnd.pgrst.object+json" "http://127.0.0.1:3000/numbers?telephone_number=eq.%2B442099123456"

Summary:
  Total:        6.8922 secs
  Slowest:      0.1446 secs
  Fastest:      0.0027 secs
  Average:      0.0274 secs
  Requests/sec: 725.4534

Response time histogram:
  0.003 [1]     |
  0.017 [217]   |∎∎
  0.031 [3519]  |∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎
  0.045 [1143]  |∎∎∎∎∎∎∎∎∎∎∎∎∎
  0.059 [99]    |∎
  0.074 [5]     |
  0.088 [3]     |
  0.102 [1]     |
  0.116 [1]     |
  0.130 [6]     |
  0.145 [5]     |

Latency distribution:
  10% in 0.0191 secs
  25% in 0.0221 secs
  50% in 0.0261 secs
  75% in 0.0312 secs
  90% in 0.0372 secs
  95% in 0.0412 secs
  99% in 0.0515 secs

Details (average, fastest, slowest):
  DNS+dialup:	 0.0000 secs, 0.0000 secs, 0.0105 secs
  DNS-lookup:	 0.0000 secs, 0.0000 secs, 0.0000 secs
  req write:	 0.0000 secs, 0.0000 secs, 0.0039 secs
  resp wait:	 0.0272 secs, 0.0026 secs, 0.1434 secs
  resp read:	 0.0001 secs, 0.0000 secs, 0.0118 secs

Postgrest 0.4.1: -H "Accept: application/vnd.pgrst.object+json" "http://127.0.0.1:3000/numbers?telephone_number=eq.%2B442099123456"

Summary:
  Total:        7.6663 secs
  Slowest:      0.1653 secs
  Fastest:      0.0042 secs
  Average:      0.0305 secs
  Requests/sec: 652.2076

Response time histogram:
  0.004 [1]     |
  0.020 [315]   |∎∎∎
  0.036 [3702]  |∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎
  0.053 [910]   |∎∎∎∎∎∎∎∎∎∎
  0.069 [52]    |∎
  0.085 [8]     |
  0.101 [1]     |
  0.117 [3]     |
  0.133 [0]     |
  0.149 [2]     |
  0.165 [6]     |

Latency distribution:
  10% in 0.0217 secs
  25% in 0.0248 secs
  50% in 0.0291 secs
  75% in 0.0345 secs
  90% in 0.0407 secs
  95% in 0.0452 secs
  99% in 0.0547 secs

Details (average, fastest, slowest):
  DNS+dialup:	 0.0000 secs, 0.0000 secs, 0.0037 secs
  DNS-lookup:	 0.0000 secs, 0.0000 secs, 0.0000 secs
  req write:	 0.0000 secs, 0.0000 secs, 0.0030 secs
  resp wait:	 0.0303 secs, 0.0040 secs, 0.1639 secs
  resp read:	 0.0001 secs, 0.0000 secs, 0.0045 secs

Postgrest 0.4.2: -H "Accept: application/vnd.pgrst.object+json" "http://127.0.0.1:3000/numbers?telephone_number=eq.%2B442099123456"

Summary:
  Total:        7.8679 secs
  Slowest:      0.1853 secs
  Fastest:      0.0030 secs
  Average:      0.0313 secs
  Requests/sec: 635.4931

Response time histogram:
  0.003 [1]     |
  0.021 [424]   |∎∎∎∎
  0.039 [3826]  |∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎
  0.058 [685]   |∎∎∎∎∎∎∎
  0.076 [44]    |
  0.094 [5]     |
  0.112 [4]     |
  0.131 [1]     |
  0.149 [5]     |
  0.167 [1]     |
  0.185 [4]     |

Latency distribution:
  10% in 0.0219 secs
  25% in 0.0253 secs
  50% in 0.0296 secs
  75% in 0.0352 secs
  90% in 0.0428 secs
  95% in 0.0478 secs
  99% in 0.0600 secs

Details (average, fastest, slowest):
  DNS+dialup:	 0.0000 secs, 0.0000 secs, 0.0019 secs
  DNS-lookup:	 0.0000 secs, 0.0000 secs, 0.0000 secs
  req write:	 0.0000 secs, 0.0000 secs, 0.0052 secs
  resp wait:	 0.0311 secs, 0.0028 secs, 0.1846 secs
  resp read:	 0.0001 secs, 0.0000 secs, 0.0045 secs

Postgrest 0.4.3: -H "Accept: application/vnd.pgrst.object+json" "http://127.0.0.1:3000/numbers?telephone_number=eq.%2B442099123456"

Summary:
  Total:        7.9938 secs
  Slowest:      0.1885 secs
  Fastest:      0.0030 secs
  Average:      0.0318 secs
  Requests/sec: 625.4858

Response time histogram:
  0.003 [1]     |
  0.022 [378]   |∎∎∎∎
  0.040 [3960]  |∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎∎
  0.059 [618]   |∎∎∎∎∎∎
  0.077 [23]    |
  0.096 [0]     |
  0.114 [3]     |
  0.133 [0]     |
  0.151 [0]     |
  0.170 [13]    |
  0.188 [4]     |

Latency distribution:
  10% in 0.0223 secs
  25% in 0.0259 secs
  50% in 0.0304 secs
  75% in 0.0360 secs
  90% in 0.0417 secs
  95% in 0.0459 secs
  99% in 0.0577 secs

Details (average, fastest, slowest):
  DNS+dialup:	 0.0000 secs, 0.0000 secs, 0.0039 secs
  DNS-lookup:	 0.0000 secs, 0.0000 secs, 0.0000 secs
  req write:	 0.0000 secs, 0.0000 secs, 0.0047 secs
  resp wait:	 0.0316 secs, 0.0028 secs, 0.1860 secs
  resp read:	 0.0001 secs, 0.0000 secs, 0.0059 secs