explain.depesz.com

PostgreSQL's explain analyze made readable

Result: NAdI

Settings
# exclusive inclusive rows x rows loops node
1. 0.037 70.818 ↑ 26.0 23 1

GroupAggregate (cost=6,068.74..6,360.33 rows=599 width=44) (actual time=67.610..70.818 rows=23 loops=1)

  • Group Key: d.organization_id, (COALESCE((d.state_details -> 'product_model'::text), (d.hardware_details -> 'model'::text)))
2. 3.186 70.781 ↑ 260.0 23 1

GroupAggregate (cost=6,068.74..6,248.17 rows=5,981 width=738) (actual time=67.407..70.781 rows=23 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. 7.246 67.595 ↑ 1.3 4,504 1

Sort (cost=6,068.74..6,083.70 rows=5,981 width=738) (actual time=67.201..67.595 rows=4,504 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: quicksort Memory: 826kB
4. 60.349 60.349 ↑ 1.3 4,504 1

Seq Scan on devices_device d (cost=0.00..3,730.05 rows=5,981 width=738) (actual time=0.073..60.349 rows=4,504 loops=1)

  • Filter: (jsonb_typeof((state_details -> 'os_version'::text)) <> 'null'::text)
  • Rows Removed by Filter: 1507
Planning time : 3.729 ms
Execution time : 71.113 ms