explain.depesz.com

PostgreSQL's explain analyze made readable

Result: fppW

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 0.000 ↓ 0.0 1 1

Gather (cost=0..0 rows=0 width=0) (actual rows=1 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
2. 0.000 0.000 ↓ 0.0 0 3 / 3

Bitmap Heap Scan on tblfun tblfun (cost=0..0 rows=0 width=0) (actual rows=0 loops=3)

  • Heap Blocks: exact=1
3. 0.000 0.000 ↓ 0.0 1 1 / 3

Bitmap Index Scan on tblfun_data_idx (cost=0..0 rows=0 width=0) (actual rows=1 loops=1)

  • Index Cond: (data @> '{"name": "customerportal.codeweavers.net"}'::jsonb)