explain.depesz.com

PostgreSQL's explain analyze made readable

Result: GXQk : TEST

Settings
# exclusive inclusive rows x rows loops node
1. 0.073 2.669 ↑ 1.0 100 1

Limit (cost=2.69..810.80 rows=100 width=281) (actual time=0.072..2.669 rows=100 loops=1)

2. 0.153 2.596 ↑ 48.6 100 1

Nested Loop Left Join (cost=2.69..39,317.45 rows=4,865 width=281) (actual time=0.070..2.596 rows=100 loops=1)

3. 0.135 2.243 ↑ 48.6 100 1

Nested Loop Left Join (cost=2.40..37,831.96 rows=4,865 width=272) (actual time=0.063..2.243 rows=100 loops=1)

4. 0.144 1.808 ↑ 48.6 100 1

Nested Loop Left Join (cost=1.97..28,218.03 rows=4,865 width=260) (actual time=0.055..1.808 rows=100 loops=1)

5. 0.127 1.464 ↑ 48.6 100 1

Nested Loop (cost=1.70..26,779.14 rows=4,865 width=255) (actual time=0.049..1.464 rows=100 loops=1)

6. 0.177 1.037 ↑ 48.6 100 1

Nested Loop Left Join (cost=1.28..20,499.71 rows=4,865 width=231) (actual time=0.040..1.037 rows=100 loops=1)

7. 0.175 0.660 ↑ 48.6 100 1

Nested Loop (cost=0.85..12,226.94 rows=4,865 width=219) (actual time=0.034..0.660 rows=100 loops=1)

8. 0.185 0.185 ↑ 48.6 100 1

Index Scan using asset_tenant_id_scancode_idx on asset assetentit0_ (cost=0.43..3,954.18 rows=4,865 width=207) (actual time=0.022..0.185 rows=100 loops=1)

  • Index Cond: (tenant_id = '888'::bigint)
9. 0.300 0.300 ↑ 1.0 1 100

Index Scan using pk_location on location locationen1_ (cost=0.42..1.70 rows=1 width=28) (actual time=0.003..0.003 rows=1 loops=100)

  • Index Cond: (location_id = assetentit0_.default_location_id)
10. 0.200 0.200 ↑ 1.0 1 100

Index Scan using pk_location on location locationen2_ (cost=0.42..1.70 rows=1 width=28) (actual time=0.002..0.002 rows=1 loops=100)

  • Index Cond: (assetentit0_.current_location_id = location_id)
11. 0.300 0.300 ↑ 1.0 1 100

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=100)

  • Index Cond: (employee_id = assetentit0_.responsible_employee_id)
12. 0.200 0.200 ↑ 1.0 1 100

Index Scan using pk_asset_group on asset_group assetgroup4_ (cost=0.28..0.30 rows=1 width=21) (actual time=0.002..0.002 rows=1 loops=100)

  • Index Cond: (assetentit0_.asset_group_id = id)
13. 0.300 0.300 ↑ 1.0 1 100

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=100)

  • Index Cond: (assetentit0_.additional_field_id = id)
14. 0.200 0.200 ↑ 1.0 1 100

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=100)

  • Index Cond: (assetaddit5_.manufacturer_id = id)
Planning time : 2.741 ms
Execution time : 2.840 ms