explain.depesz.com

A tool for finding a real cause for slow queries.

Result: ghX

options
# exclusive inclusive rows x rows loops node
1. 0.005 0.029 ↑ 1.0 1 1
→

Aggregate (cost=503.39..503.40 rows=1 width=0) (actual time=0.028..0.029 rows=1 loops=1)

2. 0.001 0.024 ↓ 0.0 0 1
→

Nested Loop (cost=115.36..503.39 rows=1 width=0) (actual time=0.024..0.024 rows=0 loops=1)

3. 0.001 0.023 ↓ 0.0 0 1
→

Nested Loop (cost=115.36..503.11 rows=1 width=5) (actual time=0.023..0.023 rows=0 loops=1)

4. 0.001 0.022 ↓ 0.0 0 1
→

Nested Loop (cost=115.36..502.71 rows=1 width=10) (actual time=0.022..0.022 rows=0 loops=1)

5. 0.000 0.021 ↓ 0.0 0 1
→

Nested Loop (cost=115.36..501.65 rows=1 width=15) (actual time=0.021..0.021 rows=0 loops=1)

6. 0.001 0.021 ↓ 0.0 0 1
→

Nested Loop (cost=115.36..497.21 rows=1 width=28) (actual time=0.021..0.021 rows=0 loops=1)

  • Join Filter: ((t.security_group_id = s.security_group_id) AND ((s.language_id = t.language_id) OR (s.is_default_language_fl = 'Y'::bpchar)))
7. 0.001 0.020 ↓ 0.0 0 1
→

Nested Loop (cost=115.36..479.92 rows=4 width=33) (actual time=0.020..0.020 rows=0 loops=1)

  • Join Filter: (t.security_group_id = uam.security_group_id)
8. 0.001 0.019 ↓ 0.0 0 1
→

GroupAggregate (cost=0.00..27.51 rows=2 width=20) (actual time=0.019..0.019 rows=0 loops=1)

9. 0.018 0.018 ↓ 0.0 0 1
→

Index Scan using usr_ast_acs_mp_u_usr_scr_g_a_p on user_asset_access_map uam (cost=0.00..27.02 rows=15 width=20) (actual time=0.018..0.018 rows=0 loops=1)

  • Index Cond: (user_id = 2220::numeric)
10. 0.000 0.000 ↓ 0.0 0
→

Materialize (cost=115.36..448.35 rows=147 width=28) (actual time=.. rows= loops=0)

11. 0.000 0.000 ↓ 0.0 0
→

Bitmap Heap Scan on search_for_tracks t (cost=115.36..447.61 rows=147 width=28) (actual time=.. rows= loops=0)

  • Recheck Cond: ((track_title)::text % 'ugly part of me'::text)
  • Filter: (((audio_asset_id IS NOT NULL) OR (video_asset_id IS NOT NULL) OR (dvd_chapter_asset_id IS NOT NULL)) AND (business_unit_id = 1::numeric))
12. 0.000 0.000 ↓ 0.0 0
→

Bitmap Index Scan on search_for_tracks_i_track_titl (cost=0.00..115.32 rows=176 width=0) (actual time=.. rows= loops=0)

  • Index Cond: ((track_title)::text % 'ugly part of me'::text)
13. 0.000 0.000 ↓ 0.0 0
→

Index Scan using search_for_products_i_prdt_tln on search_for_products s (cost=0.00..4.30 rows=1 width=29) (actual time=.. rows= loops=0)

  • Index Cond: ((product_id = t.product_id) AND (talent_id = t.talent_id))
  • Filter: ((((((document_asset_count + graphic_asset_count) + binary_asset_count) + digital_booklet_asset_count) + interactive_media_asset_count) > 0::numeric) OR (dvd_asset_count > 0::numeric) OR ((video_asset_count + interactive_media_bonus_vd_cnt) > 0::numeric) OR (((audio_asset_count + wav_24_bit_asset_count) + wav_16_bit_asset_count) > 0::numeric))
14. 0.000 0.000 ↓ 0.0 0
→

Index Scan using products_pk on products p (cost=0.00..4.42 rows=1 width=6) (actual time=.. rows= loops=0)

  • Index Cond: (product_id = s.product_id)
  • Filter: (data_provider_id <> 1::numeric)
15. 0.000 0.000 ↓ 0.0 0
→

Seq Scan on business_units bu (cost=0.00..1.05 rows=1 width=5) (actual time=.. rows= loops=0)

  • Filter: (business_unit_id = 1::numeric)
16. 0.000 0.000 ↓ 0.0 0
→

Index Scan using languages_pk on languages l (cost=0.00..0.39 rows=1 width=5) (actual time=.. rows= loops=0)

  • Index Cond: (language_id = t.language_id)
17. 0.000 0.000 ↓ 0.0 0
→

Index Scan using product_configurations_pk on product_configurations pc (cost=0.00..0.27 rows=1 width=5) (actual time=.. rows= loops=0)

  • Index Cond: (product_configuration_id = s.product_configuration_id)