explain.depesz.com

PostgreSQL's explain analyze made readable

Result: uxxS

Settings
# exclusive inclusive rows x rows loops node
1. 3.968 8.575 ↓ 1.0 7,204 1

Hash Right Join (cost=393.02..408.76 rows=6,890 width=1,706) (actual time=4.584..8.575 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
  • Inner Unique: true
  • Hash Cond: (pre_registrar.recruiter = registrar.uuid)
  • Buffers: shared hit=249
2. 0.049 0.049 ↑ 1.0 368 1

Seq Scan on public.pre_registrar (cost=0.00..14.75 rows=375 width=1,231) (actual time=0.008..0.049 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
3. 2.313 4.558 ↑ 1.0 6,871 1

Hash (cost=306.90..306.90 rows=6,890 width=475) (actual time=4.558..4.558 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
  • Buckets: 8192 Batches: 1 Memory Usage: 1792kB
  • Buffers: shared hit=238
4. 2.245 2.245 ↑ 1.0 6,871 1

Seq Scan on public.registrar (cost=0.00..306.90 rows=6,890 width=475) (actual time=0.010..2.245 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=238
Planning time : 0.153 ms
Execution time : 8.940 ms