explain.depesz.com

PostgreSQL's explain analyze made readable

Result: YOf6

Settings
# exclusive inclusive rows x rows loops node
1. 0.007 0.030 ↑ 1,002,017.0 1 1

Bitmap Heap Scan on public.tblfun (cost=42,610.33..2,168,055.81 rows=1,002,017 width=100) (actual time=0.029..0.030 rows=1 loops=1)

  • Output: (data #>> '{name}'::text[])
  • Recheck Cond: ((tblfun.data #>> '{name}'::text[]) = 'www.spotify.com'::text)
  • Heap Blocks: exact=1
  • Buffers: shared hit=6
2. 0.023 0.023 ↑ 1,002,017.0 1 1

Bitmap Index Scan on tblfun_expr_idx1 (cost=0.00..42,359.82 rows=1,002,017 width=0) (actual time=0.023..0.023 rows=1 loops=1)

  • Index Cond: ((tblfun.data #>> '{name}'::text[]) = 'www.spotify.com'::text)
  • Buffers: shared hit=5
Planning time : 0.064 ms
Execution time : 0.054 ms