explain.depesz.com

PostgreSQL's explain analyze made readable

Result: KNQT

Settings
# exclusive inclusive rows x rows loops node
1. 0.004 7.356 ↑ 1.0 20 1

Limit (cost=24,893.10..24,895.44 rows=20 width=552) (actual time=6.014..7.356 rows=20 loops=1)

2. 0.000 7.352 ↑ 335.1 20 1

Gather Merge (cost=24,893.10..25,675.06 rows=6,702 width=552) (actual time=6.012..7.352 rows=20 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
3. 0.192 7.638 ↑ 223.4 15 3

Sort (cost=23,893.08..23,901.46 rows=3,351 width=552) (actual time=2.545..2.546 rows=15 loops=3)

  • Sort Key: (((term_translations.name)::text || ''::text))
  • Sort Method: top-N heapsort Memory: 27kB
  • Worker 0: Sort Method: quicksort Memory: 26kB
  • Worker 1: Sort Method: quicksort Memory: 26kB
4. 0.137 7.446 ↑ 93.1 36 3

Nested Loop (cost=2,326.43..23,803.91 rows=3,351 width=552) (actual time=1.027..2.482 rows=36 loops=3)

5. 3.913 6.453 ↑ 93.1 36 3

Parallel Bitmap Heap Scan on term_translations (cost=2,326.01..19,576.34 rows=3,351 width=524) (actual time=0.971..2.151 rows=36 loops=3)

  • Recheck Cond: (lower((name)::text) ~~ '%jkh%'::text)
  • Filter: ((language)::text = 'EN'::text)
  • Rows Removed by Filter: 364
  • Heap Blocks: exact=891
6. 2.540 2.540 ↑ 66.4 1,204 1

Bitmap Index Scan on term_translations_lower_name_idx (cost=0.00..2,324.00 rows=80,000 width=0) (actual time=2.540..2.540 rows=1,204 loops=1)

  • Index Cond: (lower((name)::text) ~~ '%jkh%'::text)
7. 0.856 0.856 ↑ 1.0 1 107

Index Only Scan using terms_pkey on terms (cost=0.42..1.26 rows=1 width=4) (actual time=0.008..0.008 rows=1 loops=107)

  • Index Cond: (id = term_translations.term_id)
  • Heap Fetches: 1
Planning time : 0.226 ms
Execution time : 7.389 ms