explain.depesz.com

PostgreSQL's explain analyze made readable

Result: vJ7K

Settings
# exclusive inclusive rows x rows loops node
1. 0.684 1,188.778 ↓ 2.4 169 1

GroupAggregate (cost=35,562.53..35,563.93 rows=70 width=17) (actual time=1,187.999..1,188.778 rows=169 loops=1)

  • Group Key: st.assetidval, st.status
2. 1.683 1,188.094 ↓ 41.1 2,880 1

Sort (cost=35,562.53..35,562.70 rows=70 width=13) (actual time=1,187.974..1,188.094 rows=2,880 loops=1)

  • Sort Key: st.assetidval, st.status
  • Sort Method: quicksort Memory: 232kB
3. 0.000 1,186.411 ↓ 41.1 2,880 1

Nested Loop (cost=1,001.14..35,560.38 rows=70 width=13) (actual time=10.285..1,186.411 rows=2,880 loops=1)

4. 135.983 1,308.433 ↓ 8.6 4,678 1

Gather (cost=1,001.00..35,469.32 rows=543 width=13) (actual time=1.057..1,308.433 rows=4,678 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
5. 1,134.613 1,172.450 ↓ 6.9 1,559 3

Nested Loop (cost=0.99..34,415.02 rows=226 width=13) (actual time=0.342..1,172.450 rows=1,559 loops=3)

6. 9.510 37.460 ↓ 1.8 3,006 3

Nested Loop (cost=0.43..14,011.85 rows=1,687 width=4) (actual time=0.106..37.460 rows=3,006 loops=3)

7. 27.938 27.938 ↓ 2.0 693 3

Parallel Seq Scan on machdefs md (cost=0.00..11,727.85 rows=354 width=4) (actual time=0.086..27.938 rows=693 loops=3)

  • Filter: ((rhdue IS NULL) AND (((((pms_importance)::integer & 2) = 2) AND (application <> 'Spare Parts Short Inventory Report'::text)) OR (application = 'Critical Equipment Performance Test'::text)))
  • Rows Removed by Filter: 155734
8. 0.012 0.012 ↑ 2.8 4 2,079

Index Scan using items_defid on items it (cost=0.43..6.34 rows=11 width=8) (actual time=0.006..0.012 rows=4 loops=2,079)

  • Index Cond: (defid = md.defid)
9. 0.377 0.377 ↑ 3.0 1 9,018

Index Scan using status_apptblidval on status st (cost=0.56..12.06 rows=3 width=13) (actual time=0.288..0.377 rows=1 loops=9,018)

  • Index Cond: (apptblidval = it.id)
  • Filter: (isvalid AND ((colname)::text = ANY ('{lastrepdate,lastinspdate}'::text[])) AND ((appname)::text = 'ISM PMS'::text) AND ((apptblname)::text = 'items'::text) AND ((assettable)::text = 'vessels'::text))
  • Rows Removed by Filter: 264
10. 14.034 14.034 ↑ 1.0 1 4,678

Index Scan using vessels_pkey on vessels (cost=0.15..0.17 rows=1 width=4) (actual time=0.003..0.003 rows=1 loops=4,678)

  • Index Cond: (id = st.assetidval)
  • Filter: ((vslstatus)::text = 'Active'::text)
  • Rows Removed by Filter: 0
Planning time : 1.429 ms
Execution time : 1,327.882 ms