explain.depesz.com

PostgreSQL's explain analyze made readable

Result: TdEp

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

Bitmap Heap Scan on devices (cost=12.18..93.58 rows=23 width=75) (actual time=0.029..0.030 rows=1 loops=1)

  • Recheck Cond: ((enrollment_data ? 'bb224e5cc7656f3deb85695d29c36b73d7217438de1ea042fccecfe164a36eed'::text) AND ((device_type)::text = 'android'::text))
  • Heap Blocks: exact=1
2. 0.016 0.016 ↑ 23.0 1 1

Bitmap Index Scan on index_partial_android_devices_enrollment_data (cost=0.00..12.17 rows=23 width=0) (actual time=0.016..0.016 rows=1 loops=1)

  • Index Cond: (enrollment_data ? 'bb224e5cc7656f3deb85695d29c36b73d7217438de1ea042fccecfe164a36eed'::text)
Planning time : 0.259 ms
Execution time : 0.055 ms