explain.depesz.com

PostgreSQL's explain analyze made readable

Result: SlsK

Settings
# exclusive inclusive rows x rows loops node
1. 0.052 0.473 ↓ 5.0 5 1

Nested Loop Left Join (cost=37.46..46.28 rows=1 width=4631) (actual time=0.405..0.445 rows=5 loops=1)Sort (cost=46.29..46.29 rows=1 width=4,631) (actual time=0.473..0.473 rows=5 loops=1)

  • Sort Key: project.""createdAt"" DESC
  • Sort Method: quicksort Memory: 27kB
  • Join Filter: (project.id = tasks.""projectId"")
  • Rows Removed by Join Filter: 80
2. 0.029 0.396 ↓ 5.0 5 1

Hash Right Join (cost=37.46..44.96 rows=1 width=4,615) (actual time=0.391..0.396 rows=5 loops=1)

  • Hash Cond: (customer.id = project.""customerId"")
3. 0.039 0.039 ↓ 1.1 119 1

Seq Scan on customer (cost=0.00..7.09 rows=109 width=31) (actual time=0.010..0.039 rows=119 loops=1)

  • Filter: (""deletedAt"" IS NULL)
  • Rows Removed by Filter: 1
4. 0.007 0.328 ↓ 5.0 5 1

Hash (cost=37.44..37.44 rows=1 width=4,584) (actual time=0.328..0.328 rows=5 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 10kB
5. 0.001 0.321 ↓ 5.0 5 1

Limit (cost=37.43..37.43 rows=1 width=4,584) (actual time=0.320..0.321 rows=5 loops=1)

6. 0.022 0.320 ↓ 5.0 5 1

Sort (cost=37.43..37.43 rows=1 width=4,584) (actual time=0.319..0.320 rows=5 loops=1)

  • Sort Key: project.""createdAt"" DESC
  • Sort Method: quicksort Memory: 27kB
7. 0.298 0.298 ↓ 5.0 5 1

Seq Scan on project (cost=0.00..37.42 rows=1 width=4,584) (actual time=0.236..0.298 rows=5 loops=1)

  • Filter: ((""deletedAt"" IS NULL) AND ((status IS NULL) OR ((status)::text <> 'מבוטל'::text)) AND (""ownerId"" = 'df92f720-6e93-11ea-87c6-dd4477bc3b28'::uuid) AND ((jsonb_path_query_array(""relatedAgents"", '$.*'::jsonpath, '{}'::jsonb, false) @> '[""e11be360-8313-11ea-992b-9b9b91514a6f""]'::jsonb) OR ((agent)::text = 'e11be360-8313-11ea-992b-9b9b91514a6f'::text)))
  • Rows Removed by Filter: 478
8. 0.025 0.025 ↓ 1.1 16 5

Seq Scan on task tasks (cost=0.00..1.14 rows=14 width=32) (actual time=0.003..0.005 rows=16 loops=5)

  • Filter: (done IS NOT TRUE)
  • Rows Removed by Filter: 1
Planning time : 0.749 ms
Execution time : 0.566 ms