explain.depesz.com

PostgreSQL's explain analyze made readable

Result: iMIE

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

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

2. 0.004 1.387 ↓ 0.0 0 1

Sort (cost=2,289.70..2,289.70 rows=1 width=36) (actual time=1.386..1.387 rows=0 loops=1)

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

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

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

Bitmap Heap Scan on terms t (cost=13.96..583.84 rows=199 width=25) (actual time=0.033..0.220 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.241 ms
Execution time : 1.419 ms