explain.depesz.com

PostgreSQL's explain analyze made readable

Result: rnuF3

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 0.000 ↓ 0.0

Nested Loop (cost=1,001.17..145,193.53 rows=85,759 width=244) (actual rows= loops=)

2. 0.000 0.000 ↓ 0.0

Seq Scan on source src (cost=0.00..1.09 rows=1 width=25) (actual rows= loops=)

  • Filter: (id = '0aff17b3-fba5-4fca-94bd-805a16afd613'::uuid)
3. 0.000 0.000 ↓ 0.0

Merge Join (cost=1,001.17..144,334.86 rows=85,759 width=235) (actual rows= loops=)

  • Merge Cond: (ff.enrolled_face_id = ef.id)
4. 0.000 0.000 ↓ 0.0

Gather Merge (cost=1,000.89..4,664,982.45 rows=2,346,113 width=129) (actual rows= loops=)

  • Workers Planned: 2
5. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.87..4,393,182.77 rows=977,547 width=129) (actual rows= loops=)

6. 0.000 0.000 ↓ 0.0

Parallel Index Scan using found_face_enrolled_face_id_certainty_idx on found_face ff (cost=0.43..1,320,784.49 rows=5,523,905 width=88) (actual rows= loops=)

7. 0.000 0.000 ↓ 0.0

Index Scan using source_image_pkey on source_image si (cost=0.43..0.56 rows=1 width=57) (actual rows= loops=)

  • Index Cond: (id = ff.source_image_id)
  • Filter: (source_id = '0aff17b3-fba5-4fca-94bd-805a16afd613'::uuid)
8. 0.000 0.000 ↓ 0.0

Materialize (cost=0.27..86.84 rows=14 width=122) (actual rows= loops=)

9. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.27..86.80 rows=14 width=122) (actual rows= loops=)

10. 0.000 0.000 ↓ 0.0

Index Scan using enrolled_face_pkey on enrolled_face ef (cost=0.27..82.97 rows=14 width=108) (actual rows= loops=)

  • Filter: (person_id = '09f34426-2e19-4d78-ace4-9c83d054a056'::uuid)
11. 0.000 0.000 ↓ 0.0

Materialize (cost=0.00..3.66 rows=1 width=30) (actual rows= loops=)

12. 0.000 0.000 ↓ 0.0

Seq Scan on person p (cost=0.00..3.65 rows=1 width=30) (actual rows= loops=)

  • Filter: (id = '09f34426-2e19-4d78-ace4-9c83d054a056'::uuid)