#	exclusive	inclusive	rows x	rows	loops	node
1.	0.053	1765.111	↑ 1.0	1	1	→ Aggregate (cost=55922.53..55922.54 rows=1 width=0) (actual time=1765.111..1765.111 rows=1 loops=1)
2.	0.634	1765.058	↓ 45.0	225	1	→ HashAggregate (cost=55922.41..55922.46 rows=5 width=48) (actual time=1764.972..1765.058 rows=225 loops=1)
3.	10.610	1764.424	↓ 45.0	225	1	→ Nested Loop (cost=0.00..55922.31 rows=5 width=48) (actual time=0.428..1764.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	11766	1	→ Append (cost=0.00..18923.03 rows=1863 width=32) (actual time=0.112..47.744 rows=11766 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	11766	1	→ Index Scan using idx_c__text__node_anno_3701 on facts_3701 facts1 (cost=0.00..18912.80 rows=1862 width=32) (actual time=0.109..45.487 rows=11766 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	1706.070	↓ 0.0	0	11766	→ Append (cost=0.00..19.83 rows=2 width=32) (actual time=0.144..0.145 rows=0 loops=11766)
8.	0.000	0.000	↓ 0.0	0	11766	→ Seq Scan on facts facts2 (cost=0.00..10.22 rows=1 width=32) (actual time=0.000..0.000 rows=0 loops=11766) 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.	1694.304	1694.304	↓ 0.0	0	11766	→ 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=11766) 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"))

Aggregate  (cost=55922.53..55922.54 rows=1 width=0) (actual time=1765.111..1765.111 rows=1 loops=1)
  ->  HashAggregate  (cost=55922.41..55922.46 rows=5 width=48) (actual time=1764.972..1765.058 rows=225 loops=1)
        ->  Nested Loop  (cost=0.00..55922.31 rows=5 width=48) (actual time=0.428..1764.424 rows=225 loops=1)
              Join Filter: ((facts1.text_ref = facts2.text_ref) AND (facts1."left" = facts2."left") AND (facts1."right" = facts2."right"))
              ->  Append  (cost=0.00..18923.03 rows=1863 width=32) (actual time=0.112..47.744 rows=11766 loops=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"))
                    ->  Index Scan using idx_c__text__node_anno_3701 on facts_3701 facts1  (cost=0.00..18912.80 rows=1862 width=32) (actual time=0.109..45.487 rows=11766 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"))
              ->  Append  (cost=0.00..19.83 rows=2 width=32) (actual time=0.144..0.145 rows=0 loops=11766)
                    ->  Seq Scan on facts facts2  (cost=0.00..10.22 rows=1 width=32) (actual time=0.000..0.000 rows=0 loops=11766)
                          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"))
                    ->  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=11766)
                          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"))
Total runtime: 1765.532 ms
Time: 1893 ms

Per node type stats

node type	count	sum of times	% of query
Aggregate	1	0.053 ms	0.0 %
Append	2	14.020 ms	0.8 %
HashAggregate	1	0.634 ms	0.0 %
Index Scan	2	1739.791 ms	98.6 %
Nested Loop	1	10.610 ms	0.6 %
Seq Scan	2	0.003 ms	0.0 %

Per table stats

Table name	Scan count	Total time	% of query
scan type	count	sum of times	% of table
facts	2	0.003 ms	0.0 %
Seq Scan	2	0.003 ms	100.0 %
facts_3701	2	1739.791 ms	98.6 %
Index Scan	2	1739.791 ms	100.0 %

explain.depesz.com

A tool for finding a real cause for slow queries.

Result: JBv

Colorize:

Columns visibility:

Per node type stats

Per table stats