explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Ig9D

Settings
# exclusive inclusive rows x rows loops node
1. 0.043 22.830 ↓ 1.1 76 1

Sort (cost=619.92..620.09 rows=68 width=102) (actual time=22.825..22.830 rows=76 loops=1)

  • Sort Key: uf.created
  • Sort Method: quicksort Memory: 94kB
  • Total runtime: 23.313 ms
2. 2.953 22.787 ↓ 1.1 76 1

GroupAggregate (cost=614.87..617.85 rows=68 width=102) (actual time=19.091..22.787 rows=76 loops=1)

3. 5.237 19.834 ↓ 44.2 6,314 1

Sort (cost=614.87..615.23 rows=143 width=102) (actual time=18.936..19.834 rows=6,314 loops=1)

  • Sort Key: uf.id
  • Sort Method: external merge Disk: 736kB
4. 1.964 14.597 ↓ 44.2 6,314 1

Nested Loop Left Join (cost=24.80..609.75 rows=143 width=102) (actual time=0.721..14.597 rows=6,314 loops=1)

5. 0.056 1.233 ↓ 1.1 76 1

Hash Semi Join (cost=24.65..163.81 rows=68 width=106) (actual time=0.676..1.233 rows=76 loops=1)

  • Hash Cond: (uf.storage_id = aoi.object_id_identity)
6. 0.538 0.538 ↓ 1.1 76 1

Seq Scan on uploaded_file uf (cost=0.00..138.22 rows=68 width=114) (actual time=0.022..0.538 rows=76 loops=1)

  • Filter: ((parent_id IS NULL) AND (deleted IS NULL) AND ((content_type)::text !~ '^(?:.*zip.*)$'::text))
  • Rows Removed by Filter: 2042
7. 0.081 0.639 ↓ 1.7 206 1

Hash (cost=23.14..23.14 rows=121 width=8) (actual time=0.639..0.639 rows=206 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
8. 0.148 0.558 ↓ 1.7 206 1

Hash Join (cost=15.43..23.14 rows=121 width=8) (actual time=0.146..0.558 rows=206 loops=1)

  • Hash Cond: (ae.sid = asi.id)
9. 0.202 0.385 ↓ 1.7 206 1

Hash Join (cost=2.28..8.33 rows=121 width=16) (actual time=0.112..0.385 rows=206 loops=1)

  • Hash Cond: (ae.acl_object_identity = aoi.id)
10. 0.090 0.090 ↑ 1.0 206 1

Seq Scan on acl_entry ae (cost=0.00..4.06 rows=206 width=16) (actual time=0.008..0.090 rows=206 loops=1)

11. 0.046 0.093 ↓ 1.7 97 1

Hash (cost=1.57..1.57 rows=57 width=16) (actual time=0.093..0.093 rows=97 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 5kB
12. 0.047 0.047 ↓ 1.7 97 1

Seq Scan on acl_object_identity aoi (cost=0.00..1.57 rows=57 width=16) (actual time=0.007..0.047 rows=97 loops=1)

13. 0.010 0.025 ↑ 5.4 26 1

Hash (cost=11.40..11.40 rows=140 width=8) (actual time=0.025..0.025 rows=26 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 2kB
14. 0.015 0.015 ↑ 5.4 26 1

Seq Scan on acl_sid asi (cost=0.00..11.40 rows=140 width=8) (actual time=0.004..0.015 rows=26 loops=1)

15. 11.400 11.400 ↓ 41.0 82 76

Index Scan using uploaded_file_l_tree_index on uploaded_file tree (cost=0.14..6.54 rows=2 width=36) (actual time=0.101..0.150 rows=82 loops=76)

  • Index Cond: (l_tree <@ uf.l_tree)
  • Filter: (id <> uf.id)
  • Rows Removed by Filter: 1