"Limit  (cost=153329.63..153329.66 rows=15 width=243) (actual time=5253.363..5253.374 rows=15 loops=1)"
"  ->  Sort  (cost=153329.63..154848.84 rows=607686 width=243) (actual time=5253.360..5253.364 rows=15 loops=1)"
"        Sort Key: t0.datefinished"
"        Sort Method: top-N heapsort  Memory: 27kB"
"        ->  HashAggregate  (cost=132343.52..138420.38 rows=607686 width=243) (actual time=4180.249..4814.179 rows=956141 loops=1)"
"              Group Key: t0.datefinished, t0.id, t0.assignee, t0.comment, t0.datecreated, t0.declarant, t0.default_max_interval, t0.default_rest_interval, t0.internal_request_id, t0.last_editor, t0.last_task_groups, t0.max_date, t0.processinstanceid, t0.re (...)"
"              ->  Hash Join  (cost=71723.76..97401.58 rows=607686 width=243) (actual time=1738.606..2977.938 rows=972422 loops=1)"
"                    Hash Cond: (t1.bid_id = t0.id)"
"                    ->  Seq Scan on bidworkers t1  (cost=0.00..15945.33 rows=974833 width=8) (actual time=0.016..193.514 rows=974833 loops=1)"
"                    ->  Hash  (cost=63785.24..63785.24 rows=635082 width=243) (actual time=1734.085..1734.085 rows=956518 loops=1)"
"                          Buckets: 1048576  Batches: 1  Memory Usage: 183017kB"
"                          ->  Seq Scan on bid t0  (cost=0.00..63785.24 rows=635082 width=243) (actual time=0.038..898.270 rows=956518 loops=1)"
"                                Filter: ((type = 4) OR (status = 14) OR ((type = 1) AND (status = 8)) OR ((type = 0) AND (status = ANY ('{6,7,13,8}'::integer[]))) OR ((type = 3) AND (status = ANY ('{6,7,8}'::integer[]))) OR ((type = 2) AND (status = ANY (' (...)"
"                                Rows Removed by Filter: 62263"
"Planning time: 0.800 ms"
"Execution time: 5260.637 ms"

"Limit  (cost=0.85..10.51 rows=15 width=243) (actual time=0.260..0.387 rows=15 loops=1)"
"  ->  Nested Loop  (cost=0.85..391175.57 rows=607686 width=243) (actual time=0.258..0.368 rows=15 loops=1)"
"        ->  Index Scan using datefinished_idx on bid t0  (cost=0.42..84544.96 rows=635082 width=243) (actual time=0.211..0.238 rows=15 loops=1)"
"              Filter: ((type = 4) OR (status = 14) OR ((type = 1) AND (status = 8)) OR ((type = 0) AND (status = ANY ('{6,7,13,8}'::integer[]))) OR ((type = 3) AND (status = ANY ('{6,7,8}'::integer[]))) OR ((type = 2) AND (status = ANY ('{6,9,8}'::integer[ (...)"
"        ->  Index Only Scan using bidworkers_pkey on bidworkers  (cost=0.42..0.47 rows=1 width=8) (actual time=0.006..0.006 rows=1 loops=15)"
"              Index Cond: (bid_id = t0.id)"
"              Heap Fetches: 0"
"Planning time: 0.599 ms"
"Execution time: 0.469 ms"

EXPLAIN ANALYZE SELECT DISTINCT t0.ID AS a1, t0.assignee AS a2, t0.COMMENT AS a3, t0.DATECREATED AS a4, t0.DATEFINISHED AS a5, t0.DECLARANT AS a6, t0.default_max_interval AS a7, t0.default_rest_interval AS a8, t0.internal_request_id AS a9, t0.last_editor AS a10, t0.last_task_groups AS a11, t0.max_date AS a12, t0.PROCESSINSTANCEID AS a13, t0.rest_date AS a14, t0.STATUS AS a15, t0.TAG AS a16, t0.type AS a17, t0.VERSION AS a18, t0.worked_days AS a19, t0.EMPLOYEE_LOGIN AS a20, t0.gid AS a21, t0.PROCEDURE_ID AS a22, t0.PROCEDUREPROCESSDEFINITION_PROCESSDEFINITIONID AS a23
FROM BID t0, bidworkers t1
WHERE (
		(
		(1 = 1) 
			AND (
					(
						(
							(
								(
									(t0.type = 4) OR (t0.STATUS = 14)
								) 
								OR (
									(t0.type = 1) AND (t0.STATUS = 8)
								)
							)
							OR (
								(t0.type = 0) AND (t0.STATUS IN (6,7,13,8))
							)
						) 
						OR (
							(t0.type = 3) AND (t0.STATUS IN (6,7,8))
						)
					) 
					OR (
						(t0.type = 2) AND (t0.STATUS IN (6,9,8))
					)
			)
		)
	 AND (t0.ID = t1.bid_id)) ORDER BY t0.DATEFINISHED ASC LIMIT 15 OFFSET 0;

EXPLAIN ANALYZE SELECT t0.ID AS a1, t0.assignee AS a2, t0.COMMENT AS a3, t0.DATECREATED AS a4, t0.DATEFINISHED AS a5, t0.DECLARANT AS a6, t0.default_max_interval AS a7, t0.default_rest_interval AS a8, t0.internal_request_id AS a9, t0.last_editor AS a10, t0.last_task_groups AS a11, t0.max_date AS a12, t0.PROCESSINSTANCEID AS a13, t0.rest_date AS a14, t0.STATUS AS a15, t0.TAG AS a16, t0.type AS a17, t0.VERSION AS a18, t0.worked_days AS a19, t0.EMPLOYEE_LOGIN AS a20, t0.gid AS a21, t0.PROCEDURE_ID AS a22, t0.PROCEDUREPROCESSDEFINITION_PROCESSDEFINITIONID AS a23
FROM BID t0 INNER JOIN bidworkers ON t0.ID = bidworkers.bid_id
WHERE (
		(
		(1 = 1) 
			AND (
					(
						(
							(
								(
									(t0.type = 4) OR (t0.STATUS = 14)
								) 
								OR (
									(t0.type = 1) AND (t0.STATUS = 8)
								)
							)
							OR (
								(t0.type = 0) AND (t0.STATUS IN (6,7,13,8))
							)
						) 
						OR (
							(t0.type = 3) AND (t0.STATUS IN (6,7,8))
						)
					) 
					OR (
						(t0.type = 2) AND (t0.STATUS IN (6,9,8))
					)
			)
		)
	) 
	ORDER BY t0.DATEFINISHED ASC LIMIT 15 OFFSET 0