explain.depesz.com

PostgreSQL's explain analyze made readable

Result: MztY

Settings
# exclusive inclusive rows x rows loops node
1. 0.005 0.025 ↑ 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.025..0.025 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.020 0.020 ↑ 1,002,017.0 1 1

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

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