explain.depesz.com

PostgreSQL's explain analyze made readable

Result: o9i4

Settings
# exclusive inclusive rows x rows loops node
1. 0.011 1.836 ↑ 48.5 2 1

Nested Loop (cost=2.38..376.30 rows=97 width=121) (actual time=1.298..1.836 rows=2 loops=1)

2. 0.015 0.015 ↑ 1.0 1 1

Index Scan using locations_units_pkey on locations_units lu (cost=0.42..2.84 rows=1 width=8) (actual time=0.015..0.015 rows=1 loops=1)

  • Index Cond: (id = 379958)
3. 0.005 1.810 ↑ 48.5 2 1

Nested Loop (cost=1.96..372.01 rows=97 width=117) (actual time=1.278..1.810 rows=2 loops=1)

  • Join Filter: (lua.type_id = luat.id)
  • Rows Removed by Join Filter: 2
4. 0.019 1.795 ↑ 48.5 2 1

Hash Join (cost=1.96..368.08 rows=97 width=113) (actual time=1.271..1.795 rows=2 loops=1)

  • Hash Cond: (lua.status_id = luas.id)
5. 0.007 1.765 ↑ 48.5 2 1

Nested Loop (cost=0.84..365.63 rows=97 width=106) (actual time=1.246..1.765 rows=2 loops=1)

6. 1.742 1.742 ↑ 48.5 2 1

Index Scan using idx_locations_units_assets_unit_id on locations_units_assets lua (cost=0.42..92.78 rows=97 width=88) (actual time=1.234..1.742 rows=2 loops=1)

  • Index Cond: (unit_id = 379958)
7. 0.016 0.016 ↑ 1.0 1 2

Index Scan using processors_pkey on processors p (cost=0.42..2.80 rows=1 width=22) (actual time=0.007..0.008 rows=1 loops=2)

  • Index Cond: (id = lua.processor_id)
8. 0.006 0.011 ↑ 1.0 5 1

Hash (cost=1.05..1.05 rows=5 width=11) (actual time=0.011..0.011 rows=5 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
9. 0.005 0.005 ↑ 1.0 5 1

Seq Scan on locations_units_assets_status luas (cost=0.00..1.05 rows=5 width=11) (actual time=0.002..0.005 rows=5 loops=1)

10. 0.009 0.010 ↑ 1.0 2 2

Materialize (cost=0.00..1.03 rows=2 width=8) (actual time=0.002..0.005 rows=2 loops=2)

11. 0.001 0.001 ↑ 1.0 2 1

Seq Scan on locations_units_assets_types luat (cost=0.00..1.02 rows=2 width=8) (actual time=0.001..0.001 rows=2 loops=1)

Planning time : 5.122 ms
Execution time : 1.924 ms