explain.depesz.com

PostgreSQL's explain analyze made readable

Result: O1CL

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

Unique (cost=1,203.19..1,203.26 rows=1 width=1,508) (actual rows= loops=)

2. 0.000 0.000 ↓ 0.0

Sort (cost=1,203.19..1,203.19 rows=1 width=1,508) (actual rows= loops=)

  • Sort Key: address_program_sideimportfile.created_at DESC, address_program_sideimportfile.""Id"", address_program_sideimportfile.user_id, address_program_sideimportfile.layer_id, address_program_sideimportfile.location_id, address_program_sideimportfile.mapping, address_program_sideimportfile.file, ""User"".""Id"", ""User"".""Email"", ""User"".""IsActive"", ""User"".parent_id, ""User"".""FirstName"", ""User"".""LastName"", ""User"".""MiddleName"", ""User"".""Position"", ""User"".""Birthday"", ""User"".""Phone"", ""User"".""MobilePhone"", ""User"".""MobilePhoneConfirmed"", ""User"".""PostAddress"", ""User"".""EmailConfirmed"", ""User"".""PasswordHash"", ""User"".""PasswordResetToken"", ""User"".""LockoutEnd"", ""User"".""AccessFailedCount"", ""User"".ip_address, ""User"".header_logo, ""User"".frontend_version
3. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=14.67..1,203.18 rows=1 width=1,508) (actual rows= loops=)

  • Join Filter: (address_program_sideimportfile.user_id = ""User"".""Id"")
4. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=14.67..1,186.40 rows=1 width=167) (actual rows= loops=)

  • Filter: ((address_program_sideimportfile.location_id = '47f0394e-b50b-4d2f-8bfd-f0d6730b0de6'::uuid) OR ((t5.meta_data 'campaign_location_id'::text) = '""47f0394e-b50b-4d2f-8bfd-f0d6730b0de6""'::jsonb))
5. 0.000 0.000 ↓ 0.0

Nested Loop (cost=9.47..793.85 rows=1 width=167) (actual rows= loops=)

6. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on address_program_sideimportfile (cost=4.30..11.31 rows=2 width=167) (actual rows= loops=)

  • Recheck Cond: (campaign_id = '8177031a-279e-4d32-8b47-43415eeeef24'::uuid)
7. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on address_program_sideimportfile_campaign_id_8353f5f9 (cost=0.00..4.29 rows=2 width=0) (actual rows= loops=)

  • Index Cond: (campaign_id = '8177031a-279e-4d32-8b47-43415eeeef24'::uuid)
8. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on address_program_sideimportlog (cost=5.18..391.26 rows=1 width=16) (actual rows= loops=)

  • Recheck Cond: (file_id = address_program_sideimportfile.""Id"")
  • Filter: ((meta_data 'buyer_org_id'::text) = '""e612791c-7c60-4620-86b0-b3223e0cb2c3""'::jsonb)
9. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on address_program_sideimportlog_file_id_8633baed (cost=0.00..5.18 rows=101 width=0) (actual rows= loops=)

  • Index Cond: (file_id = address_program_sideimportfile.""Id"")
10. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on address_program_sideimportlog t5 (cost=5.20..390.78 rows=101 width=381) (actual rows= loops=)

  • Recheck Cond: (address_program_sideimportfile.""Id"" = file_id)
11. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on address_program_sideimportlog_file_id_8633baed (cost=0.00..5.18 rows=101 width=0) (actual rows= loops=)

  • Index Cond: (address_program_sideimportfile.""Id"" = file_id)
12. 0.000 0.000 ↓ 0.0

Seq Scan on ""User"" (cost=0.00..13.57 rows=257 width=1,341) (actual rows= loops=)