explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 7Fn6

Settings
# exclusive inclusive rows x rows loops node
1. 0.385 1,035.548 ↑ 1.0 1 1

Aggregate (cost=11,746.52..11,746.53 rows=1 width=8) (actual time=1,035.547..1,035.548 rows=1 loops=1)

2. 1.435 1,035.163 ↓ 2,247.0 2,247 1

Nested Loop Anti Join (cost=1,093.92..11,746.52 rows=1 width=8) (actual time=11.991..1,035.163 rows=2,247 loops=1)

3. 0.000 1,015.752 ↓ 2,247.0 2,247 1

Gather (cost=1,093.50..11,740.66 rows=1 width=73) (actual time=11.971..1,015.752 rows=2,247 loops=1)

  • Workers Planned: 1
  • Workers Launched: 1
4. 24.349 1,020.550 ↓ 1,124.0 1,124 2 / 2

Nested Loop (cost=93.50..10,740.56 rows=1 width=73) (actual time=8.489..1,020.550 rows=1,124 loops=2)

  • Join Filter: ((events_asa.item_uuid)::text = (asa_user_assignment_languages.item_uuid)::text)
  • Rows Removed by Join Filter: 36971
5. 42.343 424.783 ↓ 147.1 38,094 2 / 2

Nested Loop (cost=92.94..8,517.62 rows=259 width=143) (actual time=8.449..424.783 rows=38,094 loops=2)

6. 34.151 39.590 ↓ 78.5 38,094 2 / 2

Parallel Bitmap Heap Scan on asa_user_assignments (cost=92.51..4,574.83 rows=485 width=98) (actual time=8.419..39.590 rows=38,094 loops=2)

  • Recheck Cond: (((student_uuid)::text = 'ffffffff59dd3c9b1c6dd5511b370553'::text) AND ((external_class_uuid)::text = '5ABEDC0ED4C85F68E0532402140ABE7A'::text))
  • Filter: ((mark_completed = '0'::numeric) AND (is_deleted = '1'::numeric))
  • Rows Removed by Filter: 2519
  • Heap Blocks: exact=2094
7. 5.439 5.439 ↓ 69.9 81,227 1 / 2

Bitmap Index Scan on asa_user_assg_stud_new_idx (cost=0.00..92.31 rows=1,162 width=0) (actual time=10.878..10.878 rows=81,227 loops=1)

  • Index Cond: (((student_uuid)::text = 'ffffffff59dd3c9b1c6dd5511b370553'::text) AND ((external_class_uuid)::text = '5ABEDC0ED4C85F68E0532402140ABE7A'::text))
8. 342.850 342.850 ↑ 1.0 1 76,189 / 2

Index Scan using sys_c0086134 on events_asa (cost=0.42..8.13 rows=1 width=78) (actual time=0.009..0.009 rows=1 loops=76,189)

  • Index Cond: ((id)::text = (asa_user_assignments.assignment_id)::text)
  • Filter: (utc_start_date <= '2019-06-19 00:00:00'::timestamp without time zone)
9. 571.418 571.418 ↑ 1.0 1 76,189 / 2

Index Only Scan using asa_u_asg_lang_unique1 on asa_user_assignment_languages (cost=0.56..8.57 rows=1 width=70) (actual time=0.014..0.015 rows=1 loops=76,189)

  • Index Cond: (user_assignment_id = (asa_user_assignments.user_assignment_id)::text)
  • Heap Fetches: 76189
10. 17.976 17.976 ↓ 0.0 0 2,247

Index Scan using asa_hiden_assigmts_cla_id_idx on asa_hidden_assignments (cost=0.42..5.84 rows=1 width=65) (actual time=0.008..0.008 rows=0 loops=2,247)

  • Index Cond: ((assignment_id)::text = (asa_user_assignments.assignment_id)::text)
  • Filter: (((external_class_uuid)::text = '5ABEDC0ED4C85F68E0532402140ABE7A'::text) AND ((external_class_uuid)::text = (asa_user_assignments.external_class_uuid)::text))