explain.depesz.com

PostgreSQL's explain analyze made readable

Result: g5bf : Optimization for: Test; plan #XPFH

Settings

Optimization path:

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 0.011 0.240 ↓ 2.0 2 1

Nested Loop (cost=1.68..22.74 rows=1 width=182) (actual time=0.165..0.24 rows=2 loops=1)

  • Buffers: shared hit=43 read=1
2. 0.005 0.205 ↓ 2.0 2 1

Nested Loop (cost=1.26..20.1 rows=1 width=178) (actual time=0.141..0.205 rows=2 loops=1)

  • Buffers: shared hit=35 read=1
3. 0.004 0.174 ↓ 2.0 2 1

Nested Loop (cost=0.85..17.46 rows=1 width=174) (actual time=0.125..0.174 rows=2 loops=1)

  • Buffers: shared hit=27 read=1
4. 0.010 0.122 ↓ 2.0 2 1

Nested Loop (cost=0.56..14.94 rows=1 width=75) (actual time=0.084..0.122 rows=2 loops=1)

  • Buffers: shared hit=22
5. 0.026 0.026 ↓ 2.0 2 1

Index Scan using t_e20so1_supportedfile_c_documentid_idx on t_e20so1_supportedfile t_e20so1_supportedfile (cost=0.41..2.63 rows=1 width=28) (actual time=0.024..0.026 rows=2 loops=1)

  • Index Cond: (t_e20so1_supportedfile.c_documentid = 54,636)
  • Buffers: shared hit=4
6. 0.014 0.086 ↑ 5.0 1 2

Append (cost=0.14..12.26 rows=5 width=55) (actual time=0.041..0.043 rows=1 loops=2)

  • Buffers: shared hit=18
7. 0.006 0.006 ↓ 0.0 0 2

Index Scan using t_e20so1_repository_default_c_repositoryid_idx on t_e20so1_repository_default repository (cost=0.14..2.36 rows=1 width=742) (actual time=0.003..0.003 rows=0 loops=2)

  • Index Cond: (t_e20so1_supportedfile.c_repositoryid = repository.c_repositoryid)
  • Buffers: shared hit=2
8. 0.004 0.004 ↓ 0.0 0 2

Index Scan using t_e20so1_repository_dynamic_c_repositoryid_idx on t_e20so1_repository_dynamic repository_1 (cost=0.14..2.36 rows=1 width=742) (actual time=0.002..0.002 rows=0 loops=2)

  • Index Cond: (t_e20so1_supportedfile.c_repositoryid = repository_1.c_repositoryid)
  • Buffers: shared hit=2
9. 0.018 0.018 ↓ 0.0 0 2

Index Scan using t_e20so1_repository_document_c_repositoryid_idx on t_e20so1_repository_document repository_2 (cost=0.29..2.51 rows=1 width=57) (actual time=0.009..0.009 rows=0 loops=2)

  • Index Cond: (t_e20so1_supportedfile.c_repositoryid = repository_2.c_repositoryid)
  • Buffers: shared hit=4
10. 0.018 0.018 ↓ 0.0 0 2

Index Scan using t_e20so1_repository_pages_c_repositoryid_idx on t_e20so1_repository_pages repository_3 (cost=0.29..2.51 rows=1 width=53) (actual time=0.009..0.009 rows=0 loops=2)

  • Index Cond: (t_e20so1_supportedfile.c_repositoryid = repository_3.c_repositoryid)
  • Buffers: shared hit=4
11. 0.026 0.026 ↑ 1.0 1 2

Index Scan using t_e20so1_repository_supported_c_repositoryid_idx on t_e20so1_repository_supported repository_4 (cost=0.29..2.5 rows=1 width=53) (actual time=0.012..0.013 rows=1 loops=2)

  • Index Cond: (t_e20so1_supportedfile.c_repositoryid = repository_4.c_repositoryid)
  • Buffers: shared hit=6
12. 0.048 0.048 ↑ 1.0 1 2

Index Scan using t_e20so1_supportedfile_nvarchar_c_supportedfileid_idx on t_e20so1_supportedfile_nvarchar t_e20so1_supportedfile_nvarchar (cost=0.29..2.51 rows=1 width=107) (actual time=0.022..0.024 rows=1 loops=2)

  • Index Cond: (t_e20so1_supportedfile.c_supportedfileid = t_e20so1_supportedfile_nvarchar.c_supportedfileid)
  • Filter: (t_e20so1_supportedfile_nvarchar.c_fieldid = '50a3d1b8-b902-4256-8d35-c278ed3306c5'::uuid)
  • Buffers: shared hit=5 read=1
13. 0.026 0.026 ↑ 1.0 1 2

Index Scan using "UQ_be14811a-ea28-4fc9-9947-96c174aaefc2" on t_e20so1_supportedfile_int supportedfileint (cost=0.41..2.63 rows=1 width=12) (actual time=0.013..0.013 rows=1 loops=2)

  • Index Cond: ((t_e20so1_supportedfile.c_supportedfileid = supportedfileint.c_supportedfileid) AND (supportedfileint.c_fieldid = '00591c85-92d9-4d98-ac84-240178380526'::uuid))
  • Buffers: shared hit=8
14. 0.024 0.024 ↑ 1.0 1 2

Index Scan using t_e20so1_document_property_c_documentid_idx on t_e20so1_document_property docprop (cost=0.41..2.63 rows=1 width=12) (actual time=0.012..0.012 rows=1 loops=2)

  • Index Cond: (docprop.c_documentid = 54,636)
  • Buffers: shared hit=8
Planning time : 2.973 ms
Execution time : 0.647 ms