explain.depesz.com

PostgreSQL's explain analyze made readable

Result: dgrI : TEST

Settings
# exclusive inclusive rows x rows loops node
1. 0.064 2.506 ↑ 1.0 100 1

Limit (cost=2.69..798.39 rows=100 width=281) (actual time=0.081..2.506 rows=100 loops=1)

2. 0.125 2.442 ↑ 48.6 100 1

Nested Loop Left Join (cost=2.69..38,641.86 rows=4,856 width=281) (actual time=0.079..2.442 rows=100 loops=1)

3. 0.110 2.117 ↑ 48.6 100 1

Nested Loop Left Join (cost=2.40..37,159.11 rows=4,856 width=272) (actual time=0.073..2.117 rows=100 loops=1)

4. 0.115 1.707 ↑ 48.6 100 1

Nested Loop Left Join (cost=1.97..27,560.19 rows=4,856 width=260) (actual time=0.063..1.707 rows=100 loops=1)

5. 0.184 1.392 ↑ 48.6 100 1

Nested Loop (cost=1.70..26,123.94 rows=4,856 width=255) (actual time=0.057..1.392 rows=100 loops=1)

6. 0.145 1.008 ↑ 48.6 100 1

Nested Loop Left Join (cost=1.28..19,852.44 rows=4,856 width=231) (actual time=0.049..1.008 rows=100 loops=1)

7. 0.121 0.663 ↑ 48.6 100 1

Nested Loop (cost=0.85..11,589.66 rows=4,856 width=219) (actual time=0.043..0.663 rows=100 loops=1)

8. 0.242 0.242 ↑ 48.6 100 1

Index Scan using asset_idx_1 on asset assetentit0_ (cost=0.43..3,326.88 rows=4,856 width=207) (actual time=0.031..0.242 rows=100 loops=1)

  • Index Cond: (tenant_id = '888'::bigint)
  • Filter: (((asset_status)::text <> 'BRK'::text) AND (row_status = 'A'::bpchar))
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.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.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 : 3.238 ms
Execution time : 2.696 ms