explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Y6Bd

Settings
# exclusive inclusive rows x rows loops node
1. 0.003 550.814 ↓ 0.0 0 1

Limit (cost=132,638.82..132,638.83 rows=3 width=76) (actual time=550.813..550.814 rows=0 loops=1)

2. 0.005 550.811 ↓ 0.0 0 1

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

  • Sort Key: (2) DESC, "Notifications".id DESC
  • Sort Method: quicksort Memory: 25kB
3. 0.002 550.806 ↓ 0.0 0 1

HashAggregate (cost=132,638.77..132,638.80 rows=3 width=76) (actual time=550.805..550.806 rows=0 loops=1)

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

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

5. 0.072 0.072 ↓ 0.0 0 1

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

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

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

  • Workers Planned: 4
  • Workers Launched: 4
7. 545.995 545.995 ↓ 0.0 0 5 / 5

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

  • Filter: (((data ->> 'status'::text) IS NULL) AND (developer_id = 10,728) AND (type = 1))
  • Rows Removed by Filter: 73,246
8. 0.004 0.004 ↓ 0.0 0 1

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

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