explain.depesz.com

PostgreSQL's explain analyze made readable

Result: g6Dr

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 0.014 ↓ 0.0 0 1

Limit (cost=9.94..13,404.12 rows=100 width=69) (actual time=0.014..0.014 rows=0 loops=1)

  • Planning time: 1.098 ms
  • Execution time: 0.086 ms
2.          

Initplan (forLimit)

3. 0.009 0.009 ↓ 0.0 0 1

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

  • Index Cond: (release_id = '93205808-83dd-4dce-905f-285cd7d9b9ba'::uuid)
4. 0.001 0.013 ↓ 0.0 0 1

Nested Loop (cost=1.65..61,748.80 rows=461 width=69) (actual time=0.013..0.013 rows=0 loops=1)

  • Join Filter: ((vbf.file_name ~~ '%ntact%'::text) OR (vbc.project_name ~~ '%Apache%'::text))
5. 0.000 0.012 ↓ 0.0 0 1

Nested Loop (cost=1.23..27,046.38 rows=4,537 width=56) (actual time=0.012..0.012 rows=0 loops=1)

6. 0.012 0.012 ↓ 0.0 0 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=0.012..0.012 rows=0 loops=1)

  • Index Cond: (version_bom_id = $0)
  • Heap Fetches: 0
7. 0.000 0.000 ↓ 0.0 0

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) (never executed)

  • Index Cond: (version_bom_file_id = vbf.id)
8. 0.000 0.000 ↓ 0.0 0

Index Scan using version_bom_component_pkey on version_bom_component vbc (cost=0.42..7.63 rows=1 width=29) (never executed)

  • Index Cond: (id = vbe.version_bom_component_id)