explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 4c7

Settings
# exclusive inclusive rows x rows loops node
1. 0.596 1.624 ↓ 976.0 976 1

Nested Loop (cost=0.11..140.00 rows=1 width=1,568) (actual time=0.078..1.624 rows=976 loops=1)

2. 0.047 0.047 ↑ 1.0 1 1

Index Scan using uniplex_user_username0_idx on "user" u (cost=0.06..4.06 rows=1 width=991) (actual time=0.047..0.047 rows=1 loops=1)

  • Index Cond: ((username)::text = 'PicoFactory'::text)
  • Filter: "isOrganization
3. 0.981 0.981 ↑ 1.2 976 1

Index Scan using "projectOrder_assemblyManufacturerId_idx" on "projectOrder" o (cost=0.06..132.50 rows=1,147 width=577) (actual time=0.027..0.981 rows=976 loops=1)

  • Index Cond: (("assemblyManufacturerId")::bigint = (u.id)::bigint)
  • Filter: ("deletedAt" IS NULL)
Planning time : 2.309 ms
Execution time : 1.798 ms