explain.depesz.com

PostgreSQL's explain analyze made readable

Result: y7pF

Settings
# exclusive inclusive rows x rows loops node
1. 3.450 9.561 ↓ 1.0 7,204 1

Merge Left Join (cost=10,000,000,031.07..10,000,001,389.05 rows=6,890 width=1,706) (actual time=0.330..9.561 rows=7,204 loops=1)

  • Output: registrar.uuid, registrar.creation_date, registrar.creator_id, registrar.invalidation_date, registrar.invalidator_id, registrar.modification_date, registrar.modificator_id, registrar.localization_accepted, registrar.mail, registrar.password, registrar.preferred_language, registrar.private_profile, registrar.public_api_user, registrar.rad_sharing_policy, registrar.type, registrar.validation_date, registrar.note, registrar.notification_key, registrar.lat_location, registrar.lng_location, registrar.validation_reminder_sent_date, registrar.cot_link_auto_accept, pre_registrar.email, pre_registrar.email_sent, pre_registrar.first_name, pre_registrar.gender, pre_registrar.language_code, pre_registrar.last_name, pre_registrar.phone_number, pre_registrar.token, pre_registrar.type, pre_registrar.used_token, pre_registrar.recruiter, pre_registrar.source, pre_registrar.creation_date, pre_registrar.five_days_reminder_sent, pre_registrar.ten_days_reminder_sent
  • Merge Cond: (registrar.uuid = pre_registrar.recruiter)
  • Buffers: shared hit=6,935 read=1 dirtied=8
  • I/O Timings: read=0.012
2. 5.766 5.766 ↑ 1.0 6,871 1

Index Scan using registrar_pkey on public.registrar (cost=0.28..1,335.53 rows=6,890 width=475) (actual time=0.009..5.766 rows=6,871 loops=1)

  • Output: registrar.uuid, registrar.creation_date, registrar.creator_id, registrar.invalidation_date, registrar.invalidator_id, registrar.modification_date, registrar.modificator_id, registrar.localization_accepted, registrar.mail, registrar.password, registrar.preferred_language, registrar.private_profile, registrar.public_api_user, registrar.rad_sharing_policy, registrar.type, registrar.validation_date, registrar.note, registrar.notification_key, registrar.lat_location, registrar.lng_location, registrar.validation_reminder_sent_date, registrar.cot_link_auto_accept
  • Buffers: shared hit=6,920 read=1 dirtied=8
  • I/O Timings: read=0.012
3. 0.297 0.345 ↑ 1.1 355 1

Sort (cost=10,000,000,030.78..10,000,000,031.72 rows=375 width=1,231) (actual time=0.316..0.345 rows=355 loops=1)

  • Output: pre_registrar.email, pre_registrar.email_sent, pre_registrar.first_name, pre_registrar.gender, pre_registrar.language_code, pre_registrar.last_name, pre_registrar.phone_number, pre_registrar.token, pre_registrar.type, pre_registrar.used_token, pre_registrar.recruiter, pre_registrar.source, pre_registrar.creation_date, pre_registrar.five_days_reminder_sent, pre_registrar.ten_days_reminder_sent
  • Sort Key: pre_registrar.recruiter
  • Sort Method: quicksort Memory: 122kB
  • Buffers: shared hit=15
4. 0.048 0.048 ↑ 1.0 368 1

Seq Scan on public.pre_registrar (cost=10,000,000,000.00..10,000,000,014.75 rows=375 width=1,231) (actual time=0.005..0.048 rows=368 loops=1)

  • Output: pre_registrar.email, pre_registrar.email_sent, pre_registrar.first_name, pre_registrar.gender, pre_registrar.language_code, pre_registrar.last_name, pre_registrar.phone_number, pre_registrar.token, pre_registrar.type, pre_registrar.used_token, pre_registrar.recruiter, pre_registrar.source, pre_registrar.creation_date, pre_registrar.five_days_reminder_sent, pre_registrar.ten_days_reminder_sent
  • Buffers: shared hit=11
Planning time : 0.552 ms
Execution time : 9.990 ms