explain.depesz.com

PostgreSQL's explain analyze made readable

Result: FDvN : Optimization for: Optimization for: plan #dwMr; plan #nWbC

Settings

Optimization path:

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

Limit (cost=2,257.38..2,257.39 rows=1 width=52) (actual time=1.117..1.117 rows=0 loops=1)

2. 0.004 1.117 ↓ 0.0 0 1

Sort (cost=2,257.38..2,257.39 rows=1 width=52) (actual time=1.117..1.117 rows=0 loops=1)

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

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

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

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

  • Recheck Cond: (data_list_id = 500)
  • Heap Blocks: exact=200
5. 0.016 0.016 ↓ 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.016..0.016 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.263 ms
Execution time : 1.140 ms