explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 93zQ

Settings
# exclusive inclusive rows x rows loops node
1. 0.002 313,053.151 ↓ 0.0 0 1

Update on public.maximoticket (cost=10,015.52..20,144.17 rows=2,115 width=5,114) (actual time=313,053.151..313,053.151 rows=0 loops=1)

2. 2,527.064 313,053.149 ↓ 0.0 0 1

Hash Join (cost=10,015.52..20,144.17 rows=2,115 width=5,114) (actual time=313,053.149..313,053.149 rows=0 loops=1)

  • Output: maximoticket.id, NULL::integer, NULL::integer, NULL::integer, NULL::integer, NULL::integer, NULL::integer, NULL::integer, NULL::integer, NULL::integer, NULL::integer, NULL::integer, NULL::integer, NULL::integer, maximoticket.maximo_id, maximoticket.tally, maximoticket.activealarm_id, maximoticket.createddate, maximoticket.isclear, maximoticket.isdelete, maximoticket.output, 'ACR'::character varying(255), maximoticket.updateddate, maximoticket.lastdate, maximoticket.ctid, tt.*
  • Hash Cond: (tt.ttid = (maximoticket.id)::numeric)
3. 310,525.655 310,525.655 ↓ 5,374.5 5,374,531 1

Foreign Scan on maximo_schema.tt (cost=10,000.00..20,000.00 rows=1,000 width=4,516) (actual time=28.708..310,525.655 rows=5,374,531 loops=1)

  • Output: tt.*, tt.ttid
  • Oracle query: SELECT /*87068c2bd6640800b139c5b49626127a*/ r2."TTID", r2."DESCRIPTION", r2."STATUS", r2."STATUSDATE", r2."NCSERIAL", r2."LOCATION", r2."CHANGEBY", r2."HASLD", r2."CHANGEDATE", r2."REPORTEDBY", r2."REPORTDATE", r2."PROBLEMCODE", r2."FAILURECODE", r2."OUTAGERESPONSIBLE", r2."TTCATEGORY", r2."OWNERGROUP", r2."FLAG", r2."PROBLEMCAUSE", r2."REMARKS", r2."PRIORITYLEVEL", r2."ALARMENDDATE", r2."TTRESOLUTIONTIME", r2."DEADLINE", r2."OUTAGEEXPREASON", r2."ALARMSTARTDATE", r2."SEVERITY", r2."TTCREATEDURATION", r2."RESPONSETIME", r2."TALLY", r2."APPROVED", r2."ALARMTYPE", r2."TURKTELEKOMTTNO", r2."VENDOR", r2."RANNOCISSUETYPE", r2."DEVICEID", r2."ALARMCAUSE", r2."ROWSTAMP", r2."DEPARTMENT", r2."ORIGINATOR", r2."SITEID", r2."ORGID", r2."UPDATED_SITENAME", r2."CREATEOWS", r2."CLEAROWS" FROM "MAXIMO"."TT" r2 WHERE (r2."STATUS" = 'ACR')
  • Oracle plan: SELECT STATEMENT
  • Oracle plan: TABLE ACCESS FULL TT (filter "R2"."STATUS"='ACR')
4. 0.177 0.430 ↑ 1.0 423 1

Hash (cost=10.23..10.23 rows=423 width=62) (actual time=0.429..0.430 rows=423 loops=1)

  • Output: maximoticket.id, maximoticket.maximo_id, maximoticket.tally, maximoticket.activealarm_id, maximoticket.createddate, maximoticket.isclear, maximoticket.isdelete, maximoticket.output, maximoticket.updateddate, maximoticket.lastdate, maximoticket.ctid
  • Buckets: 1024 Batches: 1 Memory Usage: 51kB
5. 0.253 0.253 ↑ 1.0 423 1

Seq Scan on public.maximoticket (cost=0.00..10.23 rows=423 width=62) (actual time=0.072..0.253 rows=423 loops=1)

  • Output: maximoticket.id, maximoticket.maximo_id, maximoticket.tally, maximoticket.activealarm_id, maximoticket.createddate, maximoticket.isclear, maximoticket.isdelete, maximoticket.output, maximoticket.updateddate, maximoticket.lastdate, maximoticket.ctid
Planning time : 21.024 ms
Execution time : 313,053.313 ms