QUERY PLAN
—-------------------------------------------------------------------------------
Hash Join (cost=25.95..59.40 rows=1130 width=524)
Hash Cond: (device_metrics.device_id = devices.id)
-> Seq Scan on device_metrics (cost=0.00..21.30 rows=1130 width=8)
-> Hash (cost=24.20..24.20 rows=140 width=520)
-> Hash Join (cost=11.57..24.20 rows=140 width=520)
Hash Cond: (devices.user_id = users.id)
-> Seq Scan on devices (cost=0.00..11.40 rows=140 width=8)
-> Hash (cost=10.70..10.70 rows=70 width=520)
-> Seq Scan on users (cost=0.00..10.70 rows=70 width=520)
(9 строк)
explain (analyze,verbose,buffers)
Обсуждают сегодня