explain.depesz.com

PostgreSQL's explain analyze made readable

Result: LzLf

Settings
# exclusive inclusive rows x rows loops node
1. 0.044 1.017 ↑ 1.4 17 1

GroupAggregate (cost=148.50..148.69 rows=24 width=68) (actual time=0.981..1.017 rows=17 loops=1)

  • Group Key: child_daf.id
2. 0.014 0.973 ↓ 1.2 30 1

Merge Left Join (cost=148.50..148.53 rows=24 width=8) (actual time=0.958..0.973 rows=30 loops=1)

  • Merge Cond: (child_daf.id = child_folder_associations.parent_id)
3. 0.012 0.038 ↑ 1.4 17 1

Sort (cost=3.40..3.42 rows=24 width=4) (actual time=0.037..0.038 rows=17 loops=1)

  • Sort Key: child_daf.id
  • Sort Method: quicksort Memory: 25kB
4. 0.026 0.026 ↑ 1.4 17 1

Seq Scan on digital_asset_folders child_daf (cost=0.00..3.29 rows=24 width=4) (actual time=0.009..0.026 rows=17 loops=1)

  • Filter: ((is_root IS TRUE) AND (id IS NOT NULL) AND (archived_at IS NULL) AND (calendar_id = 16))
  • Rows Removed by Filter: 87
5. 0.016 0.921 ↓ 54.0 54 1

Sort (cost=145.09..145.10 rows=1 width=8) (actual time=0.918..0.921 rows=54 loops=1)

  • Sort Key: child_folder_associations.parent_id
  • Sort Method: quicksort Memory: 27kB
6. 0.905 0.905 ↓ 54.0 54 1

Seq Scan on digital_asset_associations child_folder_associations (cost=0.00..145.09 rows=1 width=8) (actual time=0.092..0.905 rows=54 loops=1)

  • Filter: (('digital_asset_folder'::text = parent_type) AND (child_type = 'digital_asset_folder'::text))
  • Rows Removed by Filter: 8234