explain.depesz.com

PostgreSQL's explain analyze made readable

Result: pDGm

Settings
# exclusive inclusive rows x rows loops node
1. 5.191 42.556 ↓ 1.4 1,550 1

Hash Join (cost=110.64..9,442.91 rows=1,097 width=1,105) (actual time=0.411..42.556 rows=1,550 loops=1)

  • Hash Cond: (issue.""teamId"" = team.id)
2. 37.103 37.103 ↑ 1.0 61,610 1

Seq Scan on issue (cost=0.00..9,089.62 rows=61,781 width=1,105) (actual time=0.007..37.103 rows=61,610 loops=1)

  • Filter: (""archivedAt"" IS NULL)
  • Rows Removed by Filter: 19552
3. 0.007 0.262 ↑ 1.0 33 1

Hash (cost=110.22..110.22 rows=33 width=16) (actual time=0.262..0.262 rows=33 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 10kB
4. 0.255 0.255 ↑ 1.0 33 1

Seq Scan on team (cost=0.00..110.22 rows=33 width=16) (actual time=0.015..0.255 rows=33 loops=1)

  • Filter: (""organizationId"" = '6ee3ee0f-1ea6-4b88-a969-f63432eeb657'::uuid)
  • Rows Removed by Filter: 1825