#	exclusive	inclusive	rows x	rows	loops	node
1.	0.146	15.650	↑ 1.0	1	1	→ Nested Loop (cost=597.90..1,538.13 rows=1 width=53) (actual time=10.268..15.650 rows=1 loops=1) Join Filter: (fis.fk_pessoa_id = pes.id)
2.	0.031	0.031	↑ 1.0	1	1	→ Index Scan using pessoa_nome_idx on pessoa pes (cost=0.00..8.28 rows=1 width=15) (actual time=0.030..0.031 rows=1 loops=1) Index Cond: ((nome)::text = 'cxxks-nome'::text)
3.	0.769	15.473	↑ 1.0	970	1	→ Nested Loop (cost=597.90..1,517.50 rows=987 width=46) (actual time=10.193..15.473 rows=970 loops=1)
4.	1.171	11.794	↑ 1.0	970	1	→ Hash Join (cost=597.90..1,051.92 rows=987 width=31) (actual time=10.181..11.794 rows=970 loops=1) Hash Cond: (c.fk_motorista_id = m.id)
5.	0.600	0.868	↑ 1.0	970	1	→ Bitmap Heap Scan on cartao c (cost=19.90..449.24 rows=987 width=31) (actual time=0.347..0.868 rows=970 loops=1) Recheck Cond: (validade >= '1990-09-03'::date)
6.	0.268	0.268	↑ 1.0	970	1	→ Bitmap Index Scan on cartao_validade_idx (cost=0.00..19.66 rows=987 width=0) (actual time=0.268..0.268 rows=970 loops=1) Index Cond: (validade >= '1990-09-03'::date)
7.	5.465	9.755	↑ 1.0	20,000	1	→ Hash (cost=328.00..328.00 rows=20,000 width=8) (actual time=9.755..9.755 rows=20,000 loops=1) Buckets: 2048 Batches: 1 Memory Usage: 625kB
8.	4.290	4.290	↑ 1.0	20,000	1	→ Seq Scan on motorista m (cost=0.00..328.00 rows=20,000 width=8) (actual time=0.007..4.290 rows=20,000 loops=1)
9.	2.910	2.910	↑ 1.0	1	970	→ Index Scan using pessoa_fisica_pkey on pessoa_fisica fis (cost=0.00..0.46 rows=1 width=23) (actual time=0.003..0.003 rows=1 loops=970) Index Cond: (fis.id = m.fk_pessoa_fisica_id)

"Nested Loop  (cost=597.90..1538.13 rows=1 width=53) (actual time=10.268..15.650 rows=1 loops=1)"
"  Join Filter: (fis.fk_pessoa_id = pes.id)"
"  ->  Index Scan using pessoa_nome_idx on pessoa pes  (cost=0.00..8.28 rows=1 width=15) (actual time=0.030..0.031 rows=1 loops=1)"
"        Index Cond: ((nome)::text = 'cxxks-nome'::text)"
"  ->  Nested Loop  (cost=597.90..1517.50 rows=987 width=46) (actual time=10.193..15.473 rows=970 loops=1)"
"        ->  Hash Join  (cost=597.90..1051.92 rows=987 width=31) (actual time=10.181..11.794 rows=970 loops=1)"
"              Hash Cond: (c.fk_motorista_id = m.id)"
"              ->  Bitmap Heap Scan on cartao c  (cost=19.90..449.24 rows=987 width=31) (actual time=0.347..0.868 rows=970 loops=1)"
"                    Recheck Cond: (validade >= '1990-09-03'::date)"
"                    ->  Bitmap Index Scan on cartao_validade_idx  (cost=0.00..19.66 rows=987 width=0) (actual time=0.268..0.268 rows=970 loops=1)"
"                          Index Cond: (validade >= '1990-09-03'::date)"
"              ->  Hash  (cost=328.00..328.00 rows=20000 width=8) (actual time=9.755..9.755 rows=20000 loops=1)"
"                    Buckets: 2048  Batches: 1  Memory Usage: 625kB"
"                    ->  Seq Scan on motorista m  (cost=0.00..328.00 rows=20000 width=8) (actual time=0.007..4.290 rows=20000 loops=1)"
"        ->  Index Scan using pessoa_fisica_pkey on pessoa_fisica fis  (cost=0.00..0.46 rows=1 width=23) (actual time=0.003..0.003 rows=1 loops=970)"
"              Index Cond: (fis.id = m.fk_pessoa_fisica_id)"
"Total runtime: 16.056 ms"

Per node type stats

node type	count	sum of times	% of query
Bitmap Heap Scan	1	0.600 ms	3.8 %
Bitmap Index Scan	1	0.268 ms	1.7 %
Hash	1	5.465 ms	34.9 %
Hash Join	1	1.171 ms	7.5 %
Index Scan	2	2.941 ms	18.8 %
Nested Loop	2	0.915 ms	5.8 %
Seq Scan	1	4.290 ms	27.4 %

Per table stats

Table name	Scan count	Total time	% of query
scan type	count	sum of times	% of table
cartao	1	0.600 ms	3.8 %
Bitmap Heap Scan	1	0.600 ms	100.0 %
motorista	1	4.290 ms	27.4 %
Seq Scan	1	4.290 ms	100.0 %
pessoa	1	0.031 ms	0.2 %
Index Scan	1	0.031 ms	100.0 %
pessoa_fisica	1	2.910 ms	18.6 %
Index Scan	1	2.910 ms	100.0 %

explain.depesz.com

PostgreSQL's explain analyze made readable

Result: tGhD

Color mode:

Visible columns:

Per node type stats

Per table stats