explain.depesz.com

PostgreSQL's explain analyze made readable

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

Settings

Optimization path:

# exclusive inclusive rows x rows loops node
1. 0.012 0.115 ↓ 2.0 2 1

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

  • Buffers: shared hit=22
2. 0.021 0.021 ↓ 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.019..0.021 rows=2 loops=1)

  • Index Cond: (t_e20so1_supportedfile.c_documentid = 54,636)
  • Buffers: shared hit=4
3. 0.012 0.082 ↑ 5.0 1 2

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

  • Buffers: shared hit=18
4. 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
5. 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
6. 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
7. 0.016 0.016 ↓ 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.008..0.008 rows=0 loops=2)

  • Index Cond: (t_e20so1_supportedfile.c_repositoryid = repository_3.c_repositoryid)
  • Buffers: shared hit=4
8. 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
Planning time : 0.905 ms
Execution time : 5.613 ms