explain.depesz.com

A tool for finding a real cause for slow queries.

Result: phNk

options
Did it help? Consider supporting us - Bitcoin address: 12v2hUztAk2LgzQ9H9LMwuU32urHMjZQnq
# exclusive inclusive rows x rows loops node
1. 0.000 0.000 ↓ 0.0

Aggregate (cost=111,853.75..111,853.76 rows=1 width=0) (actual time=.. rows= loops=)

2. 0.000 0.000 ↓ 0.0

HashAggregate (cost=111,853.34..111,853.52 rows=18 width=48) (actual time=.. rows= loops=)

3. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.00..111,852.98 rows=18 width=48) (actual time=.. rows= loops=)

  • Join Filter: ((facts1.text_ref = facts2.text_ref) AND (facts1."left" = facts2."left") AND (facts1."right" = facts2."right"))
4. 0.000 0.000 ↓ 0.0

Append (cost=0.00..35,831.26 rows=3,605 width=32) (actual time=.. rows= loops=)

5. 0.000 0.000 ↓ 0.0

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

  • Filter: (((node_annotation_value)::text ~ '^N[NE]$'::text) AND ((node_annotation_name)::text = 'pos'::text) AND (toplevel_corpus = 4139) AND ((sample & B'01000'::"bit") = B'01000'::"bit"))
6. 0.000 0.000 ↓ 0.0

Index Scan using idx_c__parent__node_anno_4139 on facts_4139 facts1 (cost=0.00..35,821.03 rows=3,604 width=32) (actual time=.. rows= loops=)

  • 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 = 4139) AND ((sample & B'01000'::"bit") = B'01000'::"bit"))
7. 0.000 0.000 ↓ 0.0

Append (cost=0.00..21.05 rows=2 width=32) (actual time=.. rows= loops=)

8. 0.000 0.000 ↓ 0.0

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

  • Filter: (((facts2.node_annotation_value)::text !~ '^N[NE]$'::text) AND (facts2.toplevel_corpus = 4139) AND ((facts2.node_annotation_name)::text = 'ZH1pos'::text) AND ((facts2.sample & B'01000'::"bit") = B'01000'::"bit"))
9. 0.000 0.000 ↓ 0.0

Index Scan using idx__exact_cover_4139 on facts_4139 facts2 (cost=0.00..10.83 rows=1 width=32) (actual time=.. rows= loops=)

  • 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 = 4139) AND ((facts2.node_annotation_name)::text = 'ZH1pos'::text) AND ((facts2.sample & B'01000'::"bit") = B'01000'::"bit"))