explain.depesz.com

PostgreSQL's explain analyze made readable

Result: rlLl : testtt

Settings
# exclusive inclusive rows x rows loops node
1. 0.071 123.269 ↑ 1.0 100 1

Limit (cost=20,060.75..20,072.42 rows=100 width=281) (actual time=120.269..123.269 rows=100 loops=1)

2. 13.133 123.198 ↑ 40.6 100 1

Gather Merge (cost=20,060.75..20,533.99 rows=4,056 width=281) (actual time=120.267..123.198 rows=100 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
3. 40.161 110.065 ↑ 8.9 228 3 / 3

Sort (cost=19,060.73..19,065.80 rows=2,028 width=281) (actual time=109.980..110.065 rows=228 loops=3)

  • Sort Key: assetentit0_.scan_code
  • Sort Method: quicksort Memory: 433kB
4. 6.306 69.904 ↑ 1.2 1,667 3 / 3

Nested Loop Left Join (cost=83.26..18,949.33 rows=2,028 width=281) (actual time=2.648..69.904 rows=1,667 loops=3)

5. 3.868 60.265 ↑ 1.2 1,667 3 / 3

Nested Loop Left Join (cost=82.97..18,330.10 rows=2,028 width=272) (actual time=2.640..60.265 rows=1,667 loops=3)

6. 1.997 51.397 ↑ 1.2 1,667 3 / 3

Hash Left Join (cost=82.54..14,322.73 rows=2,028 width=260) (actual time=2.625..51.397 rows=1,667 loops=3)

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

Nested Loop (cost=53.45..14,288.28 rows=2,028 width=255) (actual time=0.273..47.111 rows=1,667 loops=3)

8. 8.409 37.806 ↑ 1.2 1,667 3 / 3

Nested Loop Left Join (cost=53.03..11,671.32 rows=2,028 width=231) (actual time=0.261..37.806 rows=1,667 loops=3)

9. 3.542 17.730 ↑ 1.2 1,667 3 / 3

Nested Loop (cost=52.61..8,223.51 rows=2,028 width=219) (actual time=0.252..17.730 rows=1,667 loops=3)

10. 2.320 2.521 ↑ 1.2 1,667 3 / 3

Parallel Bitmap Heap Scan on asset assetentit0_ (cost=52.18..4,775.71 rows=2,028 width=207) (actual time=0.234..2.521 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=44
11. 0.201 0.201 ↓ 1.0 5,000 1 / 3

Bitmap Index Scan on asset_idx_1 (cost=0.00..50.97 rows=4,872 width=0) (actual time=0.603..0.604 rows=5,000 loops=1)

  • Index Cond: (tenant_id = '888'::bigint)
12. 11.667 11.667 ↑ 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.007..0.007 rows=1 loops=5,000)

  • Index Cond: (location_id = assetentit0_.default_location_id)
13. 11.667 11.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.007..0.007 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. 1.841 2.289 ↓ 1.0 826 3 / 3

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

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

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

17. 5.000 5.000 ↑ 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.003..0.003 rows=1 loops=5,000)

  • Index Cond: (assetentit0_.additional_field_id = id)
18. 3.333 3.333 ↑ 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.002..0.002 rows=1 loops=5,000)

  • Index Cond: (assetaddit5_.manufacturer_id = id)
Planning time : 3.897 ms
Execution time : 123.490 ms