explain.depesz.com

PostgreSQL's explain analyze made readable

Result: JeSv

Settings
# exclusive inclusive rows x rows loops node
1. 687.692 687.692 ↑ 1.5 244,353 1

GroupAggregate (cost=125883.18..143252.66 rows=35630 width=68) (actual time=1135.288..1780.631 rows=3430 loops=1)Group Key: d.organization_id, (COALESCE((d.state_details -> 'product_model'::text), (d.hardware_details -> 'model'::text)))-> GroupAggregate (cost=125883.18..136572.09 rows=356297 width=76) (actual time=1135.155..1765.513 rows=5849 loops=1)Group Key: d.organization_id, (COALESCE((d.state_details -> 'product_model'::text), (d.hardware_details -> 'model'::text))), ((d.state_details -> 'os_version'::text))-> Sort (cost=125883.18..126773.92 rows=356297 width=72) (actual time=1135.136..1516.677 rows=244353 loops=1)Sort Key: d.organization_id, (COALESCE((d.state_details -> 'product_model'::text), (d.hardware_details -> 'model'::text))), ((d.state_details -> 'os_version'::text))Sort Method: external merge Disk: 16592kB-> Seq Scan on devices_device d (cost=0.00..78,411.75 rows=356,297 width=72) (actual time=0.451..687.692 rows=244,353 loops=1)

Planning time : 0.172 ms
Execution time : 1,785.964 ms