explain.depesz.com

PostgreSQL's explain analyze made readable

Result: cWq4

Settings
# exclusive inclusive rows x rows loops node
1. 44.944 44.985 ↑ 147,934.0 1 1

Gather (cost=2,398.49..1,099,056.1 rows=147,934 width=4) (actual time=0.51..44.985 rows=1 loops=1)

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

Bitmap Heap Scan on tblfun tblfun (cost=1,398.49..1,083,262.7 rows=61,639 width=4) (actual time=0.041..0.041 rows=0 loops=3)

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

Bitmap Index Scan on tblfun_data_idx (cost=0..1,361.51 rows=147,934 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.058 ms
Execution time : 45.012 ms