explain.depesz.com

PostgreSQL's explain analyze made readable

Result: bUuD

Settings
# exclusive inclusive rows x rows loops node
1. 1.082 23.747 ↑ 1.0 783 1

Sort (cost=13,578.47..13,580.42 rows=783 width=423) (actual time=23.386..23.747 rows=783 loops=1)

  • Sort Key: po."sequenceNumberInBatch
  • Sort Method: quicksort Memory: 419kB
2. 3.671 22.665 ↑ 1.0 783 1

Hash Join (cost=462.79..13,540.83 rows=783 width=423) (actual time=10.380..22.665 rows=783 loops=1)

  • Hash Cond: (app.id = po."applicationId")
3. 1.651 1.651 ↑ 1.0 3,649 1

Index Only Scan using "IX_Application$Id" on "Application" app (cost=0.28..151.02 rows=3,649 width=16) (actual time=0.014..1.651 rows=3,649 loops=1)

  • Heap Fetches: 0
4. 0.580 10.296 ↑ 1.0 783 1

Hash (cost=452.72..452.72 rows=783 width=411) (actual time=10.295..10.296 rows=783 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 250kB
5. 2.063 9.716 ↑ 1.0 783 1

Hash Join (cost=286.71..452.72 rows=783 width=411) (actual time=8.446..9.716 rows=783 loops=1)

  • Hash Cond: (pid.id = ins."insuredPersonId")
6. 2.019 2.019 ↑ 1.0 3,649 1

Seq Scan on "InsuredPerson" pid (cost=0.00..144.49 rows=3,649 width=140) (actual time=0.009..2.019 rows=3,649 loops=1)

7. 0.512 5.634 ↑ 1.0 783 1

Hash (cost=276.93..276.93 rows=783 width=303) (actual time=5.634..5.634 rows=783 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 162kB
8. 2.012 5.122 ↑ 1.0 783 1

Hash Join (cost=143.92..276.93 rows=783 width=303) (actual time=3.911..5.122 rows=783 loops=1)

  • Hash Cond: (ins.id = po."insuranceId")
9. 1.970 1.970 ↑ 1.0 3,649 1

Seq Scan on "Insurance" ins (cost=0.00..111.49 rows=3,649 width=184) (actual time=0.006..1.970 rows=3,649 loops=1)

10. 0.390 1.140 ↑ 1.0 783 1

Hash (cost=134.14..134.14 rows=783 width=151) (actual time=1.140..1.140 rows=783 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 119kB
11. 0.673 0.750 ↑ 1.0 783 1

Bitmap Heap Scan on "PolicyOrder" po (cost=34.35..134.14 rows=783 width=151) (actual time=0.088..0.750 rows=783 loops=1)

  • Recheck Cond: ("orderBatchId" = '59dcd042-5dae-4ac5-a48c-fa1605d2dbb9'::uuid)
  • Heap Blocks: exact=45
12. 0.077 0.077 ↑ 1.0 783 1

Bitmap Index Scan on "FK_PolicyOrder$OrderBatch" (cost=0.00..34.15 rows=783 width=0) (actual time=0.076..0.077 rows=783 loops=1)

  • Index Cond: ("orderBatchId" = '59dcd042-5dae-4ac5-a48c-fa1605d2dbb9'::uuid)
13.          

SubPlan (for Hash Join)

14. 1.566 5.481 ↑ 1.0 1 783

Limit (cost=8.31..8.32 rows=1 width=4) (actual time=0.005..0.007 rows=1 loops=783)

15. 1.566 3.915 ↑ 1.0 1 783

Sort (cost=8.31..8.32 rows=1 width=4) (actual time=0.004..0.005 rows=1 loops=783)

  • Sort Key: ops."stateCode" DESC
  • Sort Method: quicksort Memory: 25kB
16. 2.349 2.349 ↑ 1.0 1 783

Index Scan using "FK_OrderState$PolicyOrder" on "Order_ProcessingState" ops (cost=0.28..8.30 rows=1 width=4) (actual time=0.002..0.003 rows=1 loops=783)

  • Index Cond: ("orderId" = po.id)
17. 0.783 1.566 ↑ 1.0 1 783

Aggregate (cost=8.16..8.17 rows=1 width=8) (actual time=0.002..0.002 rows=1 loops=783)

18. 0.783 0.783 ↓ 0.0 0 783

Index Scan using "FK_Document$Application" on "Document" doc (cost=0.14..8.15 rows=1 width=16) (actual time=0.001..0.001 rows=0 loops=783)

  • Index Cond: ("applicationId" = app.id)
Planning time : 1.554 ms
Execution time : 24.120 ms