explain.depesz.com

PostgreSQL's explain analyze made readable

Result: SAE6

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 0.029 ↑ 2.0 1 1

Limit (cost=3.34..5.57 rows=2 width=1,243) (actual time=0.029..0.029 rows=1 loops=1)

  • Buffers: shared hit=9
2. 0.004 0.029 ↑ 2.0 1 1

Bitmap Heap Scan on users this_ (cost=3.34..5.57 rows=2 width=1,243) (actual time=0.028..0.029 rows=1 loops=1)

  • Filter: (this_.date_deleted IS NULL)
  • Heap Blocks: exact=1
  • Buffers: shared hit=9
3. 0.001 0.025 ↓ 0.0 0 1

BitmapOr (cost=3.34..3.34 rows=2 width=0) (actual time=0.025..0.025 rows=0 loops=1)

  • Buffers: shared hit=8
4. 0.012 0.012 ↑ 1.0 1 1

Bitmap Index Scan on user_refer_id_unique_idx (cost=0..1.67 rows=1 width=0) (actual time=0.012..0.012 rows=1 loops=1)

  • Index Cond: ((this_.refer_id)::text = 'z7av6'::text)
  • Buffers: shared hit=4
5. 0.012 0.012 ↑ 1.0 1 1

Bitmap Index Scan on users_pkey (cost=0..1.67 rows=1 width=0) (actual time=0.012..0.012 rows=1 loops=1)

  • Index Cond: ((this_.id)::text = 'u-ise2igmv3db51l50'::text)
  • Buffers: shared hit=4
Planning time : 0.14 ms
Execution time : 0.049 ms