explain.depesz.com

A tool for finding a real cause for slow queries.

Result: JBv

options
Did it help? Consider supporting us - Bitcoin address: 12v2hUztAk2LgzQ9H9LMwuU32urHMjZQnq
# exclusive inclusive rows x rows loops node
1. 0.053 1,765.111 ↑ 1.0 1 1

Aggregate (cost=55,922.53..55,922.54 rows=1 width=0) (actual time=1,765.111..1,765.111 rows=1 loops=1)

2. 0.634 1,765.058 ↓ 45.0 225 1

HashAggregate (cost=55,922.41..55,922.46 rows=5 width=48) (actual time=1,764.972..1,765.058 rows=225 loops=1)

3. 10.610 1,764.424 ↓ 45.0 225 1

Nested Loop (cost=0.00..55,922.31 rows=5 width=48) (actual time=0.428..1,764.424 rows=225 loops=1)

  • Join Filter: ((facts1.text_ref = facts2.text_ref) AND (facts1."left" = facts2."left") AND (facts1."right" = facts2."right"))
4. 2.254 47.744 ↓ 6.3 11,766 1

Append (cost=0.00..18,923.03 rows=1,863 width=32) (actual time=0.112..47.744 rows=11,766 loops=1)

5. 0.003 0.003 ↓ 0.0 0 1

Seq Scan on facts facts1 (cost=0.00..10.22 rows=1 width=32) (actual time=0.003..0.003 rows=0 loops=1)

  • Filter: (((node_annotation_value)::text ~ '^N[NE]$'::text) AND ((node_annotation_name)::text = 'pos'::text) AND (toplevel_corpus = 3701) AND ((sample & B'01000'::"bit") = B'01000'::"bit"))
6. 45.487 45.487 ↓ 6.3 11,766 1

Index Scan using idx_c__text__node_anno_3701 on facts_3701 facts1 (cost=0.00..18,912.80 rows=1,862 width=32) (actual time=0.109..45.487 rows=11,766 loops=1)

  • Index Cond: (((node_annotation_name)::text = 'pos'::text) AND ((node_annotation_value)::text ~>=~ 'N'::text) AND ((node_annotation_value)::text ~<~ 'O'::text))
  • Filter: (((node_annotation_value)::text ~ '^N[NE]$'::text) AND (toplevel_corpus = 3701) AND ((sample & B'01000'::"bit") = B'01000'::"bit"))
7. 11.766 1,706.070 ↓ 0.0 0 11,766

Append (cost=0.00..19.83 rows=2 width=32) (actual time=0.144..0.145 rows=0 loops=11,766)

8. 0.000 0.000 ↓ 0.0 0 11,766

Seq Scan on facts facts2 (cost=0.00..10.22 rows=1 width=32) (actual time=0.000..0.000 rows=0 loops=11,766)

  • Filter: (((facts2.node_annotation_value)::text !~ '^N[NE]$'::text) AND (facts2.toplevel_corpus = 3701) AND ((facts2.node_annotation_name)::text = 'ZH1pos'::text) AND ((facts2.sample & B'01000'::"bit") = B'01000'::"bit"))
9. 1,694.304 1,694.304 ↓ 0.0 0 11,766

Index Scan using idx__exact_cover_3701 on facts_3701 facts2 (cost=0.00..9.60 rows=1 width=32) (actual time=0.143..0.144 rows=0 loops=11,766)

  • Index Cond: ((facts2.text_ref = facts1.text_ref) AND (facts2."left" = facts1."left") AND (facts2."right" = facts1."right"))
  • Filter: (((facts2.node_annotation_value)::text !~ '^N[NE]$'::text) AND (facts2.toplevel_corpus = 3701) AND ((facts2.node_annotation_name)::text = 'ZH1pos'::text) AND ((facts2.sample & B'01000'::"bit") = B'01000'::"bit"))