explain.depesz.com

PostgreSQL's explain analyze made readable

Result: l3f3d

Settings
# exclusive inclusive rows x rows loops node
1. 0.008 0.826 ↑ 22.0 1 1

Bitmap Heap Scan on "user" (cost=1,485.83..2,441.92 rows=22 width=240) (actual time=0.826..0.826 rows=1 loops=1)

  • Recheck Cond: ('{8579f3ab-e473-518b-bc81-6e079fbb0bfb}'::character varying[] @> hj_ids)
  • Filter: ((user_id IS NULL) AND (site_id = 741271))
  • Heap Blocks: exact=1
2. 0.818 0.818 ↑ 244.0 1 1

Bitmap Index Scan on gix_user_hj_ids (cost=0.00..1,485.83 rows=244 width=0) (actual time=0.818..0.818 rows=1 loops=1)

  • Index Cond: ('{8579f3ab-e473-518b-bc81-6e079fbb0bfb}'::character varying[] @> hj_ids)
Planning time : 0.098 ms
Execution time : 0.891 ms