explain.depesz.com

PostgreSQL's explain analyze made readable

Result: mY4N

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

Gather (cost=306,352.75..353,876.25 rows=200 width=44) (actual rows= loops=)

  • Workers Planned: 1
  • Single Copy: true
2. 0.000 0.000 ↓ 0.0

GroupAggregate (cost=305,352.75..352,856.25 rows=200 width=44) (actual rows= loops=)

  • Group Key: t.date
3. 0.000 0.000 ↓ 0.0

GroupAggregate (cost=305,352.75..333,852.75 rows=950,000 width=32) (actual rows= loops=)

  • Group Key: t.date, t.flu_id, (jsonb_array_length(((fl.build -> 'video_data'::text) -> 'frames'::text)))
4. 0.000 0.000 ↓ 0.0

Sort (cost=305,352.75..307,727.75 rows=950,000 width=56) (actual rows= loops=)

  • Sort Key: t.date DESC, t.flu_id, (jsonb_array_length(((fl.build -> 'video_data'::text) -> 'frames'::text)))
5. 0.000 0.000 ↓ 0.0

Hash Join (cost=89,658.37..192,009.41 rows=950,000 width=56) (actual rows= loops=)

  • Hash Cond: (t.flu_id = fl.id)
6. 0.000 0.000 ↓ 0.0

Subquery Scan on t (cost=580.43..58,275.69 rows=950,000 width=52) (actual rows= loops=)

7. 0.000 0.000 ↓ 0.0

ProjectSet (cost=580.43..48,775.69 rows=950,000 width=84) (actual rows= loops=)

8. 0.000 0.000 ↓ 0.0

ProjectSet (cost=580.43..43,740.69 rows=9,500 width=56) (actual rows= loops=)

9. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on feed_line_log fll (cost=580.43..43,691.29 rows=95 width=164) (actual rows= loops=)

  • Recheck Cond: (step_id = ANY ('{de2fd2b8-1e13-4c0b-91b4-8bdbc6ed0b23,71cb7f5f-c904-49bd-b950-7f6e32e99251}'::uuid[]))
  • Filter: ((event = 2) AND (((meta_data -> 'build'::text) -> 'checker_exit_status'::text) = 'true'::jsonb))
10. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on feed_line_log_step_id_index (cost=0.00..580.40 rows=45,592 width=0) (actual rows= loops=)

  • Index Cond: (step_id = ANY ('{de2fd2b8-1e13-4c0b-91b4-8bdbc6ed0b23,71cb7f5f-c904-49bd-b950-7f6e32e99251}'::uuid[]))
11. 0.000 0.000 ↓ 0.0

Hash (cost=66,392.53..66,392.53 rows=496,353 width=246) (actual rows= loops=)

12. 0.000 0.000 ↓ 0.0

Seq Scan on feed_line fl (cost=0.00..66,392.53 rows=496,353 width=246) (actual rows= loops=)