explain.depesz.com

PostgreSQL's explain analyze made readable

Result: iMFB

Settings
# exclusive inclusive rows x rows loops node
1. 0.364 12,834.680 ↓ 0.0 0 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
2. 12,834.105 12,834.105 ↓ 0.0 0 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
3. 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
4. 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
5. 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
6. 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':