explain.depesz.com

PostgreSQL's explain analyze made readable

Result: rqz4

Settings
# exclusive inclusive rows x rows loops node
1. 43.178 43.215 ↑ 148,369.0 1 1

Gather (cost=2,401.86..1,102,619.5 rows=148,369 width=4) (actual time=0.501..43.215 rows=1 loops=1)

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

Bitmap Heap Scan on tblfun tblfun (cost=1,401.86..1,086,782.6 rows=61,820 width=4) (actual time=0.037..0.037 rows=0 loops=3)

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

Bitmap Index Scan on tblfun_data_idx (cost=0..1,364.76 rows=148,369 width=0) (actual time=0.01..0.01 rows=1 loops=1)

  • Index Cond: (tblfun.data @> '{"name": "www.spotify.com"}'::jsonb)
  • Buffers: shared hit=5
Planning time : 0.073 ms
Execution time : 43.245 ms