#	exclusive	inclusive	rows x	rows	loops	node
1.	388.860	388.860	↑ 1.5	82	1	→ Seq Scan on textes (cost=0.00..46,931.09 rows=126 width=106) (actual time=53.920..388.860 rows=82 loops=1) Filter: (contenu ~~ '%fantine%'::text) Rows Removed by Filter: 1576245

 Seq Scan on textes  (cost=0.00..46931.09 rows=126 width=106) (actual time=53.920..388.860 rows=82 loops=1)
   Filter: (contenu ~~ '%fantine%'::text)
   Rows Removed by Filter: 1576245
 Planning time: 0.411 ms
 Execution time: 388.898 ms
(5 lignes)

Per node type stats

node type	count	sum of times	% of query
Seq Scan	1	388.860 ms	100.0 %

Per table stats

Table name	Scan count	Total time	% of query
scan type	count	sum of times	% of table
textes	1	388.860 ms	100.0 %
Seq Scan	1	388.860 ms	100.0 %

explain.depesz.com

PostgreSQL's explain analyze made readable

Result: bBI

Color mode:

Visible columns:

Per node type stats

Per table stats