explain.depesz.com

PostgreSQL's explain analyze made readable

Result: IsrX

Settings
# exclusive inclusive rows x rows loops node
1. 0.008 566.455 ↑ 1.0 1 1

Aggregate (cost=132,638.80..132,638.81 rows=1 width=8) (actual time=566.455..566.455 rows=1 loops=1)

2. 0.001 566.447 ↓ 0.0 0 1

Limit (cost=132,638.73..132,638.76 rows=3 width=4) (actual time=566.447..566.447 rows=0 loops=1)

3. 0.003 566.446 ↓ 0.0 0 1

HashAggregate (cost=132,638.73..132,638.76 rows=3 width=4) (actual time=566.445..566.446 rows=0 loops=1)

  • Group Key: "Notifications".id
4. 0.000 566.443 ↓ 0.0 0 1

Append (cost=0.00..132,638.72 rows=3 width=4) (actual time=566.443..566.443 rows=0 loops=1)

5. 0.088 0.088 ↓ 0.0 0 1

Seq Scan on "Notifications" (cost=0.00..9.78 rows=1 width=4) (actual time=0.088..0.088 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. 19.697 581.684 ↓ 0.0 0 1

Gather (cost=1,000.00..132,607.90 rows=1 width=4) (actual time=566.342..581.684 rows=0 loops=1)

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

Parallel Seq Scan on "NotifyMessages" (cost=0.00..131,607.80 rows=1 width=4) (actual time=561.987..561.987 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.009 0.009 ↓ 0.0 0 1

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

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