explain.depesz.com

PostgreSQL's explain analyze made readable

Result: NjpZ

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

Limit (cost=132,638.82..132,638.83 rows=3 width=76) (actual rows= loops=)

2. 0.000 0.000 ↓ 0.0

Sort (cost=132,638.82..132,638.83 rows=3 width=76) (actual rows= loops=)

  • Sort Key: (2) DESC, "Notifications".id DESC
3. 0.000 0.000 ↓ 0.0

HashAggregate (cost=132,638.77..132,638.80 rows=3 width=76) (actual rows= loops=)

  • Group Key: "Notifications".id, "Notifications".data, (2), "Notifications".status, (to_char("Notifications".updated_at, 'DD.MM.YYYY'::text))
4. 0.000 0.000 ↓ 0.0

Append (cost=0.00..132,638.73 rows=3 width=76) (actual rows= loops=)

5. 0.000 0.000 ↓ 0.0

Seq Scan on "Notifications" (cost=0.00..9.78 rows=1 width=1,189) (actual rows= loops=)

  • Filter: ((deleted_at IS NULL) AND (status = ANY ('{0,1}'::integer[])) AND (developer_id = 10,728))
6. 0.000 0.000 ↓ 0.0

Gather (cost=1,000.00..132,607.90 rows=1 width=629) (actual rows= loops=)

  • Workers Planned: 4
7. 0.000 0.000 ↓ 0.0

Parallel Seq Scan on "NotifyMessages" (cost=0.00..131,607.80 rows=1 width=629) (actual rows= loops=)

  • Filter: (((data ->> 'status'::text) IS NULL) AND (developer_id = 10,728) AND (type = 1))
8. 0.000 0.000 ↓ 0.0

Seq Scan on "NotifyExprt" (cost=0.00..21.00 rows=1 width=76) (actual rows= loops=)

  • Filter: ((deleted_at IS NULL) AND (developer_id = 10,728))