explain.depesz.com

PostgreSQL's explain analyze made readable

Result: NijV : TEST

Settings
# exclusive inclusive rows x rows loops node
1. 0.065 119.605 ↑ 1.0 100 1

Limit (cost=20,032.96..20,044.62 rows=100 width=281) (actual time=117.189..119.605 rows=100 loops=1)

2. 11.306 119.540 ↑ 40.5 100 1

Gather Merge (cost=20,032.96..20,505.02 rows=4,046 width=281) (actual time=117.187..119.540 rows=100 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
3. 41.515 108.234 ↑ 8.9 228 3 / 3

Sort (cost=19,032.93..19,037.99 rows=2,023 width=281) (actual time=108.146..108.234 rows=228 loops=3)

  • Sort Key: assetentit0_.scan_code
  • Sort Method: quicksort Memory: 437kB
4. 4.723 66.719 ↑ 1.2 1,667 3 / 3

Nested Loop Left Join (cost=88.20..18,921.85 rows=2,023 width=281) (actual time=2.830..66.719 rows=1,667 loops=3)

5. 4.861 56.996 ↑ 1.2 1,667 3 / 3

Nested Loop Left Join (cost=87.92..18,304.14 rows=2,023 width=272) (actual time=2.821..56.996 rows=1,667 loops=3)

6. 4.716 40.468 ↑ 1.2 1,667 3 / 3

Hash Left Join (cost=87.49..14,305.25 rows=2,023 width=260) (actual time=2.803..40.468 rows=1,667 loops=3)

  • Hash Cond: (assetentit0_.asset_group_id = assetgroup4_.id)
7. 2.634 34.636 ↑ 1.2 1,667 3 / 3

Nested Loop (cost=58.40..14,270.81 rows=2,023 width=255) (actual time=0.275..34.636 rows=1,667 loops=3)

8. 2.835 27.002 ↑ 1.2 1,667 3 / 3

Nested Loop Left Join (cost=57.98..11,658.12 rows=2,023 width=231) (actual time=0.264..27.002 rows=1,667 loops=3)

9. 6.564 17.500 ↑ 1.2 1,667 3 / 3

Nested Loop (cost=57.55..8,215.86 rows=2,023 width=219) (actual time=0.256..17.500 rows=1,667 loops=3)

10. 2.392 2.603 ↑ 1.2 1,667 3 / 3

Parallel Bitmap Heap Scan on asset assetentit0_ (cost=57.13..4,773.60 rows=2,023 width=207) (actual time=0.244..2.603 rows=1,667 loops=3)

  • Recheck Cond: (tenant_id = '888'::bigint)
  • Filter: (((asset_status)::text <> 'BRK'::text) AND (row_status = 'A'::bpchar))
  • Heap Blocks: exact=45
11. 0.211 0.211 ↓ 1.0 5,000 1 / 3

Bitmap Index Scan on asset_tenant_id_scancode_idx (cost=0.00..55.91 rows=4,865 width=0) (actual time=0.632..0.632 rows=5,000 loops=1)

  • Index Cond: (tenant_id = '888'::bigint)
12. 8.333 8.333 ↑ 1.0 1 5,000 / 3

Index Scan using pk_location on location locationen1_ (cost=0.42..1.70 rows=1 width=28) (actual time=0.005..0.005 rows=1 loops=5,000)

  • Index Cond: (location_id = assetentit0_.default_location_id)
13. 6.667 6.667 ↑ 1.0 1 5,000 / 3

Index Scan using pk_location on location locationen2_ (cost=0.42..1.70 rows=1 width=28) (actual time=0.004..0.004 rows=1 loops=5,000)

  • Index Cond: (assetentit0_.current_location_id = location_id)
14. 5.000 5.000 ↑ 1.0 1 5,000 / 3

Index Scan using pk_employee on employee workerenti3_ (cost=0.42..1.29 rows=1 width=40) (actual time=0.003..0.003 rows=1 loops=5,000)

  • Index Cond: (employee_id = assetentit0_.responsible_employee_id)
15. 0.535 1.116 ↓ 1.0 826 3 / 3

Hash (cost=19.04..19.04 rows=804 width=21) (actual time=1.116..1.116 rows=826 loops=3)

  • Buckets: 1024 Batches: 1 Memory Usage: 54kB
16. 0.581 0.581 ↓ 1.0 826 3 / 3

Seq Scan on asset_group assetgroup4_ (cost=0.00..19.04 rows=804 width=21) (actual time=0.013..0.581 rows=826 loops=3)

17. 11.667 11.667 ↑ 1.0 1 5,000 / 3

Index Scan using pk_asset_additional_field on asset_additional_field assetaddit5_ (cost=0.43..1.98 rows=1 width=28) (actual time=0.007..0.007 rows=1 loops=5,000)

  • Index Cond: (assetentit0_.additional_field_id = id)
18. 5.000 5.000 ↑ 1.0 1 5,000 / 3

Index Scan using pk_asset_manufacturer on asset_manufacturer assetmanuf6_ (cost=0.29..0.31 rows=1 width=21) (actual time=0.003..0.003 rows=1 loops=5,000)

  • Index Cond: (assetaddit5_.manufacturer_id = id)
Planning time : 4.368 ms
Execution time : 119.826 ms