explain.depesz.com

PostgreSQL's explain analyze made readable

Result: q9Pc

Settings
# exclusive inclusive rows x rows loops node
1. 0.036 2,572.540 ↑ 351.0 1 1

Nested Loop Left Join (cost=1,768,330.55..1,770,614.87 rows=351 width=1,745) (actual time=2,572.527..2,572.540 rows=1 loops=1)

2. 0.079 2,572.421 ↑ 74.0 1 1

Nested Loop Left Join (cost=1,768,325.79..1,768,773.20 rows=74 width=1,301) (actual time=2,572.412..2,572.421 rows=1 loops=1)

3. 0.000 2,572.214 ↑ 51.0 1 1

Limit (cost=1,768,321.09..1,768,327.19 rows=51 width=982) (actual time=2,572.209..2,572.214 rows=1 loops=1)

4. 23.249 2,590.185 ↑ 304.0 1 1

Gather Merge (cost=1,768,321.09..1,768,357.48 rows=304 width=982) (actual time=2,572.201..2,590.185 rows=1 loops=1)

  • Workers Planned: 4
  • Workers Launched: 4
5. 0.115 2,566.936 ↓ 0.0 0 5 / 5

Sort (cost=1,767,321.03..1,767,321.22 rows=76 width=982) (actual time=2,566.936..2,566.936 rows=0 loops=5)

  • Sort Key: obj.objectid
  • Sort Method: quicksort Memory: 25kB
  • Worker 0: Sort Method: quicksort Memory: 25kB
  • Worker 1: Sort Method: quicksort Memory: 26kB
  • Worker 2: Sort Method: quicksort Memory: 25kB
  • Worker 3: Sort Method: quicksort Memory: 25kB
6. 2,566.821 2,566.821 ↓ 0.0 0 5 / 5

Parallel Seq Scan on managed_identifier obj (cost=0.00..1,767,318.65 rows=76 width=982) (actual time=2,225.239..2,566.821 rows=0 loops=5)

  • Filter: ((emailaddr)::text ~~ 'kevinjo47@yahoo.co.id%'::text)
  • Rows Removed by Filter: 12,056,499
7. 0.030 0.128 ↓ 0.0 0 1

Bitmap Heap Scan on relationships second (cost=4.71..8.73 rows=1 width=450) (actual time=0.128..0.128 rows=0 loops=1)

  • Recheck Cond: (((secondresourcecollection)::text = 'managed/Identifier'::text) AND ((secondresourceid)::text = (obj.objectid)::text) AND ((secondpropertyname)::text = 'applicati
8. 0.098 0.098 ↓ 0.0 0 1

Bitmap Index Scan on idx_json_relationships_second_object (cost=0.00..4.71 rows=1 width=0) (actual time=0.098..0.098 rows=0 loops=1)

  • Index Cond: (((secondresourcecollection)::text = 'managed/Identifier'::text) AND ((secondresourceid)::text = (obj.objectid)::text) AND ((secondpropertyname)::text = 'appli
9. 0.033 0.083 ↑ 5.0 1 1

Bitmap Heap Scan on relationships first (cost=4.76..24.84 rows=5 width=444) (actual time=0.083..0.083 rows=1 loops=1)

  • Recheck Cond: (((firstresourcecollection)::text = 'managed/Identifier'::text) AND ((firstresourceid)::text = (obj.objectid)::text) AND ((firstpropertyname)::text = 'applications'::tex
  • Heap Blocks: exact=1
10. 0.050 0.050 ↑ 5.0 1 1

Bitmap Index Scan on idx_json_relationships_first_object (cost=0.00..4.76 rows=5 width=0) (actual time=0.050..0.050 rows=1 loops=1)

  • Index Cond: (((firstresourcecollection)::text = 'managed/Identifier'::text) AND ((firstresourceid)::text = (obj.objectid)::text) AND ((firstpropertyname)::text = 'applications':
Planning time : 3.216 ms
Execution time : 2,590.776 ms