explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 2Xo4 : testtt

Settings
# exclusive inclusive rows x rows loops node
1. 0.066 1.819 ↑ 1.0 100 1

Limit (cost=2.69..811.60 rows=100 width=281) (actual time=0.047..1.819 rows=100 loops=1)

2. 0.150 1.753 ↑ 48.7 100 1

Nested Loop Left Join (cost=2.69..39,380.37 rows=4,868 width=281) (actual time=0.046..1.753 rows=100 loops=1)

3. 0.081 1.503 ↑ 48.7 100 1

Nested Loop Left Join (cost=2.40..37,893.96 rows=4,868 width=272) (actual time=0.042..1.503 rows=100 loops=1)

4. 0.140 1.222 ↑ 48.7 100 1

Nested Loop Left Join (cost=1.97..28,274.70 rows=4,868 width=260) (actual time=0.036..1.222 rows=100 loops=1)

5. 0.068 0.982 ↑ 48.7 100 1

Nested Loop (cost=1.70..26,834.94 rows=4,868 width=255) (actual time=0.033..0.982 rows=100 loops=1)

6. 0.089 0.714 ↑ 48.7 100 1

Nested Loop Left Join (cost=1.28..20,553.19 rows=4,868 width=231) (actual time=0.026..0.714 rows=100 loops=1)

7. 0.103 0.425 ↑ 48.7 100 1

Nested Loop (cost=0.85..12,277.10 rows=4,868 width=219) (actual time=0.022..0.425 rows=100 loops=1)

8. 0.122 0.122 ↑ 48.7 100 1

Index Scan using asset_tenant_1id_idx on asset assetentit0_ (cost=0.43..4,001.01 rows=4,868 width=207) (actual time=0.015..0.122 rows=100 loops=1)

  • Index Cond: (tenant_id = '888'::bigint)
  • Filter: (((asset_status)::text <> 'BRK'::text) AND (row_status = 'A'::bpchar))
9. 0.200 0.200 ↑ 1.0 1 100

Index Scan using pk_location on location locationen1_ (cost=0.42..1.70 rows=1 width=28) (actual time=0.002..0.002 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.200 0.200 ↑ 1.0 1 100

Index Scan using pk_employee on employee workerenti3_ (cost=0.42..1.29 rows=1 width=40) (actual time=0.002..0.002 rows=1 loops=100)

  • Index Cond: (employee_id = assetentit0_.responsible_employee_id)
12. 0.100 0.100 ↑ 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.001..0.001 rows=1 loops=100)

  • Index Cond: (assetentit0_.asset_group_id = id)
13. 0.200 0.200 ↑ 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.002..0.002 rows=1 loops=100)

  • Index Cond: (assetentit0_.additional_field_id = id)
14. 0.100 0.100 ↑ 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.001..0.001 rows=1 loops=100)

  • Index Cond: (assetaddit5_.manufacturer_id = id)
Planning time : 3.600 ms
Execution time : 1.953 ms