Nested Loop Left Join (cost=2128.15..2588.96 rows=1 width=17) (actual time=230.879..1236.247 rows=6 loops=1) Join Filter: (participation_u_4546.proband_id = proband.proband_id) -> Nested Loop (cost=4.31..95.76 rows=1 width=15) (actual time=0.111..0.436 rows=6 loops=1) -> Nested Loop (cost=4.31..91.07 rows=8 width=11) (actual time=0.094..0.247 rows=6 loops=1) -> Bitmap Heap Scan on person (cost=4.31..28.82 rows=8 width=11) (actual time=0.071..0.102 rows=6 loops=1) Recheck Cond: ((givenname)::text = 'Brunhilde'::text) -> Bitmap Index Scan on person_givenname (cost=0.00..4.31 rows=8 width=0) (actual time=0.059..0.059 rows=6 loops=1) Index Cond: ((givenname)::text = 'Brunhilde'::text) -> Index Scan using anon_person_person_id on anon_person (cost=0.00..7.77 rows=1 width=8) (actual time=0.011..0.014 rows=1 loops=6) Index Cond: (anon_person.person_id = person.person_id) -> Index Scan using proband_anon_person_id on proband (cost=0.00..0.57 rows=1 width=8) (actual time=0.020..0.024 rows=1 loops=6) Index Cond: (proband.anon_person_id = anon_person.anon_id) -> Nested Loop (cost=2123.84..2491.66 rows=123 width=6) (actual time=36.635..194.780 rows=6738 loops=6) -> Merge Join (cost=2123.84..2366.32 rows=168 width=8) (actual time=36.615..104.079 rows=6738 loops=6) Merge Cond: (participation_u_4546.participation_id = answer_group_participation_u_4546.participation_id) -> Index Scan using participation_pkey on participation participation_u_4546 (cost=0.00..2329.93 rows=10408 width=8) (actual time=0.027..19.823 rows=9677 loops=6) Filter: (project_id = 1) -> Sort (cost=2123.81..2126.29 rows=992 width=8) (actual time=36.581..46.218 rows=6738 loops=6) Sort Key: answer_group_participation_u_4546.participation_id Sort Method: quicksort Memory: 392kB -> Hash Join (cost=1503.24..2074.44 rows=992 width=8) (actual time=103.238..204.336 rows=6738 loops=1) Hash Cond: (answer_group_participation_u_4546.answer_group_id = answer_group_u_4546.answer_group_id) -> Seq Scan on answer_group_participation answer_group_participation_u_4546 (cost=0.00..448.42 rows=31042 width=8) (actual time=0.013..41.552 rows=31042 loops=1) -> Hash (cost=1490.84..1490.84 rows=992 width=12) (actual time=102.239..102.239 rows=6741 loops=1) -> Hash Join (cost=643.57..1490.84 rows=992 width=12) (actual time=28.156..73.493 rows=6741 loops=1) Hash Cond: (answer_u_4546.answer_group_id = answer_group_u_4546.answer_group_id) -> Bitmap Heap Scan on answer answer_u_4546 (cost=104.42..864.09 rows=6214 width=8) (actual time=1.580..14.690 rows=6741 loops=1) Recheck Cond: (question_id = 118) -> Bitmap Index Scan on answer_question_id (cost=0.00..102.87 rows=6214 width=0) (actual time=1.464..1.464 rows=6741 loops=1) Index Cond: (question_id = 118) -> Hash (cost=442.62..442.62 rows=7722 width=4) (actual time=26.547..26.547 rows=7866 loops=1) -> Bitmap Heap Scan on answer_group answer_group_u_4546 (cost=132.10..442.62 rows=7722 width=4) (actual time=1.662..13.898 rows=7866 loops=1) Recheck Cond: (question_group_id = 12) -> Bitmap Index Scan on question_group_id (cost=0.00..130.17 rows=7722 width=0) (actual time=1.626..1.626 rows=7866 loops=1) Index Cond: (question_group_id = 12) -> Index Scan using ant_bool_antwort_id on ant_bool data_u_4546 (cost=0.00..0.73 rows=1 width=6) (actual time=0.006..0.008 rows=1 loops=40428) Index Cond: (data_u_4546.answer_id = answer_u_4546.answer_id) Total runtime: 1236.514 ms