explain.depesz.com

PostgreSQL's explain analyze made readable

Result: FbSv

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

Limit (cost=2.13..2.20 rows=2 width=32) (actual rows= loops=)

2. 0.000 0.000 ↓ 0.0

GroupAggregate (cost=2.13..2.20 rows=2 width=32) (actual rows= loops=)

  • Group Key: master_menu_category_moderation_tickets.brand_id
3. 0.000 0.000 ↓ 0.0

Unique (cost=2.13..2.15 rows=2 width=40) (actual rows= loops=)

4. 0.000 0.000 ↓ 0.0

Sort (cost=2.13..2.13 rows=2 width=40) (actual rows= loops=)

  • Sort Key: master_menu_category_moderation_tickets.brand_id, master_menu_category_moderation_tickets.id, master_menu_category_moderation_tickets.created_at
5. 0.000 0.000 ↓ 0.0

Append (cost=0.00..2.12 rows=2 width=40) (actual rows= loops=)

6. 0.000 0.000 ↓ 0.0

Seq Scan on master_menu_category_moderation_tickets (cost=0.00..1.05 rows=1 width=40) (actual rows= loops=)

  • Filter: (resolved_at IS NULL)
7. 0.000 0.000 ↓ 0.0

Seq Scan on master_menu_item_moderation_tickets (cost=0.00..1.05 rows=1 width=40) (actual rows= loops=)

  • Filter: (resolved_at IS NULL)