explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Rewe

Settings
# exclusive inclusive rows x rows loops node
1. 8.153 46.412 ↑ 18.0 1 1

Gather (cost=1,001.27..23,186.88 rows=18 width=4) (actual time=43.696..46.412 rows=1 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
2. 0.005 38.259 ↓ 0.0 0 3 / 3

Nested Loop Semi Join (cost=1.27..22,185.08 rows=8 width=4) (actual time=38.257..38.259 rows=0 loops=3)

3. 0.004 38.244 ↓ 0.0 0 3 / 3

Nested Loop (cost=0.85..22,108.26 rows=172 width=8) (actual time=38.243..38.244 rows=0 loops=3)

4. 38.232 38.232 ↓ 0.0 0 3 / 3

Parallel Index Only Scan using idx_test2 on taskdenormalizedhierarchy tdh (cost=0.43..20,702.36 rows=172 width=4) (actual time=38.231..38.232 rows=0 loops=3)

  • Index Cond: (taskownerid = 2)
  • Heap Fetches: 0
5. 0.008 0.008 ↑ 1.0 1 1 / 3

Index Scan using task_pkey on task task3 (cost=0.43..8.17 rows=1 width=8) (actual time=0.023..0.023 rows=1 loops=1)

  • Index Cond: (id = tdh.taskid)
6. 0.010 0.010 ↑ 1.0 1 1 / 3

Index Scan using uix4pkv_uniquekeyuri on projectkeyvalue projectkeyvalue5 (cost=0.41..0.45 rows=1 width=4) (actual time=0.031..0.031 rows=1 loops=1)

  • Index Cond: ((projectid = task3.projectid) AND (upper(keyuri) = 'URN:REPLICON:PROJECT-KEY-VALUE-KEY:PROJECT-MANAGEMENT-TYPE'::text))
  • Filter: (upper(uri) = 'URN:REPLICON:PROJECT-MANAGEMENT-TYPE:MANAGED'::text)
Planning time : 0.786 ms
Execution time : 46.470 ms