explain.depesz.com

PostgreSQL's explain analyze made readable

Result: ABVn

Settings
# exclusive inclusive rows x rows loops node
1. 15.118 1,780.631 ↑ 10.4 3,430 1

GroupAggregate (cost=125,883.18..143,252.66 rows=35,630 width=68) (actual time=1,135.288..1,780.631 rows=3,430 loops=1)

  • Group Key: d.organization_id, (COALESCE((d.state_details -> 'product_model'::text), (d.hardware_details -> 'model'::text)))
2. 248.836 1,765.513 ↑ 60.9 5,849 1

GroupAggregate (cost=125,883.18..136,572.09 rows=356,297 width=76) (actual time=1,135.155..1,765.513 rows=5,849 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))
3. 828.985 1,516.677 ↑ 1.5 244,353 1

Sort (cost=125,883.18..126,773.92 rows=356,297 width=72) (actual time=1,135.136..1,516.677 rows=244,353 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
4. 687.692 687.692 ↑ 1.5 244,353 1

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)

  • Filter: (jsonb_typeof((state_details -> 'os_version'::text)) <> 'null'::text)
  • Rows Removed by Filter: 113734
Planning time : 0.172 ms
Execution time : 1,785.964 ms