explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Tsox

Settings
# exclusive inclusive rows x rows loops node
1. 0.023 0.023 ↑ 741,227.0 1 1

Index Scan using tblfun_expr_idx on tblfun tblfun (cost=0.57..2,723,300.04 rows=741,227 width=121) (actual time=0.022..0.023 rows=1 loops=1)

  • Index Cond: ((tblfun.data #>> '{name}'::text[]) = '12301.photo.blog'::text)
  • Buffers: shared hit=5
Planning time : 0.051 ms
Execution time : 0.034 ms