explain.depesz.com

PostgreSQL's explain analyze made readable

Result: nWbC : Optimization for: plan #dwMr

Settings

Optimization path:

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 0.001 1.228 ↓ 0.0 0 1

Limit (cost=2,257.88..2,257.88 rows=1 width=52) (actual time=1.228..1.228 rows=0 loops=1)

2. 0.003 1.227 ↓ 0.0 0 1

Sort (cost=2,257.88..2,257.88 rows=1 width=52) (actual time=1.227..1.227 rows=0 loops=1)

  • Sort Key: (COALESCE(NULLIF(btrim((tt.name)::text), ''::text), (t.name_en)::text))
  • Sort Method: quicksort Memory: 25kB
3. 0.413 1.224 ↓ 0.0 0 1

Nested Loop Left Join (cost=14.39..2,257.87 rows=1 width=52) (actual time=1.224..1.224 rows=0 loops=1)

  • Filter: ((lower((tt.name)::text) ~~ '%123%'::text) OR (((lower((tt.name)::text) = ''::text) IS NOT FALSE) AND (lower((t.name_en)::text) ~~ '%123%'::text)))
  • Rows Removed by Filter: 200
4. 0.194 0.211 ↓ 1.0 200 1

Bitmap Heap Scan on terms t (cost=13.96..583.84 rows=199 width=41) (actual time=0.033..0.211 rows=200 loops=1)

  • Recheck Cond: (data_list_id = 500)
  • Heap Blocks: exact=200
5. 0.017 0.017 ↓ 1.0 200 1

Bitmap Index Scan on terms_data_list_id_idx (cost=0.00..13.91 rows=199 width=0) (actual time=0.017..0.017 rows=200 loops=1)

  • Index Cond: (data_list_id = 500)
6. 0.600 0.600 ↑ 1.0 1 200

Index Scan using term_translations_term_id_language_index on term_translations tt (cost=0.43..8.39 rows=1 width=29) (actual time=0.003..0.003 rows=1 loops=200)

  • Index Cond: ((term_id = t.id) AND ((language)::text = 'GB'::text))
Planning time : 0.227 ms
Execution time : 1.251 ms