explain.depesz.com

PostgreSQL's explain analyze made readable

Result: F0u1

Settings
# exclusive inclusive rows x rows loops node
1. 0.136 2.477 ↓ 228.0 228 1

Nested Loop Left Join (cost=1.70..45.55 rows=1 width=1,298) (actual time=0.056..2.477 rows=228 loops=1)

2. 0.121 0.517 ↓ 228.0 228 1

Nested Loop Left Join (cost=1.14..41.45 rows=1 width=1,104) (actual time=0.043..0.517 rows=228 loops=1)

3. 0.088 0.088 ↓ 22.0 22 1

Index Scan using message__account_id__conversation_id on message (cost=0.57..16.74 rows=1 width=1,064) (actual time=0.030..0.088 rows=22 loops=1)

  • Index Cond: ((account_id = '42434'::text) AND (conversation_id = '5b7cce2f-8d6b-4afd-8c1e-7ea029319c9d'::uuid))
  • Filter: (gid = ANY ('{0d0641ba-866a-de57-be62-7543bb6eef0b,5bd576dd-e53c-4e36-b14e-0e4b8e2f0417,87b2ce61-cdb9-ba01-cb84-69bfcb264461,2bce7581-4b89-4519-bfaf-232ee5dcde64,abeb131b-ede4-c6ae-ba82-e3c4ee5a9c3d,e6ab504a-795c-4a04-b52d-6e9b5675d002,ee1ede2a-970e-7e41-0472-562ec6ca7f6e,2f9688a9-d31f-4dd8-963c-c9f2497a7f67,7e6c3d65-4a5d-43a0-99e7-dba59b9a4a12,84b7ed0e-b0c3-c2bc-a206-e2a1aaa9cfab,cdd37ee5-6e41-49ba-8f51-937e236de6ea,cbaab09a-1145-b6a8-d87c-1fd15380edb4,8ffacce5-ecc1-4816-8176-aed3835648bc,c459b25d-f766-a809-0e3f-a838c5fac683,a5f61c6b-1c6f-4da6-a1f6-d5bbea581ff7,237e0ba6-dc27-93f2-c3a0-bb76fbe92121,17559276-b037-48fe-ba72-1eb182a9eccf,4b45a401-6b4d-4879-be22-41b07f9733e7,50ae7894-c7a2-d823-9451-f1d1a8c0dd48,4c3da6e8-1d4a-4296-a461-e322d0bbbb78,3f797973-10bd-df0e-661c-42675455512a,2ab0b7e0-1b3f-8d8c-ccf8-4e273708fabb,c4b7ba04-0011-4fc2-9b67-52c22ae9be03,01939faf-a63d-44c5-b301-87e6bccc696a,09968a2a-dce7-4660-8a4b-0255ab4a529e,e0036484-48a4-4078-9f6f-80120b443894,b6f48077-1ddd-4cc3-b7aa-8e6809465f65,adaeae9e-2250-4473-ad20-e489c458156d,76ff8dd0-3a14-443a-8887-0df68ef28c3c,024318f0-f6b7-4088-8b0b-c4dad9a9d94e,9dffb177-0058-406d-9b34-2cd5c451d17a,6472e5f7-3488-4b04-92fa-34daa5ea3c05,e2041af8-3d7e-47a1-aed9-d16eddf80a3a}'::uuid[]))
4. 0.308 0.308 ↓ 2.0 10 22

Index Scan using event_message_message_gid on event_message x30 (cost=0.57..24.65 rows=5 width=40) (actual time=0.009..0.014 rows=10 loops=22)

  • Index Cond: (message_gid = message.gid)
5. 1.824 1.824 ↑ 1.0 1 228

Index Scan using message_event_pkey on message_event x31 (cost=0.57..4.09 rows=1 width=194) (actual time=0.008..0.008 rows=1 loops=228)

  • Index Cond: (gid = x30.event_gid)
Planning time : 0.910 ms
Execution time : 2.583 ms