explain.depesz.com

PostgreSQL's explain analyze made readable

Result: mDnV

Settings
# exclusive inclusive rows x rows loops node
1. 6.173 6.173 ↑ 23.0 1 1

Seq Scan on devices (cost=0.00..1,255.95 rows=23 width=75) (actual time=0.012..6.173 rows=1 loops=1)

  • Filter: ((enrollment_data ? 'bb224e5cc7656f3deb85695d29c36b73d7217438de1ea042fccecfe164a36eed'::text) AND ((device_type)::text = 'android'::text))
  • Rows Removed by Filter: 22796
Planning time : 0.085 ms
Execution time : 6.192 ms