2010-03-02T06:52:20Z PunBB https://forum.postgresql.org.pl/viewtopic.php?id=127 https://forum.postgresql.org.pl/profile.php?id=1073 2010-03-02T06:52:20Z https://forum.postgresql.org.pl/viewtopic.php?pid=1863#p1863 https://forum.postgresql.org.pl/profile.php?id=519 2009-02-06T19:20:44Z https://forum.postgresql.org.pl/viewtopic.php?pid=531#p531 https://forum.postgresql.org.pl/profile.php?id=583 2009-01-15T07:24:09Z https://forum.postgresql.org.pl/viewtopic.php?pid=464#p464 https://forum.postgresql.org.pl/profile.php?id=26 2009-01-14T11:02:38Z https://forum.postgresql.org.pl/viewtopic.php?pid=463#p463 Bitmap Heap Scan on booklet b (cost=9.32..105.49 rows=106 width=8) (actual time=0.354..0.424 rows=56 loops=1) Recheck Cond: (status = ANY ('{1,2}'::integer[])) Filter: ("type" = 1) -> Bitmap Index Scan on booklet_status_key (cost=0.00..9.30 rows=106 width=0) (actual time=0.155..0.155 rows=809 loops=1) Index Cond: (status = ANY ('{1,2}'::integer[])) -> Hash (cost=325.58..325.58 rows=96 width=4) (actual time=0.045..0.045 rows=0 loops=1) -> Hash Join (cost=11.18..325.58 rows=96 width=4) (actual time=0.044..0.044 rows=0 loops=1) Hash Cond: (bm.id_e = be.id) -> Seq Scan on booklet_matrix bm (cost=0.00..256.86 rows=15086 width=8) (actual time=0.014..0.014 rows=1 loops=1) -> Hash (cost=10.65..10.65 rows=43 width=4) (actual time=0.024..0.024 rows=0 loops=1) -> Index Scan using booklet_elements_status on booklet_elements be (cost=0.00..10.65 rows=43 width=4) (actual time=0.023..0.023 rows=0 loops=1) Index Cond: (status = 1) Total runtime: 0.662 ms (15 rows) Dodanie jednego warunku w podzapytaniu przeszkadza: pcss=# explain ANALYZE select id_f from booklet_matrix bm RIGHT JOIN (select * from booklet_elements be where be.status in (1)) be on be.id = bm.id_e RIGHT JOIN (select * from booklet b where [b]b.id_f=229[/b] and b.status in (1,2)) b on b.id = bm.id_b; QUERY PLAN ----------------------------------------------------------------------------------------------------------------------------------------------------------------- Nested Loop Left Join (cost=20.48..432.24 rows=1 width=4) (actual time=0.449..996.961 rows=42 loops=1) Join Filter: (b.id = bm.id_b) -> Bitmap Heap Scan on booklet b (cost=9.30..105.46 rows=1 width=8) (actual time=0.395..0.509 rows=42 loops=1) Recheck Cond: (status = ANY ('{1,2}'::integer[])) Filter: (id_f = 229) -> Bitmap Index Scan on booklet_status_key (cost=0.00..9.30 rows=106 width=0) (actual time=0.159..0.159 rows=809 loops=1) Index Cond: (status = ANY ('{1,2}'::integer[])) -> Hash Join (cost=11.18..325.58 rows=96 width=4) (actual time=23.721..23.721 rows=0 loops=42) Hash Cond: (bm.id_e = be.id) -> Seq Scan on booklet_matrix bm (cost=0.00..256.86 rows=15086 width=8) (actual time=0.006..11.845 rows=14727 loops=42) -> Hash (cost=10.65..10.65 rows=43 width=4) (actual time=0.025..0.025 rows=0 loops=1) -> Index Scan using booklet_elements_status on booklet_elements be (cost=0.00..10.65 rows=43 width=4) (actual time=0.023..0.023 rows=0 loops=1) Index Cond: (status = 1) Total runtime: 997.060 ms (14 rows) Co poradzic?]]> https://forum.postgresql.org.pl/profile.php?id=583 2009-01-13T14:09:06Z https://forum.postgresql.org.pl/viewtopic.php?pid=462#p462