explain.depesz.com

PostgreSQL's explain analyze made readable

Result: uJcc

Settings
# exclusive inclusive rows x rows loops node
1. 0.017 715.465 ↑ 1.0 4 1

Unique (cost=13,229.48..13,229.53 rows=4 width=81) (actual time=715.446..715.465 rows=4 loops=1)

2. 2.472 715.448 ↑ 1.0 4 1

Sort (cost=13,229.48..13,229.49 rows=4 width=81) (actual time=715.442..715.448 rows=4 loops=1)

  • Sort Key: meuperfilm0_.adicionado_em, meuperfil1_.id, meuperfilm0_.modulo, meuperfilm0_.id
  • Sort Method: quicksort Memory: 25kB
3. 0.000 712.976 ↑ 1.0 4 1

Nested Loop (cost=1,008.87..13,229.44 rows=4 width=81) (actual time=7.421..712.976 rows=4 loops=1)

4. 0.092 0.092 ↑ 1.0 1 1

Index Only Scan using tb_usuario_pkey on tb_usuario usuario2_ (cost=0.42..4.44 rows=1 width=16) (actual time=0.087..0.092 rows=1 loops=1)

  • Index Cond: (id = '713fee89-c3ce-496a-820f-5a2f1b6d2868'::uuid)
  • Heap Fetches: 1
5. 22.073 720.929 ↑ 1.0 4 1

Gather (cost=1,008.45..13,224.96 rows=4 width=97) (actual time=7.325..720.929 rows=4 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
6. 317.536 698.856 ↑ 2.0 1 3 / 3

Hash Join (cost=8.45..12,224.56 rows=2 width=97) (actual time=463.843..698.856 rows=1 loops=3)

  • Hash Cond: (meuperfilm0_.id_meu_perfil = meuperfil1_.id)
7. 381.209 381.209 ↑ 1.2 184,606 3 / 3

Parallel Seq Scan on tb_meu_perfil_modulo_favorito meuperfilm0_ (cost=0.00..11,610.35 rows=230,757 width=81) (actual time=0.019..381.209 rows=184,606 loops=3)

  • Filter: (((status = 1) OR (status IS NULL)) AND ((sistema)::text = 'PORTAL_ALUNO'::text))
8. 0.009 0.111 ↑ 1.0 1 3 / 3

Hash (cost=8.44..8.44 rows=1 width=32) (actual time=0.110..0.111 rows=1 loops=3)

  • Buckets: 1,024 Batches: 1 Memory Usage: 9kB
9. 0.102 0.102 ↑ 1.0 1 3 / 3

Index Scan using idx_bd_tb_meu_perfil_id_usuario on tb_meu_perfil meuperfil1_ (cost=0.42..8.44 rows=1 width=32) (actual time=0.099..0.102 rows=1 loops=3)

  • Index Cond: (id_usuario = '713fee89-c3ce-496a-820f-5a2f1b6d2868'::uuid)
Planning time : 17.161 ms
Execution time : 723.664 ms