explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Tn28

Settings
# exclusive inclusive rows x rows loops node
1. 0.003 0.094 ↑ 1.0 1 1

Nested Loop (cost=0.99..25.07 rows=1 width=56) (actual time=0.094..0.094 rows=1 loops=1)

2. 0.005 0.077 ↑ 1.0 1 1

Nested Loop (cost=0.70..16.77 rows=1 width=41) (actual time=0.076..0.077 rows=1 loops=1)

3. 0.013 0.055 ↑ 1.0 1 1

GroupAggregate (cost=0.41..8.45 rows=1 width=30) (actual time=0.055..0.055 rows=1 loops=1)

  • Group Key: wot.user_id, wot.workorder_id
4. 0.042 0.042 ↓ 3.0 3 1

Index Scan using work_order_timer_report_ri_ui_wi_idx on derived_work_order_timer_report wot (cost=0.41..8.43 rows=1 width=26) (actual time=0.040..0.042 rows=3 loops=1)

  • Index Cond: ((role_id)::text = '55FaBPjE9V'::text)
5. 0.017 0.017 ↑ 1.0 1 1

Index Scan using work_order_pkey on work_order wo (cost=0.29..8.31 rows=1 width=33) (actual time=0.017..0.017 rows=1 loops=1)

  • Index Cond: (id = (wot.workorder_id)::text)
6. 0.014 0.014 ↑ 1.0 1 1

Index Scan using _user_pkey on _user u (cost=0.29..8.31 rows=1 width=37) (actual time=0.014..0.014 rows=1 loops=1)

  • Index Cond: (id = (wot.user_id)::text)
Planning time : 0.410 ms
Execution time : 0.246 ms