explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Uvo

Settings
# exclusive inclusive rows x rows loops node
1. 0.319 0.424 ↑ 1.0 305 1

Hash Left Join (cost=1.02..15.23 rows=305 width=5,865) (actual time=0.036..0.424 rows=305 loops=1)

  • Output: registrar.uuid, registrar.creation_date, registrar.creator_id, registrar.invalidation_date, registrar.invalidator_id, registrar.modification_date, registrar.modificator_id, registrar.cot_link_auto_accept, registrar.lat_location, registrar.lng_location, registrar.localization_accepted, registrar.mail, registrar.note, registrar.notification_key, registrar.password, registrar.preferred_language, registrar.private_profile, registrar.public_api_user, registrar.rad_sharing_policy, registrar.type, registrar.validation_date, registrar.validation_reminder_sent_date, 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.source, pre_registrar.token, pre_registrar.type, pre_registrar.used_token, pre_registrar.recruiter, pre_registrar.creation_date, pre_registrar.five_days_reminder_sent, pre_registrar.ten_days_reminder_sent
  • Hash Cond: (registrar.uuid = pre_registrar.recruiter)
  • Buffers: shared hit=11
2. 0.097 0.097 ↑ 1.0 305 1

Seq Scan on public.registrar (cost=0.00..13.05 rows=305 width=1,040) (actual time=0.010..0.097 rows=305 loops=1)

  • Output: registrar.uuid, registrar.creation_date, registrar.creator_id, registrar.invalidation_date, registrar.invalidator_id, registrar.modification_date, registrar.modificator_id, registrar.cot_link_auto_accept, registrar.lat_location, registrar.lng_location, registrar.localization_accepted, registrar.mail, registrar.note, registrar.notification_key, registrar.password, registrar.preferred_language, registrar.private_profile, registrar.public_api_user, registrar.rad_sharing_policy, registrar.type, registrar.validation_date, registrar.validation_reminder_sent_date
  • Buffers: shared hit=10
3. 0.004 0.008 ↑ 1.0 1 1

Hash (cost=1.01..1.01 rows=1 width=4,825) (actual time=0.008..0.008 rows=1 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.source, pre_registrar.token, pre_registrar.type, pre_registrar.used_token, pre_registrar.recruiter, pre_registrar.creation_date, pre_registrar.five_days_reminder_sent, pre_registrar.ten_days_reminder_sent
  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
  • Buffers: shared hit=1
4. 0.004 0.004 ↑ 1.0 1 1

Seq Scan on public.pre_registrar (cost=0.00..1.01 rows=1 width=4,825) (actual time=0.004..0.004 rows=1 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.source, pre_registrar.token, pre_registrar.type, pre_registrar.used_token, pre_registrar.recruiter, pre_registrar.creation_date, pre_registrar.five_days_reminder_sent, pre_registrar.ten_days_reminder_sent
  • Buffers: shared hit=1