explain.depesz.com

PostgreSQL's explain analyze made readable

Result: T9L7

Settings
# exclusive inclusive rows x rows loops node
1. 0.003 1,144.674 ↓ 12.0 12 1

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

  • Output: e.id, e.name, e.vat_number, e.email
2. 14.273 1,144.671 ↓ 12.0 12 1

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

  • Output: e.id, e.name, e.vat_number, e.email
  • Workers Planned: 2
  • Workers Launched: 2
3. 0.077 1,130.398 ↓ 7.0 7 3

Nested Loop (cost=9.46..36,086.97 rows=1 width=47) (actual time=1,130.312..1,130.398 rows=7 loops=3)

  • Output: e.id, e.name, e.vat_number, e.email
  • Worker 0: actual time=1128.675..1128.835 rows=12 loops=1
  • Worker 1: actual time=1129.266..1129.366 rows=7 loops=1
4. 1,000.091 1,130.308 ↓ 7.0 7 3

Nested Loop (cost=9.03..36,082.60 rows=1 width=16) (actual time=1,130.284..1,130.308 rows=7 loops=3)

  • Output: p.filler_id_uuid
  • Worker 0: actual time=1128.639..1128.676 rows=12 loops=1
  • Worker 1: actual time=1129.230..1129.266 rows=7 loops=1
5. 69.338 130.215 ↓ 160,640.7 481,922 3

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

  • Output: oa.account_entity_id
  • Inner Unique: true
  • Hash Cond: (oa.operation_entity_id = p2.filler_id)
  • Worker 0: actual time=0.181..129.580 rows=459232 loops=1
  • Worker 1: actual time=0.176..129.617 rows=461713 loops=1
6. 60.837 60.837 ↑ 2.3 481,922 3

Parallel Seq Scan on izipay.operation_account oa (cost=0.00..33,149.72 rows=1,099,468 width=16) (actual time=0.022..60.837 rows=481,922 loops=3)

  • Output: oa.operation_entity_id, oa.account_entity_id, oa.account_type_id, oa.date_creation
  • Filter: (oa.account_type_id = 1)
  • Rows Removed by Filter: 69
  • Worker 0: actual time=0.017..62.344 rows=459232 loops=1
  • Worker 1: actual time=0.016..61.869 rows=461713 loops=1
7. 0.003 0.040 ↑ 1.0 1 3

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

  • Output: p2.filler_id
  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
  • Worker 0: actual time=0.052..0.052 rows=1 loops=1
  • Worker 1: actual time=0.052..0.052 rows=1 loops=1
8. 0.037 0.037 ↑ 1.0 1 3

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

  • Output: p2.filler_id
  • Index Cond: (p2.id_uuid = 'f5b3c354-c48a-4de0-8613-b0bb68d73cd0'::uuid)
  • Filter: (p2.process_template_id = 82)
  • Worker 0: actual time=0.047..0.048 rows=1 loops=1
  • Worker 1: actual time=0.048..0.048 rows=1 loops=1
9. 0.002 0.002 ↓ 0.0 0 1,445,765

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

  • Output: p.id, p.id_uuid, p.date_creation, p.date_update, p.identification_number, p.workflow_state_id, p.user_main_taker, p.description, p.process_folder_
  • Index Cond: (p.filler_id = oa.account_entity_id)
  • Filter: (p.process_template_id = ANY ('{89,112}'::bigint[]))
  • Rows Removed by Filter: 0
  • Worker 0: actual time=0.002..0.002 rows=0 loops=459232
  • Worker 1: actual time=0.002..0.002 rows=0 loops=461713
10. 0.013 0.013 ↑ 1.0 1 20

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

  • Output: e.id, e.company_id, e.date_creation, e.date_change, e.date_user_change, e.name_prefix, e.name, e.phone_home, e.phone_job, e.phone_celular, e.phone_other
  • Index Cond: (e.id_uuid = p.filler_id_uuid)
  • Worker 0: actual time=0.013..0.013 rows=1 loops=12
  • Worker 1: actual time=0.013..0.013 rows=1 loops=7