explain.depesz.com

PostgreSQL's explain analyze made readable

Result: YWWX

Settings

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 0.021 0.569 ↑ 1.0 1 1

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

  • Buffers: shared hit=131
2. 0.033 0.484 ↓ 4.0 4 1

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

  • Buffers: shared hit=114
3. 0.120 0.423 ↓ 4.0 4 1

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

  • Buffers: shared hit=98
4. 0.033 0.069 ↑ 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.043..0.069 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.036 0.036 ↑ 1.2 18 1

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

  • Index Cond: (((atattrib)::text = 'NUMERODOC'::text) AND ((atvalue)::text = '003493'::text))
  • Buffers: shared hit=4
6. 0.018 0.234 ↓ 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.013..0.013 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.216 0.216 ↓ 0.0 0 18

Bitmap Index Scan on dm_attrib_doc3 (cost=0.00..4.57 rows=1 width=0) (actual time=0.012..0.012 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.028 ↑ 1.0 1 4

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

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

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

  • Index Cond: (vfcodiceid = dm_attrib_doc1.advfid)
  • Buffers: shared hit=12
10. 0.008 0.064 ↓ 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.016..0.016 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.056 0.056 ↓ 0.0 0 4

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

  • Index Cond: (((atattrib)::text = 'PIVACFISC'::text) AND ((atvalue)::text = '01413580885'::text) AND (advfid = dm_vfiles.vfcodiceid))
  • Buffers: shared hit=16