Trends From Check My Ride Data

Most Popular Car Models

  • Ford Mustang
    2%
  • BMW 3 Series
    2%
  • Honda Civic
    2%
  • Chevrolet Camaro
    1%
  • Toyota Camry
    1%

Most Popular Car Colors

  • Black
    13%
  • Red
    12%
  • White
    9%
  • Blue
    9%
  • Silver
    9%

Most Popular Car Names

  • Na
    0%
  • None
    0%
  • Silver Bullet
    0%
  • Baby
    0%
  • Beast
    0%
(default) 15 queries took 96 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1SELECT table_name as name FROM INFORMATION_SCHEMA.tables WHERE table_schema = 'public';0134
2SELECT DISTINCT column_name AS name, data_type AS type, is_nullable AS null, column_default AS default, ordinal_position AS position, character_maximum_length AS char_length, character_octet_length AS oct_length FROM information_schema.columns WHERE table_name = 'cars' AND table_schema = 'public' ORDER BY position069
3SELECT DISTINCT column_name AS name, data_type AS type, is_nullable AS null, column_default AS default, ordinal_position AS position, character_maximum_length AS char_length, character_octet_length AS oct_length FROM information_schema.columns WHERE table_name = 'makes' AND table_schema = 'public' ORDER BY position056
4SELECT DISTINCT column_name AS name, data_type AS type, is_nullable AS null, column_default AS default, ordinal_position AS position, character_maximum_length AS char_length, character_octet_length AS oct_length FROM information_schema.columns WHERE table_name = 'countries' AND table_schema = 'public' ORDER BY position035
5SELECT DISTINCT column_name AS name, data_type AS type, is_nullable AS null, column_default AS default, ordinal_position AS position, character_maximum_length AS char_length, character_octet_length AS oct_length FROM information_schema.columns WHERE table_name = 'car_years' AND table_schema = 'public' ORDER BY position046
6SELECT DISTINCT column_name AS name, data_type AS type, is_nullable AS null, column_default AS default, ordinal_position AS position, character_maximum_length AS char_length, character_octet_length AS oct_length FROM information_schema.columns WHERE table_name = 'vehicles' AND table_schema = 'public' ORDER BY position0196
7SELECT DISTINCT column_name AS name, data_type AS type, is_nullable AS null, column_default AS default, ordinal_position AS position, character_maximum_length AS char_length, character_octet_length AS oct_length FROM information_schema.columns WHERE table_name = 'users' AND table_schema = 'public' ORDER BY position0246
8SELECT DISTINCT column_name AS name, data_type AS type, is_nullable AS null, column_default AS default, ordinal_position AS position, character_maximum_length AS char_length, character_octet_length AS oct_length FROM information_schema.columns WHERE table_name = 'vehicle_images' AND table_schema = 'public' ORDER BY position0106
9SELECT DISTINCT column_name AS name, data_type AS type, is_nullable AS null, column_default AS default, ordinal_position AS position, character_maximum_length AS char_length, character_octet_length AS oct_length FROM information_schema.columns WHERE table_name = 'comments' AND table_schema = 'public' ORDER BY position055
10SELECT DISTINCT column_name AS name, data_type AS type, is_nullable AS null, column_default AS default, ordinal_position AS position, character_maximum_length AS char_length, character_octet_length AS oct_length FROM information_schema.columns WHERE table_name = 'flags' AND table_schema = 'public' ORDER BY position0106
11SELECT DISTINCT column_name AS name, data_type AS type, is_nullable AS null, column_default AS default, ordinal_position AS position, character_maximum_length AS char_length, character_octet_length AS oct_length FROM information_schema.columns WHERE table_name = 'checks' AND table_schema = 'public' ORDER BY position045
12SELECT COUNT(*) AS "count" FROM "vehicles" AS "Vehicle" LEFT JOIN "makes" AS "Make" ON ("Vehicle"."make_id" = "Make"."id") LEFT JOIN "cars" AS "Car" ON ("Vehicle"."car_id" = "Car"."id") LEFT JOIN "users" AS "User" ON ("Vehicle"."user_id" = "User"."id") WHERE "User"."id" IS NOT NULL 0117
13SELECT "Car"."name" AS "Car__name", "Car"."vehicle_count" AS "Car__vehicle_count", "Make"."name" AS "Make__name", "Make"."id" AS "Make__id" FROM "cars" AS "Car" LEFT JOIN "makes" AS "Make" ON ("Car"."make_id" = "Make"."id") WHERE "Car"."vehicle_count" is not null ORDER BY "Car"."vehicle_count" DESC LIMIT 5053
14SELECT "Vehicle"."color" AS "Vehicle__color", count("Vehicle"."color") FROM "vehicles" AS "Vehicle" WHERE "Vehicle"."color" is not null AND "Vehicle"."color" !='' GROUP BY "Vehicle"."color" ORDER BY count("Vehicle"."color") DESC LIMIT 5056
15SELECT LOWER("Vehicle"."nickname") AS Vehicle__nickname, count("Vehicle"."nickname") AS Vehicle__count FROM "vehicles" AS "Vehicle" WHERE "Vehicle"."nickname" is not null AND "Vehicle"."nickname" !='' GROUP BY LOWER("Vehicle"."nickname") ORDER BY count("Vehicle"."nickname") DESC LIMIT 5056