explain.depesz.com

PostgreSQL's explain analyze made readable

Result: ILFA

Settings
# exclusive inclusive rows x rows loops node
1. 603.215 112,580.795 ↓ 88.2 592,438 1

Nested Loop (cost=66.54..25,269.24 rows=6,718 width=48) (actual time=29.242..112,580.795 rows=592,438 loops=1)

2. 0.014 0.072 ↑ 1.0 4 1

HashAggregate (cost=33.08..33.12 rows=4 width=4) (actual time=0.064..0.072 rows=4 loops=1)

  • Group Key: words_upper.wordid
3. 0.016 0.058 ↑ 1.0 4 1

Bitmap Heap Scan on words_upper (cost=17.71..33.07 rows=4 width=4) (actual time=0.047..0.058 rows=4 loops=1)

  • Recheck Cond: (word = ANY ('{THIS,IS,A,TEST}'::text[]))
  • Heap Blocks: exact=4
4. 0.042 0.042 ↑ 1.0 4 1

Bitmap Index Scan on wordsupperlist (cost=0.00..17.71 rows=4 width=0) (actual time=0.042..0.042 rows=4 loops=1)

  • Index Cond: (word = ANY ('{THIS,IS,A,TEST}'::text[]))
5. 111,811.376 111,977.508 ↓ 88.2 148,110 4

Bitmap Heap Scan on instances (cost=33.46..6,292.23 rows=1,680 width=48) (actual time=50.211..27,994.377 rows=148,110 loops=4)

  • Recheck Cond: (words_upper_id = words_upper.wordid)
  • Rows Removed by Index Recheck: 3449404
  • Heap Blocks: exact=142665 lossy=132013
6. 166.132 166.132 ↓ 88.2 148,110 4

Bitmap Index Scan on instances_wordsupperid (cost=0.00..33.04 rows=1,680 width=0) (actual time=41.533..41.533 rows=148,110 loops=4)

  • Index Cond: (words_upper_id = words_upper.wordid)