explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 4Vou

Settings

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 0.022 0.522 ↑ 1.0 1 1

Nested Loop (cost=11.27..290.88 rows=1 width=496) (actual time=0.212..0.522 rows=1 loops=1)

  • Buffers: shared hit=131
2. 0.028 0.444 ↓ 4.0 4 1

Nested Loop (cost=10.40..285.99 rows=1 width=426) (actual time=0.187..0.444 rows=4 loops=1)

  • Buffers: shared hit=114
3. 0.111 0.384 ↓ 4.0 4 1

Nested Loop (cost=9.35..280.92 rows=1 width=140) (actual time=0.170..0.384 rows=4 loops=1)

  • Buffers: shared hit=98
4. 0.049 0.093 ↑ 1.2 18 1

Bitmap Heap Scan on dm_attrib_doc dm_attrib_doc3 (cost=4.78..91.77 rows=22 width=70) (actual time=0.053..0.093 rows=18 loops=1)

  • Recheck Cond: (((atattrib)::text = 'NUMERODOC'::text) AND ((atvalue)::text = '003493'::text))
  • Heap Blocks: exact=18
  • Buffers: shared hit=22
5. 0.044 0.044 ↑ 1.2 18 1

Bitmap Index Scan on dm_attrib_doc2 (cost=0.00..4.78 rows=22 width=0) (actual time=0.044..0.044 rows=18 loops=1)

  • Index Cond: (((atattrib)::text = 'NUMERODOC'::text) AND ((atvalue)::text = '003493'::text))
  • Buffers: shared hit=4
6. 0.018 0.180 ↓ 0.0 0 18

Bitmap Heap Scan on dm_attrib_doc dm_attrib_doc1 (cost=4.57..8.59 rows=1 width=70) (actual time=0.010..0.010 rows=0 loops=18)

  • Recheck Cond: ((advfid = dm_attrib_doc3.advfid) AND ((atattrib)::text = 'ANNOFISC'::text) AND ((atvalue)::text = '2016'::text))
  • Heap Blocks: exact=4
  • Buffers: shared hit=76
7. 0.162 0.162 ↓ 0.0 0 18

Bitmap Index Scan on dm_attrib_doc3 (cost=0.00..4.57 rows=1 width=0) (actual time=0.009..0.009 rows=0 loops=18)

  • Index Cond: ((advfid = dm_attrib_doc3.advfid) AND ((atattrib)::text = 'ANNOFISC'::text) AND ((atvalue)::text = '2016'::text))
  • Buffers: shared hit=72
8. 0.008 0.032 ↑ 1.0 1 4

Bitmap Heap Scan on dm_vfiles (cost=1.05..5.06 rows=1 width=286) (actual time=0.008..0.008 rows=1 loops=4)

  • Recheck Cond: (vfcodiceid = dm_attrib_doc1.advfid)
  • Heap Blocks: exact=4
  • Buffers: shared hit=16
9. 0.024 0.024 ↑ 1.0 1 4

Bitmap Index Scan on pk_dm_vfiles (cost=0.00..1.05 rows=1 width=0) (actual time=0.006..0.006 rows=1 loops=4)

  • Index Cond: (vfcodiceid = dm_attrib_doc1.advfid)
  • Buffers: shared hit=12
10. 0.004 0.056 ↓ 0.0 0 4

Bitmap Heap Scan on dm_attrib_doc dm_attrib_doc2 (cost=0.87..4.89 rows=1 width=70) (actual time=0.014..0.014 rows=0 loops=4)

  • Recheck Cond: (((atattrib)::text = 'PIVACFISC'::text) AND ((atvalue)::text = '01413580885'::text) AND (advfid = dm_vfiles.vfcodiceid))
  • Heap Blocks: exact=1
  • Buffers: shared hit=17
11. 0.052 0.052 ↓ 0.0 0 4

Bitmap Index Scan on dm_attrib_doc2 (cost=0.00..0.87 rows=1 width=0) (actual time=0.013..0.013 rows=0 loops=4)

  • Index Cond: (((atattrib)::text = 'PIVACFISC'::text) AND ((atvalue)::text = '01413580885'::text) AND (advfid = dm_vfiles.vfcodiceid))
  • Buffers: shared hit=16
Planning time : 2.011 ms
Execution time : 0.706 ms