Input

field	value
Query:	SELECT ARRAY[name, name_matchable, version] AS name ,domain_count FROM technology2 WHERE parent = 'lighttpd' ORDER BY domain_count DESC NULLS LAST

Query Plan

Download: csv json

Query Plan
Limit (cost=304.58..304.63 rows=20 width=36)
-> Sort (cost=304.58..304.80 rows=90 width=36)
Sort Key: domain_count DESC NULLS LAST
-> Bitmap Heap Scan on technology2 (cost=4.98..302.18 rows=90 width=36)
Recheck Cond: (parent = 'lighttpd'::text)
-> Bitmap Index Scan on technology2_parent_idx (cost=0.00..4.96 rows=90 width=0)
Index Cond: (parent = 'lighttpd'::text)

Data

Total Results: 32 Download: csv json

Name	Domain Count
[Lighttpd/1.4.45, lighttpd 1.4.45, 1.4.45]	101.0
[Lighttpd/1.4.35, lighttpd 1.4.35, 1.4.35]	28.0
[Lighttpd/1.4.59, lighttpd 1.4.59, 1.4.59]	26.0
[Lighttpd/1.4.55, lighttpd 1.4.55, 1.4.55]	18.0
[Lighttpd/1.4.69, lighttpd 1.4.69, 1.4.69]	17.0
[Lighttpd/1.4.63, lighttpd 1.4.63, 1.4.63]	16.0
[Lighttpd/1.4.53, lighttpd 1.4.53, 1.4.53]	15.0
[Lighttpd/1.4.54, lighttpd 1.4.54, 1.4.54]	7.0
[Lighttpd/1.4.31, lighttpd 1.4.31, 1.4.31]	5.0
[Lighttpd/1.4.71, lighttpd 1.4.71, 1.4.71]	5.0
[Lighttpd/1.4.64, lighttpd 1.4.64, 1.4.64]	4.0
[Lighttpd/1.4.67, lighttpd 1.4.67, 1.4.67]	4.0
[Lighttpd/1.4.65, lighttpd 1.4.65, 1.4.65]	3.0
[Lighttpd/1.4.19, lighttpd 1.4.19, 1.4.19]	3.0
[Lighttpd/1.4.32, lighttpd 1.4.32, 1.4.32]	2.0
[Lighttpd/1.4.47, lighttpd 1.4.47, 1.4.47]	2.0
[Lighttpd/1.4.28, lighttpd 1.4.28, 1.4.28]	2.0
[Lighttpd/1.4.15, lighttpd 1.4.15, 1.4.15]	2.0
[Lighttpd/1.4.33, lighttpd 1.4.33, 1.4.33]	2.0
[Lighttpd/1.4.39, lighttpd 1.4.39, 1.4.39]	2.0