explain.depesz.com

PostgreSQL's explain analyze made readable

Result: NqWD

Settings
# exclusive inclusive rows x rows loops node
1. 43.108 43.148 ↑ 148,245.0 1 1

Gather (cost=2,400.9..1,101,605.28 rows=148,245 width=123) (actual time=0.454..43.148 rows=1 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
  • Buffers: shared hit=6
2. 0.037 0.040 ↓ 0.0 0 3 / 3

Bitmap Heap Scan on tblfun tblfun (cost=1,400.9..1,085,780.78 rows=61,769 width=123) (actual time=0.04..0.04 rows=0 loops=3)

  • Heap Blocks: exact=1
  • Buffers: shared hit=6
3. 0.003 0.003 ↑ 148,245.0 1 1 / 3

Bitmap Index Scan on tblfun_data_idx (cost=0..1,363.84 rows=148,245 width=0) (actual time=0.009..0.009 rows=1 loops=1)

  • Index Cond: (tblfun.data @> '{"name": "12301.photo.blog"}'::jsonb)
  • Buffers: shared hit=5
Planning time : 0.053 ms
Execution time : 43.171 ms