#	exclusive	inclusive	rows x	rows	loops	node
1.	0.009	10481.394	↑ 1.0	15	1	→ Limit (cost=96934.21..96935.78 rows=15 width=316) (actual time=10415.940..10481.394 rows=15 loops=1) Buffers: shared hit=208673, temp read=534 written=1298
2.	6.465	10481.385	↑ 114.4	15	1	→ GroupAggregate (cost=96934.21..97114.39 rows=1716 width=316) (actual time=10415.936..10481.385 rows=15 loops=1) Buffers: shared hit=208673, temp read=534 written=1298
3.	9261.762	10474.920	↓ 1.7	2975	1	→ Sort (cost=96934.21..96938.50 rows=1716 width=316) (actual time=10402.852..10474.920 rows=2975 loops=1) Sort Key: e.id_entreprise, e.id_job, e.id_stock_insee, e.id_stock_bodacc, e.siren, e.nic, e.denomination, e.nom, e.nom_usage, e.prenom, e.adresse, e.code_postal, e.commune, e.d Sort Method: external merge Disk: 10376kB Buffers: shared hit=208673, temp read=534 written=1298
4.	38.201	1213.158	↓ 24.6	42232	1	→ Hash Left Join (cost=56702.95..96842.02 rows=1716 width=316) (actual time=381.467..1213.158 rows=42232 loops=1) Hash Cond: (e.id_code_categorie_juridique = cj.id_code_categorie_juridique) Buffers: shared hit=208657
5.	43.985	1174.332	↓ 24.6	42232	1	→ Hash Left Join (cost=56691.93..96812.41 rows=1716 width=276) (actual time=380.798..1174.332 rows=42232 loops=1) Hash Cond: (e.id_code_naf = nc.id_code) Buffers: shared hit=208653
6.	85.610	1122.233	↓ 24.6	42232	1	→ Nested Loop (cost=56563.01..96658.54 rows=1716 width=229) (actual time=372.619..1122.233 rows=42232 loops=1) Buffers: shared hit=208609
7.	328.729	867.695	↓ 24.6	42232	1	→ Hash Join (cost=56563.01..86936.80 rows=1716 width=12) (actual time=372.508..867.695 rows=42232 loops=1) Hash Cond: (edp.id_entreprise = i.id_entreprise) Buffers: shared hit=39596
8.	166.591	166.591	↓ 1.0	660765	1	→ Seq Scan on entreprise_document_presse edp (cost=0.00..22282.39 rows=645939 width=8) (actual time=0.042..166.591 rows=660765 loops=1) Buffers: shared hit=15823
9.	28.360	372.375	↑ 1.1	30267	1	→ Hash (cost=56163.96..56163.96 rows=31924 width=4) (actual time=372.375..372.375 rows=30267 loops=1) Buckets: 4096 Batches: 1 Memory Usage: 1065kB Buffers: shared hit=23773
10.	344.015	344.015	↑ 1.1	30267	1	→ Bitmap Heap Scan on index_entreprise_fulltext i (cost=2141.41..56163.96 rows=31924 width=4) (actual time=89.824..344.015 rows=30267 loops=1) Recheck Cond: (lexemes_denom @@ '''paris'''::tsquery) Buffers: shared hit=23773 -> Bitmap Index Scan on idx_index_entreprise_fulltext_lexemes_denom (cost=0.00..2133.43 rows=31924 width=0) (actual time=75.147..75.147 ro Index Cond: (lexemes_denom @@ '''paris'''::tsquery) Buffers: shared hit=969
11.	168.928	168.928	↑ 1.0	1	42232	→ Index Scan using entreprise_pkey on entreprise e (cost=0.00..5.65 rows=1 width=229) (actual time=0.004..0.004 rows=1 loops=42232) Index Cond: (id_entreprise = i.id_entreprise) Buffers: shared hit=169013
12.	4.806	8.114	↑ 1.0	3774	1	→ Hash (cost=81.74..81.74 rows=3774 width=51) (actual time=8.114..8.114 rows=3774 loops=1) Buckets: 1024 Batches: 1 Memory Usage: 315kB Buffers: shared hit=44
13.	3.308	3.308	↑ 1.0	3774	1	→ Seq Scan on code nc (cost=0.00..81.74 rows=3774 width=51) (actual time=0.040..3.308 rows=3774 loops=1) Buffers: shared hit=44
14.	0.357	0.625	↑ 1.0	312	1	→ Hash (cost=7.12..7.12 rows=312 width=42) (actual time=0.625..0.625 rows=312 loops=1) Buckets: 1024 Batches: 1 Memory Usage: 23kB Buffers: shared hit=4
15.	0.268	0.268	↑ 1.0	312	1	→ Seq Scan on code_categorie_juridique cj (cost=0.00..7.12 rows=312 width=42) (actual time=0.023..0.268 rows=312 loops=1) Buffers: shared hit=4

 Limit  (cost=96934.21..96935.78 rows=15 width=316) (actual time=10415.940..10481.394 rows=15 loops=1)
   Buffers: shared hit=208673, temp read=534 written=1298
   ->  GroupAggregate  (cost=96934.21..97114.39 rows=1716 width=316) (actual time=10415.936..10481.385 rows=15 loops=1)
         Buffers: shared hit=208673, temp read=534 written=1298
         ->  Sort  (cost=96934.21..96938.50 rows=1716 width=316) (actual time=10402.852..10474.920 rows=2975 loops=1)
               Sort Key: e.id_entreprise, e.id_job, e.id_stock_insee, e.id_stock_bodacc, e.siren, e.nic, e.denomination, e.nom, e.nom_usage, e.prenom, e.adresse, e.code_postal, e.commune, e.d
epartement, e.sigle, e.enseigne, e.nom_commercial, e.id_code_categorie_juridique, e.id_code_naf, e.capital, e.id_code_devise_capital, e.date_immatriculation, e.date_creation, e.effectif, e.tc
a, e.tranche_effectif, e.nb_etablissement, e.date_radiation, e.is_personne_physique, e.date_maj, e.id_code_etat, e.id_code_origine_source, e.segment, nc.code, nc.libelle, cj.libelle
               Sort Method: external merge  Disk: 10376kB
               Buffers: shared hit=208673, temp read=534 written=1298
               ->  Hash Left Join  (cost=56702.95..96842.02 rows=1716 width=316) (actual time=381.467..1213.158 rows=42232 loops=1)
                     Hash Cond: (e.id_code_categorie_juridique = cj.id_code_categorie_juridique)
                     Buffers: shared hit=208657
                     ->  Hash Left Join  (cost=56691.93..96812.41 rows=1716 width=276) (actual time=380.798..1174.332 rows=42232 loops=1)
                           Hash Cond: (e.id_code_naf = nc.id_code)
                           Buffers: shared hit=208653
                           ->  Nested Loop  (cost=56563.01..96658.54 rows=1716 width=229) (actual time=372.619..1122.233 rows=42232 loops=1)
                                 Buffers: shared hit=208609
                                 ->  Hash Join  (cost=56563.01..86936.80 rows=1716 width=12) (actual time=372.508..867.695 rows=42232 loops=1)
                                       Hash Cond: (edp.id_entreprise = i.id_entreprise)
                                       Buffers: shared hit=39596
                                       ->  Seq Scan on entreprise_document_presse edp  (cost=0.00..22282.39 rows=645939 width=8) (actual time=0.042..166.591 rows=660765 loops=1)
                                             Buffers: shared hit=15823
                                       ->  Hash  (cost=56163.96..56163.96 rows=31924 width=4) (actual time=372.375..372.375 rows=30267 loops=1)
                                             Buckets: 4096  Batches: 1  Memory Usage: 1065kB
                                             Buffers: shared hit=23773
                                             ->  Bitmap Heap Scan on index_entreprise_fulltext i  (cost=2141.41..56163.96 rows=31924 width=4) (actual time=89.824..344.015 rows=30267 loops=1)
                                                   Recheck Cond: (lexemes_denom @@ '''paris'''::tsquery)
                                                   Buffers: shared hit=23773
                                                   ->  Bitmap Index Scan on idx_index_entreprise_fulltext_lexemes_denom  (cost=0.00..2133.43 rows=31924 width=0) (actual time=75.147..75.147 ro
ws=30586 loops=1)
                                                         Index Cond: (lexemes_denom @@ '''paris'''::tsquery)
                                                         Buffers: shared hit=969
                                 ->  Index Scan using entreprise_pkey on entreprise e  (cost=0.00..5.65 rows=1 width=229) (actual time=0.004..0.004 rows=1 loops=42232)
                                       Index Cond: (id_entreprise = i.id_entreprise)
                                       Buffers: shared hit=169013
                           ->  Hash  (cost=81.74..81.74 rows=3774 width=51) (actual time=8.114..8.114 rows=3774 loops=1)
                                 Buckets: 1024  Batches: 1  Memory Usage: 315kB
                                 Buffers: shared hit=44
                                 ->  Seq Scan on code nc  (cost=0.00..81.74 rows=3774 width=51) (actual time=0.040..3.308 rows=3774 loops=1)
                                       Buffers: shared hit=44
                     ->  Hash  (cost=7.12..7.12 rows=312 width=42) (actual time=0.625..0.625 rows=312 loops=1)
                           Buckets: 1024  Batches: 1  Memory Usage: 23kB
                           Buffers: shared hit=4
                           ->  Seq Scan on code_categorie_juridique cj  (cost=0.00..7.12 rows=312 width=42) (actual time=0.023..0.268 rows=312 loops=1)
                                 Buffers: shared hit=4
 Total runtime: 10486.435 ms

Per node type stats

node type	count	sum of times	% of query
Bitmap Heap Scan	1	344.015 ms	3.3 %
GroupAggregate	1	6.465 ms	0.1 %
Hash	3	33.523 ms	0.3 %
Hash Join	1	328.729 ms	3.1 %
Hash Left Join	2	82.186 ms	0.8 %
Index Scan	1	168.928 ms	1.6 %
Limit	1	0.009 ms	0.0 %
Nested Loop	1	85.610 ms	0.8 %
Seq Scan	3	170.167 ms	1.6 %
Sort	1	9261.762 ms	88.4 %

Per table stats

Table name	Scan count	Total time	% of query
scan type	count	sum of times	% of table
code	1	3.308 ms	0.0 %
Seq Scan	1	3.308 ms	100.0 %
code_categorie_juridique	1	0.268 ms	0.0 %
Seq Scan	1	0.268 ms	100.0 %
entreprise	1	168.928 ms	1.6 %
Index Scan	1	168.928 ms	100.0 %
entreprise_document_presse	1	166.591 ms	1.6 %
Seq Scan	1	166.591 ms	100.0 %
index_entreprise_fulltext	1	344.015 ms	3.3 %
Bitmap Heap Scan	1	344.015 ms	100.0 %

explain.depesz.com

A tool for finding a real cause for slow queries.

Result: n8P

Colorize:

Columns visibility:

Per node type stats

Per table stats