explain.depesz.com

PostgreSQL's explain analyze made readable

Result: dwMr

Settings

Optimization(s) for this plan:

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

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

2. 0.003 1.400 ↓ 0.0 0 1

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

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

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

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

Bitmap Heap Scan on terms t (cost=13.96..583.84 rows=199 width=41) (actual time=0.033..0.217 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.800 0.800 ↑ 1.0 1 200

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

  • Index Cond: (term_id = t.id)
  • Filter: ((language)::text = 'GB'::text)
  • Rows Removed by Filter: 9
Planning time : 0.235 ms
Execution time : 1.426 ms