DBmarlin dashboard

Logo

Events

Since 1 hour ago

https://play.dbmarlin.com/instances/2/activity https://play.dbmarlin.com/instances/1/activity https://play.dbmarlin.com/instances/4/activity https://play.dbmarlin.com/instances/7/activity https://play.dbmarlin.com/instances/8/activity https://play.dbmarlin.com/instances/3/activity Link

instance

Total Alert Events

Total Custom Events

Total Change Events

Link

postgres11-postgresql

2

0

4

https://play.dbmarlin.com/instances/2/activity

mysql57

2

1

0

https://play.dbmarlin.com/instances/1/activity

MS-SQL-2019

0

https://play.dbmarlin.com/instances/4/activity

db2-11.5-win2019

0

https://play.dbmarlin.com/instances/7/activity

cockroach22-1

0

https://play.dbmarlin.com/instances/8/activity

oracle-rds-webtuna

0

https://play.dbmarlin.com/instances/3/activity

Top statements (by time in seconds)

Since 1 hour ago

SELECT rates.description, COUNT(vendor_id) AS num_trips, AVG(total_amount) AS avg_total, AVG(tip_amount) AS avg_tip, MIN(trip_distance) AS min_distance, AVG (trip_distance) AS avg_distance, MAX(trip_distance) AS max_distance, AVG(passenger_count) AS avg_passengers FROM rides JOIN rates ON rides.rate_code = rates.rate_code WHERE pickup_datetime > to_timestamp('2016-01-06 09:00:00', 'YYYY-MM-DD HH24:MI:SS') AND pickup_datetime <= to_timestamp('2016-01-06 10:00:00', 'YYYY-MM-DD HH24:MI:SS') AND passenger_count = 2 GROUP BY rates.description ORDER BY rates.description
9.02 k
select date_trunc('hour', pickup_datetime) as hour , count(*) from rides where passenger_count = 2 AND pickup_datetime > '2016-01-04 09:00:00' AND pickup_datetime <= '2016-01-04 10:00:00' group by 1
8.35 k
SELECT rate_code, COUNT(vendor_id) AS num_trips FROM rides WHERE pickup_datetime > '2016-01-05 09:00:00' AND pickup_datetime <= '2016-01-05 10:00:00' and passenger_count = 1 GROUP BY rate_code ORDER BY rate_code
8.23 k
select vendor_id, count(*) from rides where passenger_count = 1 AND pickup_datetime > '2016-01-03 09:00:00' AND pickup_datetime <= '2016-01-03 10:00:00' group by vendor_id
8.17 k
SELECT rate_code, COUNT(vendor_id) AS num_trips FROM rides WHERE pickup_datetime > to_timestamp('2016-01-05 09:00:00', 'YYYY-MM-DD HH24:MI:SS') AND pickup_datetime <= to_timestamp('2016-01-05 10:00:00', 'YYYY-MM-DD HH24:MI:SS') AND passenger_count = 1 GROUP BY rate_code ORDER BY rate_code
8.12 k
SELECT rates.description, COUNT(vendor_id) AS num_trips, AVG(dropoff_datetime - pickup_datetime) AS avg_trip_duration, AVG(total_amount) AS avg_total, AVG(tip_amount) AS avg_tip, MIN(trip_distance) AS min_distance, AVG (trip_distance) AS avg_distance, MAX(trip_distance) AS max_distance, AVG(passenger_count) AS avg_passengers FROM rides JOIN rates ON rides.rate_code = rates.rate_code WHERE pickup_datetime > '2016-01-06 09:00:00' AND pickup_datetime <= '2016-01-06 10:00:00' and passenger_count = 2 GROUP BY rates.description ORDER BY rates.description
8.08 k
SELECT trunc(pickup_datetime, 'HH'), count(*) FROM rides WHERE passenger_count = 2 AND pickup_datetime > to_timestamp('2016-01-04 09:00:00', 'YYYY-MM-DD HH24:MI:SS') AND pickup_datetime <= to_timestamp('2016-01-04 10:00:00', 'YYYY-MM-DD HH24:MI:SS') GROUP BY trunc(pickup_datetime, 'HH')
8.04 k
SELECT vendor_id, count(*) FROM rides WHERE passenger_count = 1 AND pickup_datetime > to_timestamp('2016-01-03 09:00:00', 'YYYY-MM-DD HH24:MI:SS') AND pickup_datetime <= to_timestamp('2016-01-03 10:00:00', 'YYYY-MM-DD HH24:MI:SS') GROUP BY vendor_id
7.82 k
select avg(a.orders) items_per_customer FROM (SELECT customer_id, count(*) orders from orders GROUP BY customer_id ) a
7.46 k
SELECT DPT_ID, DPT_NAME, DPT_MANAGER, DPT_AVG_SALARY FROM TOSSKA.DEPARTMENT WHERE EXISTS (SELECT count(*) FROM TOSSKA.EMPLOYEE WHERE EMP_ID < 1100000 AND EMP_DEPT = TOSSKA.DEPARTMENT.DPT_ID group by emp_dept having count(*)>100)
2.04 k

DBmarlin dashboard

Events

Top instances (by time in seconds)

Activity over time (seconds)

Top statements (by time in seconds)

Top instances over time (seconds)