explain.depesz.com

PostgreSQL's explain analyze made readable

Result: o87O

Settings

Optimization(s) for this plan:

# 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 = 55356)
  • Rows Removed by Filter: 12558060
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=7008
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=7008
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)