explain.depesz.com

PostgreSQL's explain analyze made readable

Result: G9Z

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 11,108.006 ↑ 1.3 79 1

Limit (cost=9.94..13,404.12 rows=100 width=69) (actual time=1.307..11,108.006 rows=79 loops=1)

2.          

Initplan (forLimit)

3. 0.025 0.025 ↑ 1.0 1 1

Index Scan using version_bom_release_id_idx on version_bom (cost=0.28..8.29 rows=1 width=8) (actual time=0.023..0.025 rows=1 loops=1)

  • Index Cond: (release_id = '3e6d43b5-0a7e-4181-9bc5-c56f36b7a9be'::uuid)
4. 41.716 11,107.983 ↑ 5.8 79 1

Nested Loop (cost=1.65..61,748.80 rows=461 width=69) (actual time=1.306..11,107.983 rows=79 loops=1)

  • Join Filter: ((vbf.file_name ~~ '%zuul%'::text) OR (vbc.project_name ~~ '%Apache%'::text))
  • Rows Removed by Join Filter: 72147
5. 84.153 10,777.363 ↓ 15.9 72,226 1

Nested Loop (cost=1.23..27,046.38 rows=4,537 width=56) (actual time=1.271..10,777.363 rows=72,226 loops=1)

6. 9,898.724 9,898.724 ↓ 24.5 72,226 1

Index Only Scan Backward using idx_version_bom_file_only on version_bom_file vbf (cost=0.80..3,185.04 rows=2,948 width=21) (actual time=1.226..9,898.724 rows=72,226 loops=1)

  • Index Cond: (version_bom_id = $0)
  • Heap Fetches: 19527
7. 794.486 794.486 ↑ 1.0 1 72,226

Index Scan using idx_version_bom_entry_version_bom_file_id on version_bom_entry vbe (cost=0.43..8.08 rows=1 width=51) (actual time=0.011..0.011 rows=1 loops=72,226)

  • Index Cond: (version_bom_file_id = vbf.id)
8. 288.904 288.904 ↑ 1.0 1 72,226

Index Scan using version_bom_component_pkey on version_bom_component vbc (cost=0.42..7.63 rows=1 width=29) (actual time=0.003..0.004 rows=1 loops=72,226)

  • Index Cond: (id = vbe.version_bom_component_id)