explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 5pyF

Settings
# exclusive inclusive rows x rows loops node
1. 40.113 40.161 ↑ 147,934.0 1 1

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

  • Workers Planned: 2
  • Workers Launched: 1
  • Buffers: shared hit=6
2. 0.043 0.048 ↑ 61,639.0 1 2 / 2

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

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

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.053 ms
Execution time : 40.187 ms