explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 5KIf : Optimization for: plan #o87O

Settings

Optimization path:

# exclusive inclusive rows x rows loops node
1. 0.875 21.951 ↑ 2.2 292 1

Nested Loop (cost=6.49..9,690.49 rows=644 width=775) (actual time=0.258..21.951 rows=292 loops=1)

2. 0.853 11.440 ↑ 2.2 292 1

Nested Loop (cost=3.46..5,149.36 rows=644 width=635) (actual time=0.199..11.440 rows=292 loops=1)

3. 0.659 0.659 ↑ 2.2 292 1

Index Scan using digitalizacao_pagina_digitalizacao_id_idx on digitalizacao_pagina (cost=0.43..608.23 rows=644 width=495) (actual time=0.055..0.659 rows=292 loops=1)

  • Index Cond: (digitalizacao_id = 55356)
4. 8.176 9.928 ↑ 1.0 1 292

Bitmap Heap Scan on usuario usuario_insercao (cost=3.03..7.04 rows=1 width=140) (actual time=0.034..0.034 rows=1 loops=292)

  • Recheck Cond: (id = digitalizacao_pagina.usuario_insercao_id)
  • Heap Blocks: exact=7300
5. 1.752 1.752 ↓ 25.0 25 292

Bitmap Index Scan on usuario_pkey (cost=0.00..3.03 rows=1 width=0) (actual time=0.006..0.006 rows=25 loops=292)

  • Index Cond: (id = digitalizacao_pagina.usuario_insercao_id)
6. 7.884 9.636 ↑ 1.0 1 292

Bitmap Heap Scan on usuario usuario_ultima_atualizacao (cost=3.03..7.04 rows=1 width=140) (actual time=0.033..0.033 rows=1 loops=292)

  • Recheck Cond: (id = digitalizacao_pagina.usuario_ultima_atualizacao_id)
  • Heap Blocks: exact=7300
7. 1.752 1.752 ↓ 25.0 25 292

Bitmap Index Scan on usuario_pkey (cost=0.00..3.03 rows=1 width=0) (actual time=0.006..0.006 rows=25 loops=292)

  • Index Cond: (id = digitalizacao_pagina.usuario_ultima_atualizacao_id)