explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 1TjD : Optimization for: plan #4Vou

Settings

Optimization path:

# exclusive inclusive rows x rows loops node
1. 0.020 1.054 ↑ 1.0 1 1

Nested Loop (cost=80.43..88.46 rows=1 width=640) (actual time=1.050..1.054 rows=1 loops=1)

  • Buffers: shared hit=83
2. 0.015 1.020 ↑ 1.0 1 1

Bitmap Heap Scan on dm_attrib_json (cost=76.00..80.02 rows=1 width=354) (actual time=1.016..1.020 rows=1 loops=1)

  • Recheck Cond: ((jattrib @> '{"ANNOFISC": "2016"}'::jsonb) AND (jattrib @> '{"PIVACFISC": "01413580885"}'::jsonb) AND (jattrib @> '{"NUMERODOC": "003493"}'::jsonb))
  • Rows Removed by Index Recheck: 1
  • Heap Blocks: exact=2
  • Buffers: shared hit=79
3. 1.005 1.005 ↓ 2.0 2 1

Bitmap Index Scan on jattrib1 (cost=0.00..76.00 rows=1 width=0) (actual time=1.005..1.005 rows=2 loops=1)

  • Index Cond: ((jattrib @> '{"ANNOFISC": "2016"}'::jsonb) AND (jattrib @> '{"PIVACFISC": "01413580885"}'::jsonb) AND (jattrib @> '{"NUMERODOC": "003493"}'::jsonb))
  • Buffers: shared hit=77
4. 0.004 0.014 ↑ 1.0 1 1

Bitmap Heap Scan on dm_vfiles (cost=4.43..8.44 rows=1 width=286) (actual time=0.014..0.014 rows=1 loops=1)

  • Recheck Cond: (vfcodiceid = dm_attrib_json.advfid)
  • Heap Blocks: exact=1
  • Buffers: shared hit=4
5. 0.010 0.010 ↑ 1.0 1 1

Bitmap Index Scan on pk_dm_vfiles (cost=0.00..4.43 rows=1 width=0) (actual time=0.010..0.010 rows=1 loops=1)

  • Index Cond: (vfcodiceid = dm_attrib_json.advfid)
  • Buffers: shared hit=3
Planning time : 0.447 ms
Execution time : 1.240 ms