#	exclusive	inclusive	rows x	rows	loops	node
1.	79.471	79.471	↓ 1.0	8,356	1	→ Seq Scan on voitures_orig (cost=0.00..1,962.00 rows=8,264 width=25) (actual time=0.012..79.471 rows=8,356 loops=1) Filter: (caracteristiques ~ '[[:<:]]toit ouvrant[[:>:]]'::text) Rows Removed by Filter: 91644

                                                    QUERY PLAN                                                    
------------------------------------------------------------------------------------------------------------------
 Seq Scan on voitures_orig  (cost=0.00..1962.00 rows=8264 width=25) (actual time=0.012..79.471 rows=8356 loops=1)
   Filter: (caracteristiques ~ '[[:<:]]toit ouvrant[[:>:]]'::text)
   Rows Removed by Filter: 91644
 Planning time: 0.388 ms
 Execution time: 79.668 ms
(5 lignes)

Per node type stats

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

Per table stats

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

explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 9ggy

Color mode:

Visible columns:

Per node type stats

Per table stats