#	exclusive	inclusive	rows x	rows	loops	node
1.	0.714	5,866.661	↑ 2.2	292	1	→ Nested Loop (cost=6.05..1,176,824.80 rows=643 width=777) (actual time=3,825.027..5,866.661 rows=292 loops=1)
2.	0.680	5,857.479	↑ 2.2	292	1	→ Nested Loop (cost=3.02..1,172,293.72 rows=643 width=636) (actual time=3,824.991..5,857.479 rows=292 loops=1)
3.	5,847.747	5,847.747	↑ 2.2	292	1	→ Seq Scan on digitalizacao_pagina (cost=0.00..1,167,762.64 rows=643 width=495) (actual time=3,824.851..5,847.747 rows=292 loops=1) Filter: (digitalizacao_id = 55,356) Rows Removed by Filter: 12,558,060
4.	7.300	9.052	↑ 1.0	1	292	→ Bitmap Heap Scan on usuario usuario_insercao (cost=3.02..7.04 rows=1 width=141) (actual time=0.031..0.031 rows=1 loops=292) Recheck Cond: (id = digitalizacao_pagina.usuario_insercao_id) Heap Blocks: exact=7,008
5.	1.752	1.752	↓ 24.0	24	292	→ Bitmap Index Scan on usuario_pkey (cost=0.00..3.02 rows=1 width=0) (actual time=0.006..0.006 rows=24 loops=292) Index Cond: (id = digitalizacao_pagina.usuario_insercao_id)
6.	7.008	8.468	↑ 1.0	1	292	→ Bitmap Heap Scan on usuario usuario_ultima_atualizacao (cost=3.02..7.04 rows=1 width=141) (actual time=0.029..0.029 rows=1 loops=292) Recheck Cond: (id = digitalizacao_pagina.usuario_ultima_atualizacao_id) Heap Blocks: exact=7,008
7.	1.460	1.460	↓ 24.0	24	292	→ Bitmap Index Scan on usuario_pkey (cost=0.00..3.02 rows=1 width=0) (actual time=0.005..0.005 rows=24 loops=292) Index Cond: (id = digitalizacao_pagina.usuario_ultima_atualizacao_id)

 Nested Loop  (cost=6.05..1176824.80 rows=643 width=777) (actual time=3825.027..5866.661 rows=292 loops=1)
   ->  Nested Loop  (cost=3.02..1172293.72 rows=643 width=636) (actual time=3824.991..5857.479 rows=292 loops=1)
         ->  Seq Scan on digitalizacao_pagina  (cost=0.00..1167762.64 rows=643 width=495) (actual time=3824.851..5847.747 rows=292 loops=1)
               Filter: (digitalizacao_id = 55356)
               Rows Removed by Filter: 12558060
         ->  Bitmap Heap Scan on usuario usuario_insercao  (cost=3.02..7.04 rows=1 width=141) (actual time=0.031..0.031 rows=1 loops=292)
               Recheck Cond: (id = digitalizacao_pagina.usuario_insercao_id)
               Heap Blocks: exact=7008
               ->  Bitmap Index Scan on usuario_pkey  (cost=0.00..3.02 rows=1 width=0) (actual time=0.006..0.006 rows=24 loops=292)
                     Index Cond: (id = digitalizacao_pagina.usuario_insercao_id)
   ->  Bitmap Heap Scan on usuario usuario_ultima_atualizacao  (cost=3.02..7.04 rows=1 width=141) (actual time=0.029..0.029 rows=1 loops=292)
         Recheck Cond: (id = digitalizacao_pagina.usuario_ultima_atualizacao_id)
         Heap Blocks: exact=7008
         ->  Bitmap Index Scan on usuario_pkey  (cost=0.00..3.02 rows=1 width=0) (actual time=0.005..0.005 rows=24 loops=292)
               Index Cond: (id = digitalizacao_pagina.usuario_ultima_atualizacao_id)

Per node type stats

node type	count	sum of times	% of query
Bitmap Heap Scan	2	14.308 ms	0.2 %
Bitmap Index Scan	2	3.212 ms	0.1 %
Nested Loop	2	1.394 ms	0.0 %
Seq Scan	1	5,847.747 ms	99.7 %

Per table stats

Table name	Scan count	Total time	% of query
scan type	count	sum of times	% of table
digitalizacao_pagina	1	5,847.747 ms	99.7 %
Seq Scan	1	5,847.747 ms	100.0 %
usuario	2	14.308 ms	0.2 %
Bitmap Heap Scan	2	14.308 ms	100.0 %

explain.depesz.com

PostgreSQL's explain analyze made readable

Result: o87O

Color mode:

Visible columns:

Optimization(s) for this plan:

Per node type stats

Per table stats