explain.depesz.com

PostgreSQL's explain analyze made readable

Result: zrKib : test

Settings
# exclusive inclusive rows x rows loops node
1. 0.038 58,194.405 ↑ 351.0 1 1

Nested Loop Left Join (cost=1,002.01..1,423,012.21 rows=351 width=1,745) (actual time=58,194.384..58,194.405 rows=1 loops=1)

2. 0.050 58,193.787 ↑ 74.0 1 1

Nested Loop Left Join (cost=1,001.32..1,421,173.04 rows=74 width=1,301) (actual time=58,193.774..58,193.787 rows=1 loops=1)

3. 0.000 58,193.645 ↑ 51.0 1 1

Limit (cost=1,000.62..1,420,727.43 rows=51 width=982) (actual time=58,193.640..58,193.645 rows=1 loops=1)

4. 58,665.951 58,665.951 ↑ 306.0 1 1

Gather Merge (cost=1,000.62..8,519,361.46 rows=306 width=982) (actual time=58,193.627..58,665.951 rows=1 loops=1)

  • Workers Planned: 4
  • Workers Launched: 4
  • -> Parallel Index Scan using managed_identifier_pkey on managed_identifier obj (cost=0.56..8518324.95 rows=76 width=982) (actual time=58,161.173..58187.971 rows=0 loops=5
  • Filter: ((emailaddr)::text ~~ 'kevinjo47@yahoo.co.id%'::text)
  • Rows Removed by Filter: 12,055,783
5. 0.092 0.092 ↓ 0.0 0 1

Index Scan using idx_json_relationships_second_object on relationships second (cost=0.70..8.72 rows=1 width=450) (actual time=0.092..0.092 rows=0 loops=1)

  • Index Cond: (((secondresourcecollection)::text = 'managed/Identifier'::text) AND ((secondresourceid)::text = (obj.objectid)::text) AND ((secondpropertyname)::text = 'application
6. 0.580 0.580 ↑ 5.0 1 1

Index Scan using idx_json_relationships_first_object on relationships first (cost=0.70..24.80 rows=5 width=444) (actual time=0.579..0.580 rows=1 loops=1)

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