Result: i59

options

HTML
TEXT
STATS

exclusive	inclusive	rows x	rows	loops	node
9.578	9.578	↓ 1.0	20073	1	→ Seq Scan on bati_a00_ident_local (cost=0.00..986.45 rows=19164 width=4) (actual time=4.190..9.578 rows=20073 loops=1) Filter: (id_fantoir_commune = 320013)

"Seq Scan on bati_a00_ident_local  (cost=0.00..986.45 rows=19164 width=4) (actual time=4.190..9.578 rows=20073 loops=1)"
"  Filter: (id_fantoir_commune = 320013)"
"Total runtime: 10.787 ms"

Per node type stats

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

Per table stats

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

explain.depesz.com

A tool for finding a real cause for slow queries.

Result: i59

Colorize:

Columns visibility:

Per node type stats

Per table stats