explain.depesz.com

PostgreSQL's explain analyze made readable

Result: IF6W

Settings
# exclusive inclusive rows x rows loops node
1. 0.004 1,190.590 ↓ 12.0 12 1

Limit (cost=1,009.46..37,087.07 rows=1 width=47) (actual time=1,178.997..1,190.590 rows=12 loops=1)

  • Buffers: shared hit=4989957
2. 14.708 1,190.586 ↓ 12.0 12 1

Gather (cost=1,009.46..37,087.07 rows=1 width=47) (actual time=1,178.996..1,190.586 rows=12 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
  • Buffers: shared hit=4989957
3. 0.067 1,175.878 ↓ 6.0 6 3

Nested Loop (cost=9.46..36,086.97 rows=1 width=47) (actual time=1,175.802..1,175.878 rows=6 loops=3)

  • Buffers: shared hit=4989957
4. 1,035.828 1,175.798 ↓ 6.0 6 3

Nested Loop (cost=9.03..36,082.60 rows=1 width=16) (actual time=1,175.775..1,175.798 rows=6 loops=3)

  • Buffers: shared hit=4989887
5. 75.494 139.968 ↓ 160,640.3 481,921 3

Hash Join (cost=8.59..36,044.45 rows=3 width=8) (actual time=0.138..139.968 rows=481,921 loops=3)

  • Hash Cond: (oa.operation_entity_id = p2.filler_id)
  • Buffers: shared hit=10740
6. 64.437 64.437 ↑ 2.3 481,921 3

Parallel Seq Scan on operation_account oa (cost=0.00..33,149.72 rows=1,099,468 width=16) (actual time=0.015..64.437 rows=481,921 loops=3)

  • Filter: (account_type_id = 1)
  • Rows Removed by Filter: 69
  • Buffers: shared hit=10635
7. 0.004 0.037 ↑ 1.0 1 3

Hash (cost=8.58..8.58 rows=1 width=8) (actual time=0.037..0.037 rows=1 loops=3)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
  • Buffers: shared hit=17
8. 0.033 0.033 ↑ 1.0 1 3

Index Scan using ix_process_id_uuid on process p2 (cost=0.56..8.58 rows=1 width=8) (actual time=0.032..0.033 rows=1 loops=3)

  • Index Cond: (id_uuid = 'f5b3c354-c48a-4de0-8613-b0bb68d73cd0'::uuid)
  • Filter: (process_template_id = 82)
  • Buffers: shared hit=17
9. 0.002 0.002 ↓ 0.0 0 1,445,762

Index Scan using ix_process_filler_id on process p (cost=0.44..12.69 rows=3 width=24) (actual time=0.002..0.002 rows=0 loops=1,445,762)

  • Index Cond: (filler_id = oa.account_entity_id)
  • Filter: (process_template_id = ANY ('{89,112}'::bigint[]))
  • Rows Removed by Filter: 0
  • Buffers: shared hit=4979147
10. 0.013 0.013 ↑ 1.0 1 17

Index Scan using idx_entity_uuid on entity e (cost=0.43..4.36 rows=1 width=63) (actual time=0.013..0.013 rows=1 loops=17)

  • Index Cond: (id_uuid = p.filler_id_uuid)
  • Buffers: shared hit=70