explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Wuz

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

Hash Join (cost=98,781.93..2,309,962.44 rows=36 width=349) (actual rows= loops=)

  • Hash Cond: ((file.file_type)::text = (client_file_type.file_type_uuid)::text)
2. 0.000 0.000 ↓ 0.0

Hash Join (cost=98,758.28..2,309,938.15 rows=33 width=349) (actual rows= loops=)

  • Hash Cond: ((file.client_uuid)::text = (c.uuid)::text)
3. 0.000 0.000 ↓ 0.0

Nested Loop (cost=98,756.90..2,309,936.32 rows=33 width=168) (actual rows= loops=)

4. 0.000 0.000 ↓ 0.0

Nested Loop (cost=98,756.21..2,308,435.01 rows=49 width=164) (actual rows= loops=)

5. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on metadata m1 (cost=98,755.65..2,308,014.23 rows=49 width=41) (actual rows= loops=)

  • Recheck Cond: ((key)::text = 'SFDC.Attachment.Id'::text)
  • Filter: (value = '00P3a00001Jaj94EAB'::text)
6. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on metadata_key_idx (cost=0.00..98,755.64 rows=2,058,543 width=0) (actual rows= loops=)

  • Index Cond: ((key)::text = 'SFDC.Attachment.Id'::text)
7. 0.000 0.000 ↓ 0.0

Index Scan using file_uuid_idx on file (cost=0.56..8.58 rows=1 width=123) (actual rows= loops=)

  • Index Cond: ((uuid)::text = (m1.file_uuid)::text)
  • Filter: (is_latest_version AND (m1.file_version = version))
8. 0.000 0.000 ↓ 0.0

Index Scan using metadata_pkey on metadata m (cost=0.69..30.56 rows=8 width=86) (actual rows= loops=)

  • Index Cond: (((file_uuid)::text = (file.uuid)::text) AND (file_version = file.version) AND ((key)
9. 0.000 0.000 ↓ 0.0

Hash (cost=1.17..1.17 rows=17 width=436) (actual rows= loops=)

10. 0.000 0.000 ↓ 0.0

Seq Scan on client c (cost=0.00..1.17 rows=17 width=436) (actual rows= loops=)

11. 0.000 0.000 ↓ 0.0

Hash (cost=20.01..20.01 rows=291 width=37) (actual rows= loops=)

12. 0.000 0.000 ↓ 0.0

Seq Scan on client_file_type (cost=0.00..20.01 rows=291 width=37) (actual rows= loops=)

  • Filter: ((client_uuid)::text = 'd397c352-f238-4f09-8225-3c3f7e9fa216'::text)