Result: dFy

options

HTML
TEXT
STATS

exclusive	inclusive	rows x	rows	loops	node
0.310	1342.411	↑ 72.3	669	1	→ Sort (cost=94584.74..94705.64 rows=48360 width=12) (actual time=1342.365..1342.411 rows=669 loops=1) Output: main.cix_lcontentkey, main.cix_dtepublishfrom Sort Key: main.cix_dtepublishfrom Sort Method: quicksort Memory: 56kB Buffers: shared hit=33255 read=9674
3.800	1342.101	↑ 72.3	669	1	→ HashAggregate (cost=90338.36..90821.96 rows=48360 width=12) (actual time=1341.921..1342.101 rows=669 loops=1) Output: main.cix_lcontentkey, main.cix_dtepublishfrom Buffers: shared hit=33255 read=9674
9.269	1338.301	↑ 39.9	12117	1	→ Hash Join (cost=18604.98..87920.39 rows=483594 width=12) (actual time=226.334..1338.301 rows=12117 loops=1) Output: main.cix_lcontentkey, main.cix_dtepublishfrom Hash Cond: (main.cix_lcontentkey = security.coa_con_lkey) Buffers: shared hit=33255 read=9674
1252.346	1278.758	↑ 39.9	12117	1	→ Seq Scan on public.tcontentindex main (cost=12090.94..72757.81 rows=483594 width=12) (actual time=176.049..1278.758 rows=12117 loops=1) Output: main.cix_skey, main.cix_lcontentkey, main.cix_lcontentstatus, main.cix_dtepublishfrom, main.cix_dtepublishto, main.cix_lcontenttypekey, main.cix_lcategorykey, main.cix_spath, main.cix_svalue, main.cix_sordervalue, main.cix_fnumvalue Filter: ((main.cix_lcontentstatus = 2) AND (main.cix_dtepublishfrom <= to_date('2012-01-05 13:16:48'::text, 'YYYY-MM-DD HH24:MI:SS'::text)) AND ((main.cix_dtepublishto IS NULL) OR (main.cix_dtepublishto > to_date('2012-01-05 13:16:48'::text, 'YYYY-MM-DD HH24:MI:SS'::text))) AND (((hashed SubPlan 1) AND ((hashed SubPlan 2) OR (hashed SubPlan 3))) OR ((hashed SubPlan 4) AND (hashed SubPlan 5)))) Buffers: shared hit=28898 read=9674
					SubPlan (forSeq Scan)
5.016	6.782	↓ 19.6	6727	1	→ Bitmap Heap Scan on public.tcontentindex contentind1_ (cost=39.45..1300.30 rows=343 width=4) (actual time=2.236..6.782 rows=6727 loops=1) Output: contentind1_.cix_lcontentkey Recheck Cond: ((((contentind1_.cix_svalue)::text = 'artikkel'::text) AND ((contentind1_.cix_spath)::text ~~ 'contenttype'::text)) OR (((contentind1_.cix_svalue)::text = 'tidsskriftsartikkel'::text) AND ((contentind1_.cix_spath)::text ~~ 'contenttype'::text)) OR (((contentind1_.cix_svalue)::text = 'publikasjon'::text) AND ((contentind1_.cix_spath)::text ~~ 'contenttype'::text)) OR (((contentind1_.cix_svalue)::text = 'publikasjon-sammendrag'::text) AND ((contentind1_.cix_spath)::text ~~ 'contenttype'::text))) Filter: ((contentind1_.cix_spath)::text ~~ 'contenttype'::text) Buffers: shared hit=3170
0.002	1.766	↓ 0.0	0	1	→ BitmapOr (cost=39.45..39.45 rows=344 width=0) (actual time=1.766..1.766 rows=0 loops=1) Buffers: shared hit=60
0.294	0.294	↓ 17.3	1001	1	→ Bitmap Index Scan on idx_cix_t2 (cost=0.00..9.50 rows=58 width=0) (actual time=0.294..0.294 rows=1001 loops=1) Index Cond: (((contentind1_.cix_svalue)::text = 'artikkel'::text) AND ((contentind1_.cix_spath)::text = 'contenttype'::text)) Buffers: shared hit=10
0.292	0.292	↓ 22.6	926	1	→ Bitmap Index Scan on idx_cix_t2 (cost=0.00..5.33 rows=41 width=0) (actual time=0.292..0.292 rows=926 loops=1) Index Cond: (((contentind1_.cix_svalue)::text = 'tidsskriftsartikkel'::text) AND ((contentind1_.cix_spath)::text = 'contenttype'::text)) Buffers: shared hit=11
0.647	0.647	↓ 17.9	2468	1	→ Bitmap Index Scan on idx_cix_t2 (cost=0.00..14.30 rows=138 width=0) (actual time=0.647..0.647 rows=2468 loops=1) Index Cond: (((contentind1_.cix_svalue)::text = 'publikasjon'::text) AND ((contentind1_.cix_spath)::text = 'contenttype'::text)) Buffers: shared hit=17
0.531	0.531	↓ 21.8	2332	1	→ Bitmap Index Scan on idx_cix_t2 (cost=0.00..9.99 rows=107 width=0) (actual time=0.531..0.531 rows=2332 loops=1) Index Cond: (((contentind1_.cix_svalue)::text = 'publikasjon-sammendrag'::text) AND ((contentind1_.cix_spath)::text = 'contenttype'::text)) Buffers: shared hit=22
0.330	0.626	↓ 366.0	366	1	→ Bitmap Heap Scan on public.tcontentindex contentind2_ (cost=36.00..948.28 rows=1 width=4) (actual time=0.326..0.626 rows=366 loops=1) Output: contentind2_.cix_lcontentkey Recheck Cond: ((contentind2_.cix_sordervalue)::text = ANY ('{10z9hxvywcz85c,10z9hlezf69qf4,10z8i9agq61i4g,10z8hkchrsmio0,10z8g6gjv1sjr4,10z8fhikwodkao,10zhev6guaqoe8,10z572zgi2g3k0}'::text[])) Filter: ((contentind2_.cix_spath)::text ~~ 'data#primaremne_key'::text) Buffers: shared hit=216
0.296	0.296	↓ 2.0	499	1	→ Bitmap Index Scan on idx_cix_4 (cost=0.00..36.00 rows=245 width=0) (actual time=0.296..0.296 rows=499 loops=1) Index Cond: ((contentind2_.cix_sordervalue)::text = ANY ('{10z9hxvywcz85c,10z9hlezf69qf4,10z8i9agq61i4g,10z8hkchrsmio0,10z8g6gjv1sjr4,10z8fhikwodkao,10zhev6guaqoe8,10z572zgi2g3k0}'::text[])) Buffers: shared hit=25
0.198	0.455	↓ 41.3	124	1	→ Bitmap Heap Scan on public.tcontentindex contentind3_ (cost=36.00..948.28 rows=3 width=4) (actual time=0.277..0.455 rows=124 loops=1) Output: contentind3_.cix_lcontentkey Recheck Cond: ((contentind3_.cix_sordervalue)::text = ANY ('{10z9hxvywcz85c,10z9hlezf69qf4,10z8i9agq61i4g,10z8hkchrsmio0,10z8g6gjv1sjr4,10z8fhikwodkao,10zhev6guaqoe8,10z572zgi2g3k0}'::text[])) Filter: ((contentind3_.cix_spath)::text ~~ 'data#sekundaremner_key'::text) Buffers: shared hit=216
0.257	0.257	↓ 2.0	499	1	→ Bitmap Index Scan on idx_cix_4 (cost=0.00..36.00 rows=245 width=0) (actual time=0.257..0.257 rows=499 loops=1) Index Cond: ((contentind3_.cix_sordervalue)::text = ANY ('{10z9hxvywcz85c,10z9hlezf69qf4,10z8i9agq61i4g,10z8hkchrsmio0,10z8g6gjv1sjr4,10z8fhikwodkao,10zhev6guaqoe8,10z572zgi2g3k0}'::text[])) Buffers: shared hit=25
12.862	16.863	↓ 18.4	18307	1	→ Bitmap Heap Scan on public.tcontentindex contentind4_ (cost=83.10..3451.28 rows=994 width=4) (actual time=5.237..16.863 rows=18307 loops=1) Output: contentind4_.cix_lcontentkey Recheck Cond: ((contentind4_.cix_svalue)::text = 'publisering'::text) Filter: ((contentind4_.cix_spath)::text ~~ 'contenttype'::text) Buffers: shared hit=7231
4.001	4.001	↓ 18.4	18307	1	→ Bitmap Index Scan on idx_cix_t2 (cost=0.00..82.86 rows=994 width=0) (actual time=4.001..4.001 rows=18307 loops=1) Index Cond: (((contentind4_.cix_svalue)::text = 'publisering'::text) AND ((contentind4_.cix_spath)::text = 'contenttype'::text)) Buffers: shared hit=95
0.393	1.686	↓ 10.2	327	1	→ Bitmap Heap Scan on public.tcontentindex contentind5_ (cost=233.30..5439.37 rows=32 width=4) (actual time=1.340..1.686 rows=327 loops=1) Output: contentind5_.cix_lcontentkey Recheck Cond: ((contentind5_.cix_sordervalue)::text = ANY ('{10zfj1tk52mj28,10zgb9otvw33eo,10zgbinjdva60w,10zggzh39grpxc,10zgh1t9wxs000,10zgh5pl024gsg,10zgh8ttvcsu80,10zghcq4yh5b0g,10zghfudtrtog0,10zghi6kh8tyio,10zghmgwoa0gzk,10zghnn000im0w,10zghpz6nhiw3k,10zghspeevd7uo,10zghtvhqlvcw0,10zghvfm697jls,10zghwlphzpon4,10zghxrstq7tog,10zghyxw5gpyps,10zgi0i0l425fk,10zgi1o3wukagw,10zgi388chwh6o,10zgi4scs58nwg,10zgi4zdc3noqo,10zgi5kezywr9c,10zgia8sawxbeo,10zgiex5luxvk0,10zgig38xlg0lc,10zgikrm8jgkqo,10zgip1yfkn37k,10zgiuidycbqps,10zgiysq5di96o,10zgj14wsuij9c,10zgjjue0mkruo,10zgjlsjk6r08w,10zhl8g30kpm2o,10zhlbdbbwyyo0,10zhldphzdz8qo,10zhpeoyeoglc0,10zhpevyymvm68,10zhph85m3vw8w,10zhphf662ax34,10zhpjdbpmh5hc,10zhpjkc9kw6bk,10zhplwix1wge8,10zhpm3jh0bh8g,10zhpqrwryc1ds,10zhpqyxbwr280,10zhpsx2vgxam8,10zhpt43ffcbgg,10zi9p9oluz0n4,10zi9tgiiwy0ow}'::text[])) Filter: ((contentind5_.cix_spath)::text ~~ 'data#variant_key'::text) Buffers: shared hit=465
1.293	1.293	↑ 4.2	375	1	→ Bitmap Index Scan on idx_cix_4 (cost=0.00..233.29 rows=1592 width=0) (actual time=1.293..1.293 rows=375 loops=1) Index Cond: ((contentind5_.cix_sordervalue)::text = ANY ('{10zfj1tk52mj28,10zgb9otvw33eo,10zgbinjdva60w,10zggzh39grpxc,10zgh1t9wxs000,10zgh5pl024gsg,10zgh8ttvcsu80,10zghcq4yh5b0g,10zghfudtrtog0,10zghi6kh8tyio,10zghmgwoa0gzk,10zghnn000im0w,10zghpz6nhiw3k,10zghspeevd7uo,10zghtvhqlvcw0,10zghvfm697jls,10zghwlphzpon4,10zghxrstq7tog,10zghyxw5gpyps,10zgi0i0l425fk,10zgi1o3wukagw,10zgi388chwh6o,10zgi4scs58nwg,10zgi4zdc3noqo,10zgi5kezywr9c,10zgia8sawxbeo,10zgiex5luxvk0,10zgig38xlg0lc,10zgikrm8jgkqo,10zgip1yfkn37k,10zgiuidycbqps,10zgiysq5di96o,10zgj14wsuij9c,10zgjjue0mkruo,10zgjlsjk6r08w,10zhl8g30kpm2o,10zhlbdbbwyyo0,10zhldphzdz8qo,10zhpeoyeoglc0,10zhpevyymvm68,10zhph85m3vw8w,10zhphf662ax34,10zhpjdbpmh5hc,10zhpjkc9kw6bk,10zhplwix1wge8,10zhpm3jh0bh8g,10zhpqrwryc1ds,10zhpqyxbwr280,10zhpsx2vgxam8,10zhpt43ffcbgg,10zi9p9oluz0n4,10zi9tgiiwy0ow}'::text[])) Buffers: shared hit=157
8.242	50.274	↓ 5.9	38180	1	→ Hash (cost=6433.53..6433.53 rows=6441 width=4) (actual time=50.274..50.274 rows=38180 loops=1) Output: security.coa_con_lkey Buckets: 1024 Batches: 1 Memory Usage: 1343kB Buffers: shared hit=4357
23.935	42.032	↓ 5.9	38180	1	→ HashAggregate (cost=6369.12..6433.53 rows=6441 width=4) (actual time=33.168..42.032 rows=38180 loops=1) Output: security.coa_con_lkey Buffers: shared hit=4357
13.422	18.097	↓ 1.0	38180	1	→ Bitmap Heap Scan on public.tconaccessright2 security (cost=1524.79..6276.07 rows=37219 width=4) (actual time=5.280..18.097 rows=38180 loops=1) Output: security.coa_skey, security.coa_con_lkey, security.coa_grp_hkey, security.coa_bread, security.coa_bupdate, security.coa_bdelete Recheck Cond: (security.coa_grp_hkey = 'A7F7BFB405684FE109869BC48C5A0359260783C1'::bpchar) Filter: (security.coa_bread = 1) Buffers: shared hit=4357
4.675	4.675	↓ 1.0	38180	1	→ Bitmap Index Scan on idx_coa_2 (cost=0.00..1515.48 rows=37219 width=0) (actual time=4.675..4.675 rows=38180 loops=1) Index Cond: (security.coa_grp_hkey = 'A7F7BFB405684FE109869BC48C5A0359260783C1'::bpchar) Buffers: shared hit=316

"Sort  (cost=94584.74..94705.64 rows=48360 width=12) (actual time=1342.365..1342.411 rows=669 loops=1)"
"  Output: main.cix_lcontentkey, main.cix_dtepublishfrom"
"  Sort Key: main.cix_dtepublishfrom"
"  Sort Method:  quicksort  Memory: 56kB"
"  Buffers: shared hit=33255 read=9674"
"  ->  HashAggregate  (cost=90338.36..90821.96 rows=48360 width=12) (actual time=1341.921..1342.101 rows=669 loops=1)"
"        Output: main.cix_lcontentkey, main.cix_dtepublishfrom"
"        Buffers: shared hit=33255 read=9674"
"        ->  Hash Join  (cost=18604.98..87920.39 rows=483594 width=12) (actual time=226.334..1338.301 rows=12117 loops=1)"
"              Output: main.cix_lcontentkey, main.cix_dtepublishfrom"
"              Hash Cond: (main.cix_lcontentkey = security.coa_con_lkey)"
"              Buffers: shared hit=33255 read=9674"
"              ->  Seq Scan on public.tcontentindex main  (cost=12090.94..72757.81 rows=483594 width=12) (actual time=176.049..1278.758 rows=12117 loops=1)"
"                    Output: main.cix_skey, main.cix_lcontentkey, main.cix_lcontentstatus, main.cix_dtepublishfrom, main.cix_dtepublishto, main.cix_lcontenttypekey, main.cix_lcategorykey, main.cix_spath, main.cix_svalue, main.cix_sordervalue, main.cix_fnumvalue"
"                    Filter: ((main.cix_lcontentstatus = 2) AND (main.cix_dtepublishfrom <= to_date('2012-01-05 13:16:48'::text, 'YYYY-MM-DD HH24:MI:SS'::text)) AND ((main.cix_dtepublishto IS NULL) OR (main.cix_dtepublishto > to_date('2012-01-05 13:16:48'::text, 'YYYY-MM-DD HH24:MI:SS'::text))) AND (((hashed SubPlan 1) AND ((hashed SubPlan 2) OR (hashed SubPlan 3))) OR ((hashed SubPlan 4) AND (hashed SubPlan 5))))"
"                    Buffers: shared hit=28898 read=9674"
"                    SubPlan 1"
"                      ->  Bitmap Heap Scan on public.tcontentindex contentind1_  (cost=39.45..1300.30 rows=343 width=4) (actual time=2.236..6.782 rows=6727 loops=1)"
"                            Output: contentind1_.cix_lcontentkey"
"                            Recheck Cond: ((((contentind1_.cix_svalue)::text = 'artikkel'::text) AND ((contentind1_.cix_spath)::text ~~ 'contenttype'::text)) OR (((contentind1_.cix_svalue)::text = 'tidsskriftsartikkel'::text) AND ((contentind1_.cix_spath)::text ~~ 'contenttype'::text)) OR (((contentind1_.cix_svalue)::text = 'publikasjon'::text) AND ((contentind1_.cix_spath)::text ~~ 'contenttype'::text)) OR (((contentind1_.cix_svalue)::text = 'publikasjon-sammendrag'::text) AND ((contentind1_.cix_spath)::text ~~ 'contenttype'::text)))"
"                            Filter: ((contentind1_.cix_spath)::text ~~ 'contenttype'::text)"
"                            Buffers: shared hit=3170"
"                            ->  BitmapOr  (cost=39.45..39.45 rows=344 width=0) (actual time=1.766..1.766 rows=0 loops=1)"
"                                  Buffers: shared hit=60"
"                                  ->  Bitmap Index Scan on idx_cix_t2  (cost=0.00..9.50 rows=58 width=0) (actual time=0.294..0.294 rows=1001 loops=1)"
"                                        Index Cond: (((contentind1_.cix_svalue)::text = 'artikkel'::text) AND ((contentind1_.cix_spath)::text = 'contenttype'::text))"
"                                        Buffers: shared hit=10"
"                                  ->  Bitmap Index Scan on idx_cix_t2  (cost=0.00..5.33 rows=41 width=0) (actual time=0.292..0.292 rows=926 loops=1)"
"                                        Index Cond: (((contentind1_.cix_svalue)::text = 'tidsskriftsartikkel'::text) AND ((contentind1_.cix_spath)::text = 'contenttype'::text))"
"                                        Buffers: shared hit=11"
"                                  ->  Bitmap Index Scan on idx_cix_t2  (cost=0.00..14.30 rows=138 width=0) (actual time=0.647..0.647 rows=2468 loops=1)"
"                                        Index Cond: (((contentind1_.cix_svalue)::text = 'publikasjon'::text) AND ((contentind1_.cix_spath)::text = 'contenttype'::text))"
"                                        Buffers: shared hit=17"
"                                  ->  Bitmap Index Scan on idx_cix_t2  (cost=0.00..9.99 rows=107 width=0) (actual time=0.531..0.531 rows=2332 loops=1)"
"                                        Index Cond: (((contentind1_.cix_svalue)::text = 'publikasjon-sammendrag'::text) AND ((contentind1_.cix_spath)::text = 'contenttype'::text))"
"                                        Buffers: shared hit=22"
"                    SubPlan 2"
"                      ->  Bitmap Heap Scan on public.tcontentindex contentind2_  (cost=36.00..948.28 rows=1 width=4) (actual time=0.326..0.626 rows=366 loops=1)"
"                            Output: contentind2_.cix_lcontentkey"
"                            Recheck Cond: ((contentind2_.cix_sordervalue)::text = ANY ('{10z9hxvywcz85c,10z9hlezf69qf4,10z8i9agq61i4g,10z8hkchrsmio0,10z8g6gjv1sjr4,10z8fhikwodkao,10zhev6guaqoe8,10z572zgi2g3k0}'::text[]))"
"                            Filter: ((contentind2_.cix_spath)::text ~~ 'data#primaremne_key'::text)"
"                            Buffers: shared hit=216"
"                            ->  Bitmap Index Scan on idx_cix_4  (cost=0.00..36.00 rows=245 width=0) (actual time=0.296..0.296 rows=499 loops=1)"
"                                  Index Cond: ((contentind2_.cix_sordervalue)::text = ANY ('{10z9hxvywcz85c,10z9hlezf69qf4,10z8i9agq61i4g,10z8hkchrsmio0,10z8g6gjv1sjr4,10z8fhikwodkao,10zhev6guaqoe8,10z572zgi2g3k0}'::text[]))"
"                                  Buffers: shared hit=25"
"                    SubPlan 3"
"                      ->  Bitmap Heap Scan on public.tcontentindex contentind3_  (cost=36.00..948.28 rows=3 width=4) (actual time=0.277..0.455 rows=124 loops=1)"
"                            Output: contentind3_.cix_lcontentkey"
"                            Recheck Cond: ((contentind3_.cix_sordervalue)::text = ANY ('{10z9hxvywcz85c,10z9hlezf69qf4,10z8i9agq61i4g,10z8hkchrsmio0,10z8g6gjv1sjr4,10z8fhikwodkao,10zhev6guaqoe8,10z572zgi2g3k0}'::text[]))"
"                            Filter: ((contentind3_.cix_spath)::text ~~ 'data#sekundaremner_key'::text)"
"                            Buffers: shared hit=216"
"                            ->  Bitmap Index Scan on idx_cix_4  (cost=0.00..36.00 rows=245 width=0) (actual time=0.257..0.257 rows=499 loops=1)"
"                                  Index Cond: ((contentind3_.cix_sordervalue)::text = ANY ('{10z9hxvywcz85c,10z9hlezf69qf4,10z8i9agq61i4g,10z8hkchrsmio0,10z8g6gjv1sjr4,10z8fhikwodkao,10zhev6guaqoe8,10z572zgi2g3k0}'::text[]))"
"                                  Buffers: shared hit=25"
"                    SubPlan 4"
"                      ->  Bitmap Heap Scan on public.tcontentindex contentind4_  (cost=83.10..3451.28 rows=994 width=4) (actual time=5.237..16.863 rows=18307 loops=1)"
"                            Output: contentind4_.cix_lcontentkey"
"                            Recheck Cond: ((contentind4_.cix_svalue)::text = 'publisering'::text)"
"                            Filter: ((contentind4_.cix_spath)::text ~~ 'contenttype'::text)"
"                            Buffers: shared hit=7231"
"                            ->  Bitmap Index Scan on idx_cix_t2  (cost=0.00..82.86 rows=994 width=0) (actual time=4.001..4.001 rows=18307 loops=1)"
"                                  Index Cond: (((contentind4_.cix_svalue)::text = 'publisering'::text) AND ((contentind4_.cix_spath)::text = 'contenttype'::text))"
"                                  Buffers: shared hit=95"
"                    SubPlan 5"
"                      ->  Bitmap Heap Scan on public.tcontentindex contentind5_  (cost=233.30..5439.37 rows=32 width=4) (actual time=1.340..1.686 rows=327 loops=1)"
"                            Output: contentind5_.cix_lcontentkey"
"                            Recheck Cond: ((contentind5_.cix_sordervalue)::text = ANY ('{10zfj1tk52mj28,10zgb9otvw33eo,10zgbinjdva60w,10zggzh39grpxc,10zgh1t9wxs000,10zgh5pl024gsg,10zgh8ttvcsu80,10zghcq4yh5b0g,10zghfudtrtog0,10zghi6kh8tyio,10zghmgwoa0gzk,10zghnn000im0w,10zghpz6nhiw3k,10zghspeevd7uo,10zghtvhqlvcw0,10zghvfm697jls,10zghwlphzpon4,10zghxrstq7tog,10zghyxw5gpyps,10zgi0i0l425fk,10zgi1o3wukagw,10zgi388chwh6o,10zgi4scs58nwg,10zgi4zdc3noqo,10zgi5kezywr9c,10zgia8sawxbeo,10zgiex5luxvk0,10zgig38xlg0lc,10zgikrm8jgkqo,10zgip1yfkn37k,10zgiuidycbqps,10zgiysq5di96o,10zgj14wsuij9c,10zgjjue0mkruo,10zgjlsjk6r08w,10zhl8g30kpm2o,10zhlbdbbwyyo0,10zhldphzdz8qo,10zhpeoyeoglc0,10zhpevyymvm68,10zhph85m3vw8w,10zhphf662ax34,10zhpjdbpmh5hc,10zhpjkc9kw6bk,10zhplwix1wge8,10zhpm3jh0bh8g,10zhpqrwryc1ds,10zhpqyxbwr280,10zhpsx2vgxam8,10zhpt43ffcbgg,10zi9p9oluz0n4,10zi9tgiiwy0ow}'::text[]))"
"                            Filter: ((contentind5_.cix_spath)::text ~~ 'data#variant_key'::text)"
"                            Buffers: shared hit=465"
"                            ->  Bitmap Index Scan on idx_cix_4  (cost=0.00..233.29 rows=1592 width=0) (actual time=1.293..1.293 rows=375 loops=1)"
"                                  Index Cond: ((contentind5_.cix_sordervalue)::text = ANY ('{10zfj1tk52mj28,10zgb9otvw33eo,10zgbinjdva60w,10zggzh39grpxc,10zgh1t9wxs000,10zgh5pl024gsg,10zgh8ttvcsu80,10zghcq4yh5b0g,10zghfudtrtog0,10zghi6kh8tyio,10zghmgwoa0gzk,10zghnn000im0w,10zghpz6nhiw3k,10zghspeevd7uo,10zghtvhqlvcw0,10zghvfm697jls,10zghwlphzpon4,10zghxrstq7tog,10zghyxw5gpyps,10zgi0i0l425fk,10zgi1o3wukagw,10zgi388chwh6o,10zgi4scs58nwg,10zgi4zdc3noqo,10zgi5kezywr9c,10zgia8sawxbeo,10zgiex5luxvk0,10zgig38xlg0lc,10zgikrm8jgkqo,10zgip1yfkn37k,10zgiuidycbqps,10zgiysq5di96o,10zgj14wsuij9c,10zgjjue0mkruo,10zgjlsjk6r08w,10zhl8g30kpm2o,10zhlbdbbwyyo0,10zhldphzdz8qo,10zhpeoyeoglc0,10zhpevyymvm68,10zhph85m3vw8w,10zhphf662ax34,10zhpjdbpmh5hc,10zhpjkc9kw6bk,10zhplwix1wge8,10zhpm3jh0bh8g,10zhpqrwryc1ds,10zhpqyxbwr280,10zhpsx2vgxam8,10zhpt43ffcbgg,10zi9p9oluz0n4,10zi9tgiiwy0ow}'::text[]))"
"                                  Buffers: shared hit=157"
"              ->  Hash  (cost=6433.53..6433.53 rows=6441 width=4) (actual time=50.274..50.274 rows=38180 loops=1)"
"                    Output: security.coa_con_lkey"
"                    Buckets: 1024  Batches: 1  Memory Usage: 1343kB"
"                    Buffers: shared hit=4357"
"                    ->  HashAggregate  (cost=6369.12..6433.53 rows=6441 width=4) (actual time=33.168..42.032 rows=38180 loops=1)"
"                          Output: security.coa_con_lkey"
"                          Buffers: shared hit=4357"
"                          ->  Bitmap Heap Scan on public.tconaccessright2 security  (cost=1524.79..6276.07 rows=37219 width=4) (actual time=5.280..18.097 rows=38180 loops=1)"
"                                Output: security.coa_skey, security.coa_con_lkey, security.coa_grp_hkey, security.coa_bread, security.coa_bupdate, security.coa_bdelete"
"                                Recheck Cond: (security.coa_grp_hkey = 'A7F7BFB405684FE109869BC48C5A0359260783C1'::bpchar)"
"                                Filter: (security.coa_bread = 1)"
"                                Buffers: shared hit=4357"
"                                ->  Bitmap Index Scan on idx_coa_2  (cost=0.00..1515.48 rows=37219 width=0) (actual time=4.675..4.675 rows=38180 loops=1)"
"                                      Index Cond: (security.coa_grp_hkey = 'A7F7BFB405684FE109869BC48C5A0359260783C1'::bpchar)"
"                                      Buffers: shared hit=316"
"Total runtime: 1343.966 ms"

Per node type stats

node type	count	sum of times	% of query
Bitmap Heap Scan	6	32.221 ms	2.4 %
Bitmap Index Scan	9	12.286 ms	0.9 %
BitmapOr	1	0.002 ms	0.0 %
Hash	1	8.242 ms	0.6 %
Hash Join	1	9.269 ms	0.7 %
HashAggregate	2	27.735 ms	2.1 %
Seq Scan	1	1252.346 ms	93.3 %
Sort	1	0.310 ms	0.0 %

Per table stats

Table name	Scan count	Total time	% of query
scan type	count	sum of times	% of table
public.tconaccessright2	1	13.422 ms	1.0 %
Bitmap Heap Scan	1	13.422 ms	100.0 %
public.tcontentindex	6	1271.145 ms	94.7 %
Bitmap Heap Scan	5	18.799 ms	1.5 %
Seq Scan	1	1252.346 ms	98.5 %

explain.depesz.com

A tool for finding a real cause for slow queries.

Result: dFy

Colorize:

Columns visibility:

Per node type stats

Per table stats