explain.depesz.com

PostgreSQL's explain analyze made readable

Result: rriX

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 11,101.443 ↓ 3.0 6 1

Limit (cost=10,578.72..10,578.73 rows=2 width=69) (actual time=11,101.442..11,101.443 rows=6 loops=1)

2.          

Initplan (forLimit)

3. 0.034 0.034 ↑ 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.033..0.034 rows=1 loops=1)

  • Index Cond: (release_id = '3e6d43b5-0a7e-4181-9bc5-c56f36b7a9be'::uuid)
4. 0.061 11,101.440 ↓ 3.0 6 1

Sort (cost=10,570.43..10,570.44 rows=2 width=69) (actual time=11,101.439..11,101.440 rows=6 loops=1)

  • Sort Key: vbf.file_name DESC
  • Sort Method: quicksort Memory: 25kB
5. 0.024 11,101.379 ↓ 3.0 6 1

Nested Loop (cost=1.27..10,570.42 rows=2 width=69) (actual time=6,170.782..11,101.379 rows=6 loops=1)

6. 0.052 11,098.649 ↓ 3.0 6 1

Nested Loop (cost=0.85..10,555.13 rows=2 width=56) (actual time=6,169.486..11,098.649 rows=6 loops=1)

7. 11,098.279 11,098.279 ↓ 6.0 6 1

Index Scan using idx_version_bom_file_version_bom_id on version_bom_file vbf (cost=0.43..10,546.68 rows=1 width=21) (actual time=6,169.420..11,098.279 rows=6 loops=1)

  • Index Cond: (version_bom_id = $0)
  • Filter: (file_name ~~ '%zuul%'::text)
  • Rows Removed by Filter: 72220
8. 0.318 0.318 ↑ 1.0 1 6

Index Scan using idx_version_bom_entry_version_bom_file_id on version_bom_entry vbe (cost=0.43..8.45 rows=1 width=51) (actual time=0.053..0.053 rows=1 loops=6)

  • Index Cond: (version_bom_file_id = vbf.id)
9. 2.706 2.706 ↑ 1.0 1 6

Index Scan using version_bom_component_pkey on version_bom_component vbc (cost=0.42..7.63 rows=1 width=29) (actual time=0.450..0.451 rows=1 loops=6)

  • Index Cond: (id = vbe.version_bom_component_id)
Planning time : 0.969 ms
Execution time : 11,101.560 ms