1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21
| QUERY PLAN
HashAggregate (cost=1591990.92..1591997.10 rows=495 width=8) (actual time=20900.329..20900.347 rows=91 loops=1)
-> Hash Join (cost=440192.16..1561728.30 rows=6052523 width=8) (actual time=7234.902..19308.790 rows=8799081 loops=1)
Hash Cond: (lien_champ__phrase._fils = lien_niveau__phrase._fils)
-> Bitmap Heap Scan on lien_champ__phrase (cost=98982.94..983268.66 rows=6052523 width=16) (actual time=2551.189..8178.639 rows=8831662 loops=1)
Recheck Cond: (_pere = ANY ('{4,5,25,26,27,31,32,33,34,35,36,38,39,41,50,55,59,65,69,82,86,87,88,89,92,93,94,96,97,98,99,100,114,115,116,122,124,126,144,145,149,315,385,406,409,411,416,418,422,434,610,632,638,752,801,843,966,991,1000,1017,1018,1019,1020,1021,1022,1023,1024,1108,1433,1807,1994,2675,2676,3795,3807,3808,3895,3896,3897,3898,3899,3900,3901,3902,3903,4084,4937,5094,5106,5174,5175}'::bigint[]))
-> Bitmap Index Scan on idx_lien_champ__phrase__pere (cost=0.00..97469.81 rows=6052523 width=0) (actual time=2548.434..2548.434 rows=8831663 loops=1)
Index Cond: (_pere = ANY ('{4,5,25,26,27,31,32,33,34,35,36,38,39,41,50,55,59,65,69,82,86,87,88,89,92,93,94,96,97,98,99,100,114,115,116,122,124,126,144,145,149,315,385,406,409,411,416,418,422,434,610,632,638,752,801,843,966,991,1000,1017,1018,1019,1020,1021,1022,1023,1024,1108,1433,1807,1994,2675,2676,3795,3807,3808,3895,3896,3897,3898,3899,3900,3901,3902,3903,4084,4937,5094,5106,5174,5175}'::bigint[]))
-> Hash (cost=196752.43..196752.43 rows=8804943 width=8) (actual time=4410.270..4410.270 rows=8804905 loops=1)
-> Seq Scan on lien_niveau__phrase (cost=0.00..196752.43 rows=8804943 width=8) (actual time=0.018..2012.535 rows=8804905 loops=1)
Total runtime: 20900.534 ms |
Partager