explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 2x4a : TEST

Settings
# exclusive inclusive rows x rows loops node
1. 1.412 19.345 ↑ 1.0 1 1

Aggregate (cost=6,308.48..6,308.49 rows=1 width=8) (actual time=19.345..19.345 rows=1 loops=1)

2. 6.255 17.933 ↓ 1.0 5,000 1

Nested Loop (cost=0.85..6,296.34 rows=4,858 width=767) (actual time=0.079..17.933 rows=5,000 loops=1)

3. 6.678 6.678 ↓ 1.0 5,000 1

Index Scan using asset_idx_1 on asset assetentit0_ (cost=0.43..3,328.96 rows=4,858 width=791) (actual time=0.031..6.678 rows=5,000 loops=1)

  • Index Cond: (tenant_id = '888'::bigint)
  • Filter: (((asset_status)::text <> 'BRK'::text) AND (row_status = 'A'::bpchar))
4. 5.000 5.000 ↑ 1.0 1 5,000

Index Only Scan using pk_employee on employee workerenti3_ (cost=0.42..0.61 rows=1 width=8) (actual time=0.001..0.001 rows=1 loops=5,000)

  • Index Cond: (employee_id = assetentit0_.responsible_employee_id)
  • Heap Fetches: 0
Planning time : 0.328 ms
Execution time : 19.393 ms